How can I represent Negative number on Pie Chart

Join the general discussion on using Quantrix Modeler.

Moderator: Moderators

How can I represent Negative number on Pie Chart

Postby ShriShank » Wed Aug 23, 2017 4:26 pm

Hello,
In the matrix3 the left over to commit for tech is -300.
How do i represent this in Pie Chart(Canvas 1). This portion is not displayed

Thanks
You do not have the required permissions to view the files attached to this post.
ShriShank
Quantrix Forum Member
 
Posts: 27
Joined: Mon Feb 13, 2017 9:25 am

Re: How can I represent Negative number on Pie Chart

Postby mgandy » Tue Sep 05, 2017 10:47 am

Instead of a pie chart, a bar chart would be more meaningful.

In Tableau, a bar-within-a-bar chart is easy to pull off.

I'm not very good with the chart builder in Quantrix, but the attached gives you the concept.

James and Rich probably know how to shrink the commitment data point. That is, keep the original width of commitment, and then make the actual total be about half the size of the commitment bar width.

I'd probably nix the difference between actual and budget. But I kept it as I used what you already had.

To clarify, my attempt at what I was trying to accomplish is a poor one--just brainstorming an idea.

Mark
You do not have the required permissions to view the files attached to this post.
Mark Gandy
mgandy
Quantrix Forum Member
 
Posts: 12
Joined: Mon Aug 11, 2014 8:50 pm

The Data for Display on a Pie Chart

Postby S a u » Wed Sep 06, 2017 2:19 am

FYI. Null, empty, negative and zero values have no effect when calculating parts of the whole. This is reason, why these values are not shown on a pie chart.
Best regards,
SAU
S a u
Quantrix Forum Member
 
Posts: 43
Joined: Fri Jun 20, 2014 8:57 am


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 3 guests