Changing Chart Expression

[#1]

Hello,

I was wondering if there was a way to change the expression of a chart based on creating a button.  So for example, if at first I wanted to show a line graph summing total revenue, and then I could somehow disable that expression, and enable the next expression summing total seats billed. 

Thanks for your help,

Alex

[#2]

Hi there,

Can you send us a sample data set?

So that we can give a try along with your requirement.

Thanks,

Bikash

[#3 · Accepted solution]

Hi Afronczek.

Maybe you can group the 2 Expressions:

Create the SUM(Revenue) as first expression,

create the SUM(Seats) as Second expression. Then selecting the second expression clik on the "Group" Button, you will be capable to change between your 2 expression in the same chart.

Hope this help.

Regards

[IAMDV]

Hi Alex,

I hope you are doing well.

Yes, this is possible in two ways.

1. As mentioned above by Emmanuel Prieto. You can group your expression & dimensions.

2. If you wanted to change the expression on button click. Then you need write VB Script using the API Guide. I have an example at work and I can share them with you, if you wanted take this approach.

Hope this helps!

Cheers - DV

[#5]

Hello DV,

Thanks for all your previous help, and thanks Emmanuel for this correct answer.

Alex