Deduction based on date range

[wellyhartanto]

Hi guys,

I'm new to Looker, so please bear with me 🙂

I have a Google Sheet as the backend for my Looker dashboard, it contains printer usage which basically consists of the printer's name, b/w page usage, and color pages usage. The usage data is collected daily however it is cumulative since the first time the printers were used. For example:

PRINTER NAME	DATE	B/W USAGE	COLOR USAGE
Printer 1	2023-09-01	100	100
Printer 2	2023-09-01	200	200
Printer 1	2023-09-02	110	105
Printer 2	2023-09-02	204	240

I tried to create a dashboard in Looker with date range control in an attempt to show the usage of the printers between certain periods of time. But instead of getting the margin between the "Start Date" and the "End Date",  I'm getting the sum instead.

So, for example in my sample data above, if I select "Start Date" of 2023-09-01 and "End Date" of 2023-09-02 for Printer 1, I get 210 (100 plus 110) for B/W and 205 (100 plus 105) for Color while the data that I want to display is 10 (110 minus 100) for B/W and 5 (105 minus 100) for Color.

How can I achieve this?

Thank you!