Combo Chart - formula needed to filter out info

[#1]

hello forum,

I would need your help with below challenge.

i would need to create a combo chart to show simultaneous 2 categories using Bar chart type.

I know i need to pt some formula to restrict the count for the values for "catA" and respectivelly "catB" but i don't know how.

any help/direction is more than welcome

[Gysbert_Wassenaar · Accepted solution]

Using [Dunning Level] as dimension as you do now and add two expressions for the two categories:

• count({<MyCategory={'catA'}>} MyItem)
• count({<MyCategory={'catB'}>} MyItem)

Replace MyCategory and MyItem with the appropriate field names from your data model.

[#3]

worked like a charm.

thanks a million. can u please suggest some reference materials where I can learn how to build these formulas?

[Gysbert_Wassenaar]

You can find some information here: A Primer on Set Analysis