Forum Discussion

NancySummit's avatar
NancySummit
Cloud Apps
01-31-2025
Solved

Edits to script for changing widget values by buttons

I followed the instructions in this post... https://community.sisense.com/t5/knowledge-base/changing-measures-in-the-entire-dashboard-using-blox-user/tac-p/26261#M3953 It works great but I've been t...
Blox
  • AssafHanina's avatar
    AssafHanina
    02-07-2025

    Hey NancySummit ,

    Thanks for sharing the feedback. 
    Please find a dash file with possible solution and related action.

    1. Create the action - the action is for switching the first column in Pie/Line/Column/Area/Bar chart
    2. Update the dashboard Script with related OID and Color - the dashboard script is for keeping the selected color after refresh the dashboard 
    3. Update the related Widget OID/OID's in the Blox 

    Example

    Hope this will resolve the issue 

    Best regards

     

  • AssafHanina's avatar
    AssafHanina
    02-10-2025

    Hey NancySummit ,

    I'm happy to hear it's resolve the issue!

    You can specify 2 measures in the same chart.
    The blox action will replace the first measure as it hard-coded for (Item[0])
    In case needed, you may consider duplicating the action with different name and set hard coded to item[1] for replacing the secondary measure if needed. 

    Here is an example with secondary measure: Selecting the Revenue

    Selecting the Quantity

    Best Regards

NancySummit's avatar
NancySummit
Cloud Apps
02-10-2025

Wow that works great!!  And much simpler.  Thank you so much!  Now I need know if I can show TWO measures at one time on a chart -- like Revenue AND Profit in your example.  I'm guessing that needs to be a separate post?  Thanks again!!

AssafHanina's avatar
AssafHanina
Sisense Employee
02-10-2025

Hey NancySummit ,

I'm happy to hear it's resolve the issue!

You can specify 2 measures in the same chart.
The blox action will replace the first measure as it hard-coded for (Item[0])
In case needed, you may consider duplicating the action with different name and set hard coded to item[1] for replacing the secondary measure if needed. 

Here is an example with secondary measure: Selecting the Revenue

Selecting the Quantity

Best Regards