Forum Discussion

paybacksilver's avatar
paybacksilver
Frequent Visitor
4 years ago
Solved

Variable Tables in Measures

Hello, another question for today:

 

(CY in the last row is a typo that has since been corrected.)

I have made a measure alongside a measure table that allows me to filter my sheet by a selected measure, of which I have seven. 

 

 

However, in the interest of keeping this entire report to one page, I also want the ability to select a specific date range to compare against. To make the measures easy, I created six tables, three of which are compared against the other three from the year, week, or day prior:

 

My goal here is to have another metric switcher, for Day, Week, and Year. I thought the easiest way to do this was to have parameters within the original measure to change the "LY" to "LD" or "LW" to access the respective metrics from each date range, with the ability to select the date range as I would select my metrics in the filter I have already built. 

 

 

If there is a way to do this, or an easier way to get to my end result, any help is appreciated!

 

 

1 Reply