Is there a way to set up a Bar/Line View such that it's split by a field that is selected through a device?
For example: I have a certain metric X and dimension fields A, B and C. I want to display the metric in a single Bar/Line chart and give the user the possibility to select which field they want it to be split by...
But of course... You could give your client a choice whether to measure something in £,$, units, litres etc., by using a variable and formula field with IF statement - so if you define a user-selected Variable called {Analyse by}, the Split-by formula would be something like : IF( {Analyse by}="Mileage",[Miles], {Analyse by}="Price",[Price])
You will split the Bar/Line view by the formula field, so interaction with the Variable {Analyse by} on the sidebar will immediately update the split/measures on the graph.