topic change chart values based button selection in App Development

change chart values based button selection

Maddineni_S — Thu, 07 Jul 2022 13:45:30 GMT

Hello Members,

i am trying to display sales using tree map: dimension as "Country" measure sum({<Month_Number= {">=94"},Fraud_Type=>}sales). but i have Fraud_type column which has 'internal, External' values by default tree map should show internal sales and if i select external button values should change.

can somebody help me.

Re: change chart values based button selection

edwin — Thu, 07 Jul 2022 14:05:50 GMT

there are couple of ways of approaching this. one way is:
cretae a variable like vFraudType. in your expression add FraudType={'$(vFraudType)'}. your buttons should set the variable to either Internal or External - whatever the values are.

your variable should have a default value

Re: change chart values based button selection

MartW — Thu, 07 Jul 2022 14:06:37 GMT

what you can do to get it working is create 1 variables within the edit mode.

say vUpdate with a default value like Internal. then in the set analysis you can call that variable and update the messure

sum({<Month_Number= {">=94"},Fraud_Type=$(vUpdate)>}sales)

then you need the buttons above to know that when you press one of then the vUpdate variable needs to get updated. for this, within the button you can go to actions and navigation and create a new action. set it up just like the screenshot below and you are done

if this helped and or was the answer you are looking for, give it a like and accept this as the answer.