Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want a percentage, that work also as a filter for this thing. Here this is an example of the table.
CodOffice | IdPractice |
101 | 54645 |
101 | 123546 |
102 | - |
103 | 4568 |
104 | 7987 |
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
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,