Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My data file is an on-going data file that is updated every seven days with the most recent week of data.
I want to display a basic chart for which the dimension would be the most recent ## of days. What would the most straight-forward way of doing this be?
You can use Set Analysis
For your measure in your chart do something like
Sum({<[DateField] = {">=$(Today()-7)"}>}Value)
You can use Set Analysis
For your measure in your chart do something like
Sum({<[DateField] = {">=$(Today()-7)"}>}Value)