topic Re: Need Code for Two column in Management & Governance

Need Code for Two column

MrJanjua — Mon, 14 Nov 2022 14:23:33 GMT

Hi, I have two columns with Items and Category

Items Category

Milk Bakery

Bread Bakery

Water Shop

Biscuets Shop

Nugets Bakery

I wants to show two pia-cart with Bakery Items separate and Shop Items separate. i need a expression for this

Dalton_Ruer — Thu, 17 Nov 2022 01:55:44 GMT

Here you go. the expression I used is in the label for the pie charts

I used this sample code:

Load * Inline [
Items , Category, Value
Milk, Bakery, 40
Bread, Bakery, 30
Water, Shop, 45
Biscuets, Shop, 55
Nugets, Bakery, 20
];

And I created a Master Dimension for the Category and defined the colors then set the pie charts to color by the Category dimension

MayilVahanan — Thu, 17 Nov 2022 02:32:08 GMT

Try with set analysis

Exp1: Count({<Category = {'Bakery'}>} Distinct Items)

Exp2: Count({<Category = {'Shop'}>} Distinct Items)

MrJanjua — Thu, 17 Nov 2022 08:46:25 GMT

Dear!

I need this in Demission (Expression) not in Measure.

MrJanjua — Thu, 17 Nov 2022 08:27:24 GMT

I have a lot of items and have 4 categories. So wants to make 4 Charts separately, One thing more items adds frequently they are not fixed