cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nikonnet Frequent Visitor
Frequent Visitor

How can I show "superset" and "subset" relationship within stacked chart?

 

 Hi all,

 

I would like to use stacked column with line chart to show Total forecasted revenue (as superset) and Total earned revenue as "subset" within total forecasted revenue. The line chart to show the Goal. 

chart.png

The goal and the earned value are showing correctly. However, for total revenue, I would require the "visual" as Sample 1 but the value as in Sample 2. Any way to do it?

 

Thank you.

 

 

 

 

 

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: How can I show "superset" and "subset" relationship within stacked chart?

Hi Nikonnet,

 

How do you describe superset or subset? Have you created any measure about 'Total earned revenue'?  Could you share some sample data and clarify more detials? 

 

Regards,

Jimmy Tao

Nikonnet Frequent Visitor
Frequent Visitor

Re: How can I show "superset" and "subset" relationship within stacked chart?

Hi,

 

Sample data: Goal = 1.87M, Total revenue (Apr 2018 to Mar 2019) = 1.71M, Total earned revenue till date = 1.45M.

 

Visually i want:

- Triangle to show the goal = Done with no issues

- Total earned revenue till date = Done with no issues

- Total revenue = It is either show full 1.71M instead of the height of 0.26M (1.71M - 1.45M) but data label of 1.71M.