Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to make a bar chart out of 2 fields, Age and Categori
Age is a field consising af ages from 1 to70 and Categori consists of A;B;C;D and E.
I want to make Age catogories as well, som the Bar chart shows how many Ages of ex. 15,16 and 17 there are ind Categori A and B and C and so on.
I have tried using IF i a calculated dimension and also and expression - but cant make it work.
Hi,
Plz clarify your query:
"....som the Bar chart shows how many Ages of ex. 15,16 and 17 there are ind Categori A and B and C and so on...."
Not understood.
there was a small typing error, sorry.
What I want to show in the bar chart is howmany with the age 15,16 and 17 are in categori a and how many in B and so on
Mayby an expression something like this
count(if(age = 15,16,17 age)) but this doesnt work
I think I got it myself using this
count(if(age> 14 and age < 18, age))
Hi,
Plz refer to the attachment.
Create a pivot chart having dimensions as Age, Category and
expression as Count(Category).
You will get the answer.
Happy Thoughts
Hi,
Attachment is here.