Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to build a line chart with Year dimension and around 10 expressions built on set analysis that has value for a year for instance fist expression has value for 2007 , 2nd has value for 2008.... 10th has value for 2016.
So now i see all the expressions being represented as single dot on each year.
Is there any way i get to plot a line between these points to show a flow
It would be better, if you provide few lines of sample data and then explain.
If you have year as dimension, why do you need 10 different expressions? From your description, it might seem you are doing something like this
Dimension
Year
Expression
Sum({<Year = {2007}>}Measure)
Sum({<Year = {2008}>}Measure)
Sum({<Year = {2009}>}Measure)
Sum({<Year = {2010}>}Measure)
... and so on
May be all you need is to use one expression like this
Sum(Measure)
and if you always want to see all years, you can do this
Sum({<Year>}Measure)
or this for latest 10 years
Sum({<Year = {"$(='>=' & (Year(Today()) - 9) & '<=' & Year(Today()))"}>}Measure)
Hi All,
Thanks for the replies I solved the problem using combination of pick and match.
@ Sunny: Thanks for trying to help me. But the measure is not the way you assumed it . I am supposed to create each on of them maybe my description is not detailed. Thanks anyways
Glad that it got resolved... please close the thread by marking correct and helpful responses.
Best,
Sunny