How can i show the total VC just once in my app (View)?

AppSheet AppSheet Q&A
1

I have a VC that totals (sum) the column for me but it shows up in the app view for each row:

3X_c_d_cddaf147e652c578892c99e116e1887cc741ff72.png
3X_c_d_cddaf147e652c578892c99e116e1887cc741ff72.png1555Ă—728 42.3 KB

I want to show it just once.

2

Use a slice.

3

Got it. Duh! Thanks Steve

1 Like
4

Steve,
I am having the same issue for another table and I cannot figure it out.

Here is the raw data in my table:

3X_e_b_eb18273b136c915cada8b2253080e7f24857c609.png

I want the view in my app “card” to ONLY show once - the “Total Shipped” and percent radial gauge, but i get it shown twice because i have two entries in the raw data:

3X_2_d_2d41436e36731cf942f36c3176fd2c1f547825b5.png
3X_2_d_2d41436e36731cf942f36c3176fd2c1f547825b5.png783Ă—627 14.1 KB

How can i show the radial gauge with the data only ONCE in my card view no matter how entries i have in the table?

5

You have to base the chart on a slice that includes only the rows you want included. If the user navigates to the chart view, I believe you can use LINKTOFILTEREDVIEW() to limit the rows used even further.

6

I am only including current day - TODAY(). However, I wan the total shown once. Because there are two entries it is showing the same total view twice:

3X_b_6_b62a3476922a8ba606f084020455c58a782ffd26.png
3X_b_6_b62a3476922a8ba606f084020455c58a782ffd26.png776Ă—808 38.4 KB

Here is the expression i am using to get [Percent shipped to total today]:

IF( [Date Delivered to Lab] = TODAY(),
[Totals Received for today] / DECIMAL( [Totals Shipped for today]) , 0
)

Steve,
So i needed to create another table - “Totals Table” and now it works.\

Thanks for the help…

1 Like
7

Or just use the slice:

(
  [_THISROW]
  = MAXROW(
    "Results Table",
    "_ROWNUMBER",
    ([Date Delivered to Lab] = TODAY())
  )
)
8

worked PERFECT!

Thanks again!

1 Like