Display the data weekly

Follow

Master Yoda

December 09, 2019 12:25

I have a pivot table with 20 columns and I want to have a separate dashboard where I can display all the data in the last 10 days every monday. The data i have in my columns is within the last 10 days and the reporting will be every monday. 

 

for example

Sales in the last 10 days (so this is from 11/30 - 12/9)

Name Sales    

Anne    12

and the reporting date is 12/9 because it is monday.

Is it possible to have a dashboard like this ? 

0

• 

  Nathan Giusti December 19, 2019 17:35

  Yes.

   

  To get data to only display for mondays, we'll need to add a widget filter for Mondays. As this isn't explicitly built in, you'll need to add a column to your date table for the day of the week that way you can choose just to display mondays. 

   

  From there in the value column you would just do a SUM([your val]) with a measured value that filters for the last 10 days. 

  0

  Comment actions Permalink

Please sign in to leave a comment.