4 Replies Latest reply on Jun 28, 2016 12:50 PM by Randy Kirschner

    Measures with time filters

    Randy Kirschner

      I'm trying to create a bar chart with side by side comparisons for sales across different time periods. But I'm having trouble figuring out how to create multiple metrics that filter on different time periods. Using the superstore data I added product to the rows and put 2 sales metrics in the columns. I want the first sales measure to be sales for the last complete week and the next measure to be sales for the last complete month. Does anyone know how to do that?

       

      I can probably create separate worksheets with filters and combine them on a dashboard but I'm trying to see if it can be done on one worksheet.