Best Of

Re: Supress Zero Value rows in Pivot table

You can filter out any value from being included in the pivot table that has a zero value like this:

Screen Shot 2023-08-17 at 11.44.39 AM.png

ColemenWilson

1

Dataset to display the underlying DB table/view in Overview Tab

It's good to know the underlying databse table or view on which the dataset is created in order to backtrack any issues. In case developer of the dataset leaves role/org it's difficult to find the datasource table/view name.

TejalGovila

2

Re: Want to add minutes of a particular day from different rows

It all depends on what want to achieve. In general if you just want to display the Date with the Total minutes you can achieve this the way @colemenwilson suggested, selecting only these 2 fields and setting your card to display by Day. This will give you a single entry per day with the Total Downtime for and this will even allow you to switch to see total downtime on different periods.

If you add other fields to the card, you'll get the total downtime at that granularity, like if instead you have Date, Ticket and SUM (Downtime) then what you'll be showing is the total daily downtime by ticket.

On the other hand if what you need is to show all entries but want the total Daily Downtime as another column, you can do this via BeastMode with the FIXED function (so that it'll be an additional column in the table you shared):

SUM(SUM(`Downtime in Minutes`) FIXED (BY DATE(`Start Time`)))

Keep in mind that regardless of the approach you'll need to define how you want to address if there is downtime entries that span across multiple days, like if it stars 2022-08-15 23:20:00 and ends 2022-08-06 01:17:02.

Hope this helps!