Create daily water consumption dashboard

AppSheet AppSheet Q&A
1

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

2

Hi @Mycro

What about:

LOOKUP(
  MAX(
    SELECT(
       FlowMeterDataLogTable[_ROWNUMBER],
       AND(
          [_THISROW].[FlowMeterLocation] = [FlowMeterLocation],
          TODAY()>DATE([TimeStamp])
       )
    )
  ),
  "FlowMeterDataLogTable",
  "_ROWNUMBER",
  "FlowMeterLevel"
)
-
[FlowMeterLevel]

For reference:

[FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()](https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/24216) Tips & Tricks ?

Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW() MINROW() REF_ROWS() SELECT() What is a Key? Adding & updating rows Is this a new row?/Does this row already exist? What is the previous value of this column? Excel alternatives How do I do COUNTIF() or COUNTIFS()? How do I do SUMIF() or SUMIFS()? How do I do VLOOKUP()? Last row of the spreadsheet How do I get the last row of the spreadsheet? How do I get a column value from…

2 Likes
3

Hi @Aurelien

Where I have to put this formula?

4

Hi @Mycro

in a virtual column. The one that will calculate the flowmeter difference.

3X_5_1_514f1fab2a13ab5f40fa194d3af679ba1b8a4f49.png

3X_c_d_cdff6a941a567b0037cf804ec113ceef39ef6450.png
3X_c_d_cdff6a941a567b0037cf804ec113ceef39ef6450.png777×139 8.18 KB

1 Like
5

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?

3X_9_0_90a7fb7d0c288c87c152ac190014843f8b7e4926.png
3X_9_0_90a7fb7d0c288c87c152ac190014843f8b7e4926.png694×133 3.71 KB

Thank you anyway…

6

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:

3X_a_1_a164e74b94a16d5bb50c2d3fcbfc6e1103c1038a.png

Please indent it as well, for understanding and readibility purpose

2 Likes
7

Hi @Aurelien ,

I think you may wish to include this important tip of indentation in the following post thread.

[Guide on How To Create a Community Post](https://community.appsheet.com/t/guide-on-how-to-create-a-community-post/35855) Tips & Tricks ?

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…

One more sugegstion will be to include screenshots wherever it makes sense.

3 Likes