Refresh on Trigger when Trigger cell:(value changes = TRUE and SHow trend = 1) value becomes TRUE
I am using Label selection and Tree map to represent high level data in SAP Dashboards, and there are detail trending charts but don't want to display and run until show trending is checked and a block is selected from Tree map
A cell value is derived from Label and Tree map block selections
Show Trending value is from Check box selection
Cell value changed and Check box(show trending) is selected, then query needs to fired.
Refresh on Trigger when Trigger cell:(value changes = TRUE and Show trend = 1) value becomes TRUE
How can i achieve this functionality in SAP Dashboards 4.1, can you please direct me if there are other alternatives?
Thank you very much!
Have a push button and map the destionation of your chart ( value that changes) as the source and some other cell as the destination. Now check if the input value changes or not.
Chart destination :A1
Push button source : A1, Destination:B1
Check if i/p value changes or not : B6==IF(A1=B1,0,1). This will return 0 if value didn't change and 1 if it changes.
Map the destination of check box into some other cell
For Eg :
C4. This will have 1 if the check box is checked else will hold 0.
Now we have logic to find out if the value is changing and check box is selected or not in two diferent cells. now write the following logic.
This will have 1 only if both conditions are satisfied.
Now map the trigger cell to A4. and give When value becomes 1.
Please try and reply. This should work.