Sort pieces of pie chart
I want to be able to sort my pie chart pieces. For example I want to show the pieces from largest to smallest in order, such that I can more easily identify which the relevant pieces are by going from the biggest to the smaller ones and ignoring the bulk of "small rest" pieces.
Comments
-
@Steka I think a workaround would be to list the metrics in the order from largest to smalles either in a metrics sheet, or sorted by largest to smallest in a report.
-
Hi @AkberM thanks for the suggestion. That is a good idea.
My data are tasks (or part of scheduled tasks) that lie within a certain time frame, e.g. this quarter.
I suspect that getting these data in order is possible but more complicated than using the built in functions provided. I now use the advanced report of the resource management and then visualize a pie chart on a dashboard using a report that has the right kind of filters and shows me the sums of hours scheduled per category. Replicating the same manually involves a lot of re-calculating built in functionality of smartsheet, just because I cannot order the pieces of the pie chart. That seems a bit odd to me.