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

[Tiger1]

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

I want to show it just once.

[Steve]

Use a slice.

[Tiger1]

Got it. Duh! Thanks Steve

[Tiger1]

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

Here is the raw data in my table:

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:

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?

[Steve]

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.

[Tiger1 · Accepted solution]

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:

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…

[Steve]

Or just use the slice:

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

[Tiger1]

worked PERFECT!

Thanks again!