Convert Multiple Measures into categorized Dimension

Sri251 — Tue, 01 Aug 2023 16:08:55 GMT

Hi Everyone,

I need your inputs:

I am in a situation to convert 4 measures into dimension like a category

For example: My measures are Male Patients Count, Female Patients Count, Asian Male Patients Count, Asian Female Patients count.

Basically I need to create a pie chart based on the above mentioned measures and i need to place all the above mentioned measures into a single dimension like a category and i need to use this category as a dimension in the pie chart, so when i create a pie chart it will give their individual distribution.

Appreciate if someone can advice me the best approach!

TIA,
Sri

Re: Convert Multiple Measures into categorized Dimension

Sri251 — Tue, 01 Aug 2023 18:40:14 GMT

I got the solution: I have created a calculated dimension with the help of value list for the above mentioned measures and also used the pick match function in the measure section to calculate the % share in the pie chart.

Hope it will be helpful for someone!

topic Re: Convert Multiple Measures into categorized Dimension in App Development

Convert Multiple Measures into categorized Dimension

Re: Convert Multiple Measures into categorized Dimension