Table Column - Day from Calendar. For each of past 30 days from the Reporting day, a column will be created in the visualization. Date format MM/DD

[#1]

Table Column - Day from Calendar.  For each of past 30 days from the Reporting day, a column will be created in the visualization.  Date format MM/DD

[#2]

Please suggest any body on above requirement and please find the attachment of visualization.

[dwforest]

Used a Pivot table

Column:

=Date([YourDateField],'MM/DD')

Measure:

Count({$<Date={">=$(=Date(Today()-30))<=$(=Today())"}>}1)

Row:

[Customer ID]

Any aggregate should work, this assumes you have data points for each day in the 30 day window

[#4]

Thanks David, its working

[dwforest]

Be sure to mark answer correct, so others can easily see the answer.

[#6]

Hi David,

Here I could see only helpful option that is why I selected that

Thanks,

[#7]

Hi David,

I have taken column as date and trying to restrict 30 days accumulation value in pivot. But some null values are coming in the chart. can you give any suggestion on the same chart.

Thanks,