Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want 3 buttons from custom object like last 3 month ,last 6 month , last 12 months
I was created the variable 1
how to implement
bar chart and piechart also change when we will click the 3 month it will chges accordingly , 6 month chart should chg
any one know ?
Have you created the 2nd variable that uses this parameter to go back the required number of months. Obviously the date name may be different.
why 2nd variable what i have to write 2nd variable
Have you done the followinng steps I asked you to?
2. create vLastXMonths variable to perform your measure calculation. Set definition to =AddMonths(Max([Order Date]),-$(vMonths))
3. Created a master measure sum({<[Order Date]={'>$(vLastXMonths)'}>} Sales)
Note the date used and measure value are mine and should be replaced with your own.
yes done
how to add last 3 month , last 6 month , last 12 month set analysis
you should be able to use this measure in your charts going forward now.
3 master measurres indivudials
like last 3 month master measure
like last 6 month master measure
like last 12 month master measure
Its already in there the variables will alter your set analysis accordingly when you click the button and the variable vMonths is set to either 3,6,12 respectively.
but i want set analysis
last 3,6,12 months where to add
according to click 6 month so bar chart and line chart should change the accorindg button = rolling month
