Forum Discussion

elguestca1's avatar
elguestca1
Advocate I
3 years ago
Solved

Dynamic measures in chart

Hello, is there a way to lets say make a chart by date with several measures, but only one at a time. Like I chose to see sum by date, I see sum by date, I choose to see count by date, I see count...
Data Protection
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Dhairya's avatar
    Dhairya
    3 years ago

    Hey elguestca1 
    If you are not able to use the field parameter (which is the best possible way) you have a workaround of using Bookmarks.

    you have to create seperate bookmarks for all individual calculations you want to display at a time and you have to create same number of button as number bookmarks and set respective action.

    for example

    bookmark 1 (sum by date)
    visual - sum by date (show) & count by date(hide)

    bookmark 2 (count by date)
    visual - count by date(show) & sum by date (hide)

    button 1 (for sum by date)
    action:  navigate to bookmark 1 (sum by date)

    button 2 (for count by date)
    action:  navigate to bookmark 2 (count by date)


    If this helps you then please mark my solution as accepted so that others can find it quickly when they face similar issue. Thank You!

Dhairya's avatar
Dhairya
Solution Supplier
3 years ago

Hey elguestca1 
If you are not able to use the field parameter (which is the best possible way) you have a workaround of using Bookmarks.

you have to create seperate bookmarks for all individual calculations you want to display at a time and you have to create same number of button as number bookmarks and set respective action.

for example

bookmark 1 (sum by date)
visual - sum by date (show) & count by date(hide)

bookmark 2 (count by date)
visual - count by date(show) & sum by date (hide)

button 1 (for sum by date)
action:  navigate to bookmark 1 (sum by date)

button 2 (for count by date)
action:  navigate to bookmark 2 (count by date)


If this helps you then please mark my solution as accepted so that others can find it quickly when they face similar issue. Thank You!

  • elguestca1's avatar
    elguestca1
    Advocate I
    3 years ago

    Hello, Dhairya,

    Great workaround. Thank you very much!