Max
March 13, 2023, 4:03pm
5
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.
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…
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)