Does anyone know how to write a rolling seven day count distinct calculation? Is it even possible? I want to use the result in a line graph showing the count distinct of the prior seven days on any given day.
Hi Joshua,
Today we don’t have a way to compute rolling/running distinct count calculations natively in QuickSight. We do have a road map item to support such functions natively.
As far as for the workaround you might have to perform such computation in data-prep using joins.
Thanks,
Raj