Bar chart without using filtering fields?

[#1]

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.

[#2]

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.

[#3]

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

[#4]

Mayby an expression something like this

count(if(age = 15,16,17 age)) but this doesnt work

[#5]

I think I got it myself using this

count(if(age> 14 and age < 18, age))

[#6]

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

[#7]

Hi,

Attachment is here.