Action Button

[AhmedElads]

Hi There,

I have a KPI the count the changes happed to all the data like (Update and Insert) for all last years and I need to add four buttons to change the KPI value:

First one calculate the Count of changes made comparing live data with the day before and the same for weak , month and year.

I need to get the change happened today - yesterday on the data when I click the first button How can I do this ?

[MartW]

you can add variables to buttons.

so what you can do is add 1 variable and set this as the messure in the KPI.

then drag 4 buttons on the sheet and with those button add the variable and add the set analysis to the value.

then when pressing the button the variable change and will be set to that variable.