topic measure expression and dimension in pie chart in App Development

measure expression and dimension in pie chart

MarcoAmbrosio — Sat, 16 Nov 2024 05:18:21 GMT

I want a percentage, that work also as a filter for this thing. Here this is an example of the table.

In my pie chart a want a percentage of how many CodOffice have at least one IdPractice and how many CodOffice don't have an IdPractice

Diter — Fri, 26 Jul 2019 19:45:25 GMT

Hi Marco,

Maybe this can help you.

1. you can add a category calculated with a formula: if([IdPractice]>0, 'at least one id Practice', 'dont have an Id Practice')

2. then you can count the CodOffice: count(distinct CodOffice)

3. finally you can built the pie chart and use it as a filter

Please see attached images

Regards,