Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone!
I need to make a stacked bar chart but I don't have the dimension.
On the X-axis I need to put for example: London, England, Europe (so 3 bar), and on the Y-axis: 'Provided per user', 'Provided per user (England)', 'Provided per user ( Europe)' and 3 more measures: 'Provided per capita', 'Provided per capita (England)', Provided per capita (Europe)'.
Thanks for your reply!
Hi @AriIt !
I think the best way is using the "ValueList" function. Se the example below.
//Dimension:
ValueList('London','England','Europe')
//Measures:
if(ValueList('London','England','Europe') = 'London', Sum(ValueLondon),
if(ValueList('London','England','Europe') = 'England', Sum(ValueEngland), Sum(ValueEurope)))
I hope to help you!
Hi @AriIt !
I think the best way is using the "ValueList" function. Se the example below.
//Dimension:
ValueList('London','England','Europe')
//Measures:
if(ValueList('London','England','Europe') = 'London', Sum(ValueLondon),
if(ValueList('London','England','Europe') = 'England', Sum(ValueEngland), Sum(ValueEurope)))
I hope to help you!