Forum Discussion

Craig_01's avatar
Craig_01
Helper I
2 years ago
Solved

Bar Chart To Show Cutting Progress

Hi All,

 

I am looking to create a bar chart visual to show progress with regards a cutting operation within a manufacturing sequence. So i have a SP List, which has a Due Date, Total Patterns & Total Patterns Cut.

 

Date would be X Axis, with Sum of Total Patterns Y Axis

 

Ideally i want this to be a stack, so if Sum of Total Paterns for 16/05/24 is for example 25 (this would be Amber)... But as the Total Patterns cut (Green) = 25, the bar would become all green.. See below, is there a way that this could be visualised as a single bar?

 

 

Any tips would be appreciated.

 

Regards

Craig

 

 

Need Help
Tips and Tricks

4 Replies

  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    Solution Sage
    2 years ago

    Hi Craig_01 

     

    If it is possible for you, you can unpivot the columns and then create the stack chart out of it.

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
    Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

    Regards

  • Craig_01's avatar
    Craig_01
    Helper I
    2 years ago

    qqqqqwwwweeerrr Hi There, when i do that, the total is combining both values, rather than showing that the there is a total of 25, but 23 of the 25 are cut.

     

     

    Thanks

    • qqqqqwwwweeerrr's avatar
      qqqqqwwwweeerrr
      Solution Sage
      2 years ago

      Can you share sample data, It is bit confusing. and expected output

       

      Regards

  • Craig_01's avatar
    Craig_01
    Helper I
    2 years ago

    qqqqqwwwweeerrr 

     

    Below the dataset.. (Pattern Balance is a calculation field)

     

    I want to try show something like below.. Where the total of the column is still (25)

     

    But the organge (2) relates to the pattern balance.. So in other words the 25 isnt fully cut.

     

    Thanks