Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to represent a pie chart with no values

Hello everyone,

 

I have some supply chain data where i have the total number of shippments. among those we only have data for 2 categories, not shipped and delivered. The end user also wants a pie chart with percentages including a 3rd catgory called Not scheduled.

 

Our data only contains shippments that are delivered and not shipped since we have tracking numbers and info about it. 

 

Example if there are 400 orders in total, and our data sheet has 150 shipped, 200 not delivered only then the remaining 50 is not scheduled. How do I represent this as a pie chart?

 

Your help is appreciated. Thank you.

Need Help

3 Replies

  • nvprasad's avatar
    nvprasad
    Icon for Solution Sage rankSolution Sage
    5 years ago

    Hi,

     

    Since "Not Scheduled" label itself is not there in your data, You can create 3 measures (Not Shipped, Delivered & Not Scheduled) and drag them into the 
    Values section of "Pie Chart".

     

    Appreciate a Kudos! 🙂
    If this helps and resolves the issue, please mark it as a Solution! 🙂

    Regards,
    N V Durga Prasad

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , You have to create three measure and show them in pie visual without any legends

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Can you give your sample data and expected results? Does your category column have only two categories, not shipped and delivered? So how does your total number 400 appear in the data, because the not shipped and delivered data add up to only 150+200=350. 

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.