Rolling Count Distinct Calculation

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.