Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I have a variable that creating conditions for rolling x Months
Looks like this:VRollMonth = [Survey Year]=,[Survey Month]=,[Survey Date]= ,[Survey Month Year]={">$(=monthend(AddMonths(Max([Survey Date]),-$(vNumRollinMonth))))<=$(=Max([Survey Date]))"}
When vNumRollinMonth it the number that user can change to choose how many months back they want to go.
Then I create bar chart with [Survey Month Year] as dimension one and Dealer Code as Dimension two.
My expression is like this sum({<$(vRollMonthCSE)>}(msrConvenienceIndexQuestionPoints1)). and this works fine when I choose any Months the chart displays all the data by Months based on vNumRollinMonth that user chooses..
But I need to create a chart with second dimension as Value list.
So my chart will be: First dimension: [Survey Month Year] , second Dimension: ValueList('All','Dealer Zone') and the measure is
if(ValueList('All','Dealer Zone')= 'All', sum({<$(vRollMonthCSE)>}(msrConvenienceIndexQuestionPoints1)),
if(ValueList('All','Dealer Zone')= 'Dealer Zone',sum({<$(vRollMonthCSE)>}(msrConvenienceIndexIndexScore)))).
But in that case when I choose a month the chart shows only the selected months and does not show all the other months form the selected back based on vNumRollinMonth .
Any Ideas why?
Please help
Awesome !!
Please close the thread by marking correct and helpful responses once you have confirmed.
Best,
Sunny
Will do
Hi Sunny,
Just wanted to thank you for your help.
It is not the first time you are helping me and it always very efficient.
Thank you a lot!!
No problem at all!! I am glad I am there to help most of the times
Thanks Sunny,
I have one more question related to this.
I have added this expression in a color by expression function
if(ValueListDealerZone='All',Red(),blue())
and it works as long as I do not select Month.
When I select Month it turns all to blue except for selected month.
Is there any way to fix that the formula does not reflect the month selection?
Apply the same logic here as well
If(Only({<$(vRollMonthCSE)>} TOTAL <ValueListDim> ValueListDim) = 'All', Red(), Blue())
You are rock!
Thank you!!!!!