Forum Discussion
Helper IISorting donut chart by category/details
Hi, SaaM
If you want the categories not to be grouped together, change the aggregation of the values. The default aggregation is summation, so when the value is 0 it is not visible in the total value. You can change the aggregation method to count, or change 0 to a non-zero value such as 0.1 or -1.
If you want to sort by the way you want to sort, then create a new sorted table, establish a relationship between the sorted table and the main table, then use the RELATED function to create a sorted series in the main table, and finally select the category to sort by the sorted series.
Please refer to the attachment below for details
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, SaaM
If you want the categories not to be grouped together, change the aggregation of the values. The default aggregation is summation, so when the value is 0 it is not visible in the total value. You can change the aggregation method to count, or change 0 to a non-zero value such as 0.1 or -1.
If you want to sort by the way you want to sort, then create a new sorted table, establish a relationship between the sorted table and the main table, then use the RELATED function to create a sorted series in the main table, and finally select the category to sort by the sorted series.
Please refer to the attachment below for details
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.