Custom Object

[Dolly123]

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 ?

[Dolly123]

check this see upside 3 button createed where to code set analysis ? that i am not getting

when u click last 3 month chart should change it was not changing 

[ogster1974]

I'm not sure how much more help I can give you. 

Its all there in the previous comments.  I've explained previously how to test your solution and given you the code to add to the master item measure using the selection of your buttons to generate the set analysis parameters dynamically and the static set analysis values.

 what is the measure expression you currently have on your bar chart.

[Dolly123]

Thank you 

[Dolly123]

In chart i used the top 10 avg sales in bar chart & in pie chart i have avg sales 

[ogster1974]

Not the description of your measure.  the actual measure expression you are using.

[Dolly123]

That is question where i have to used the measure and expressions 

[Dolly123]

I am not able to understand all steps properly where to write which code 

[ogster1974]

in your bar chart you have a measure average sales. replace the set analysis you have with the part highlighted in yellow in your expression.  obviously use your date.

[Dolly123]

check this 

[ogster1974]

1. duplicate your last6months measure and rename it lastXmonths

2. in the new measure remove your set analysis and replace with {<[Date]={'>$(vLastXMonths)'}>}

3. replace your last6months measure with lastXmonths measure in your bar and pie charts