How to get multiple results from SWITCH() function?
I am trying to output multiple results depending on the selected field.
These multiple results are an average, an upper bound and lower bound standard deviation:
This works well as I have put every field into the lines, but I am trying to toggle to share of volume and get the wrong values
These bounds and averages are calculations for the previous metric. So I am trying to make a switch statement for the lines in this visual to select the proper bounds and average depending on the selected metric with the following formula: