Is there a way we can add a switch to dashboard that can change what is being summarized?
For eg: I summarize Gross Revenue and Net Revenue grouped by time, but I don't want to add two questions for that but instead simply have a switch that triggers the summary from Net or Gross.
Currently no ... But you should be able to achieve that with SQL and perform case statements ... So if filter is 1 than CASE statement will SUM Gross Revenue and if filter is 2 then CASE statement will SUM Net Revenue
1 Like