Hi,
I would like to improve my water flowmeter record application by show the dashboard (by graph if possible) of daily water consumption.
Currently my application only records the number as shown in the flowmeters (i have 10 flowmeters in different location) daily (manual input by my friend).
I want to add (dashboard) table which automatically daily substract the flowmeter number with previous day so it will calculate the daily water consumption. and then show it as water consumption graph in the dashboard with filter of date range and flowmeter locations.
Anybody could advice me on this?
Thank you
Hi @Mycro
What about:
LOOKUP(
MAX(
SELECT(
FlowMeterDataLogTable[_ROWNUMBER],
AND(
[_THISROW].[FlowMeterLocation] = [FlowMeterLocation],
TODAY()>DATE([TimeStamp])
)
)
),
"FlowMeterDataLogTable",
"_ROWNUMBER",
"FlowMeterLevel"
)
-
[FlowMeterLevel]
For reference:
Hi @Aurelien
Where I have to put this formula?
Hi @Aurelien
let me show you my table structure. Your formula seems correct but does not work for my table structure, the formula resulting 0 value.
Here is my table, how about this?
Thank you anywayโฆ
Hi @Mycro
Can you share the table structure you have on the editor side ?
Screenshots are best
And please share also the app formula expression you have used for your calcuation in the virtual column.
You can wrap the expression using this:
Please indent it as well, for understanding and readibility purpose
Hi @Aurelien ,
I think you may wish to include this important tip of indentation in the following post thread.
One more sugegstion will be to include screenshots wherever it makes sense.
User | Count |
---|---|
41 | |
27 | |
27 | |
20 | |
13 |