Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to create a stacked bar for prices of a group of product.
Dimension: product name
Expression: avg(price)
Now I get a graph with product name along the X axis, with bar = avg(price).
Like:
Price (product1), Price(product2), Price (product3)
However, I want to put price as an dimension, and treat each product name as a series of the stacked bar.
Like:
Price(product 1)
Price (product2)
Price (product3)
...
Thanks in advance!
Danni
This isn't tested, but a bar chart will only stack once you have 2 dimensions and one expression so add a calculated dimension like ='dim' which is a fixed string with the second dimension product and the same expression. Then go to the presentation tab and hopefully the stacked option will be enabled.