Forum Discussion
Simple pie chart does not work correctly (...)
Hi chefe,
I think that you cannot visualize positive and negative values together in a pie chart. I tried with the datas you provided and I obtained the same result. If you want to use the pie chart the only way is to use the ABS() function over "Liability", or you may use the bar chart that fits better to this issue.
#I'M Not An Expert#
Hello chefe
Just likeAnonymous wrote, you won't have any data with negative value. Keep in mind that each visual often come with business needs, not only to give a nice "look and feel".
According to what I know Pie chart is not really use to compare subject, is much used to see proportions. Try to use others visuals, such as bar graph to display positive and negative values side by side.
More generaly use the best visual according to your business need.
regards,
Sébastien
Hello chefe
That's quite weird !
Just like austinsense wrote, could you share us the column you want to sum (with their datatype)? It look like a non numeric column you try to sum (or the values from liability are all 0).
Sebastien
Hello,
I do not use a measure, but rather just use the column as it is. The data type of this column set to DECIMAL.
Below csv was exported via the "..." button in the upper right corner of the above on the ride side of my screenshot.
The chart shows only asset, but when I export it's data, both asset and liability is shown.
Best regards, chefe
Asset/liability,Sum of test
asset,3048.7595457335524
liability,-2140.3965090420174Hi chefe,
I think that you cannot visualize positive and negative values together in a pie chart. I tried with the datas you provided and I obtained the same result. If you want to use the pie chart the only way is to use the ABS() function over "Liability", or you may use the bar chart that fits better to this issue.
#I'M Not An Expert#
Hello chefe
Just likeAnonymous wrote, you won't have any data with negative value. Keep in mind that each visual often come with business needs, not only to give a nice "look and feel".
According to what I know Pie chart is not really use to compare subject, is much used to see proportions. Try to use others visuals, such as bar graph to display positive and negative values side by side.
More generaly use the best visual according to your business need.
regards,
Sébastien
