Running Percent Total in Pivot Table

[Max]

That becomes an issue of there not being any data to count. In order to fix that I would look to either add data via sql, or look to use lag functions.

How to fill in zeroes for dates with no values

Hello, I have an Athena dataset with users who have an email as their userid, and a lastSessionDate field for the last time they have signed in. I am plotting distinct_count(email) vs datediff(lastSessionDate, now()) to visualize how long users are spending between signing into our application. I am able to get this visualization working, but I can’t find a way to have the visual display zero for the dates where nobody signs in. I think I might be able to generate a generic series of dates (ei…

Counting empty cells and replacing with increasing values

thank you! yes it is something like mentioned. i will be trying this.I just want to add one thing that I have scientific data (sensor data) so no missing time (hrs) but missing observed values. (note: I couldn’t share data due to privacy issues)