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
Please suggest any body on above requirement and please find the attachment of visualization.
Used a Pivot table
Any aggregate should work, this assumes you have data points for each day in the 30 day window
Thanks David, its working
Be sure to mark answer correct, so others can easily see the answer.
Here I could see only helpful option that is why I selected that
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.
Retrieving data ...