Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the below requirement:
Based on the selection of Month and Year, in the Combo graph, Bar chart should show the data from last 12 months i.e., if selection is Apr 2018, the it should show the data from May 2017 to Apr 2018.
And Line should show the data from May 2016 to Apr 2017. Please suggest me in completing the requirement.
Thank you.
Regards
Santhosh Kasam
Hi Santhosh,
As per my understanding, you can't have bar chart and line chart on different points in a same combo chart.
For example, you can have time at your x axis and can add two expressions or measures at y axis.
Regards,
Akshaya
Hi,
may be try using valueloop :
in dimension valueloop(1,12) for 12 months
and 2 expression with
sum( if(month>=max(Month) -12, 'field') )
and sum( month>=max(Month) -24 & month<max(Month -12), ......
regards
Hi Olivier,
I created variables using below expression:
vCurrMaxPeriod: Date(Monthend(Max(Period)))
vCurrMinPeriod: Date(Monthstart(addmonths(Max(Period),-11)))
Now I am using set analysis restrict the count but the I am not able to restrict the count. I think it is due to mismatch in the data type. Please help me in resolving the issue.
Thanks in advance!!
Regards
Santhosh Kasam