Bar/Line View: Dynamic Split Dimension?

March 18, 2015 6:54AM

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...

paola · March 18, 2015 8:19AM

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.

You can find a working demo in this post:
http://forums.visokio.com/discussion/1002/variables-switching-measures-for-multiple-charts-on-a-single-tab

March 18, 2015 10:26AM

Thanks paola, that works perfectly!

Welcome!

Categories

Ideas Parade

Tagged