Forum Discussion

JimiH's avatar
JimiH
Frequent Visitor
9 years ago
Solved

Shift status active PIE Chart

Hello   Not too sure if this is possible but thought I would throw it out there   I have a table as per the below which documents when a production line is up or down and for how long over an 8 h...
Need Help
  • spuder's avatar
    spuder
    9 years ago

    Hi JimiH

     

    oh this was just a small mistake by myself. I chose Duration Minutes for the new column. There must be something like Duration Minutes Total. (otherwise it just returns the minutes without considering the hours)

     

     

    Make this small change and it should look like this. :smileyhappy:

JimiH's avatar
JimiH
Frequent Visitor
9 years ago

Hello ,thank you for your reply.

 

I can see the time difference between all the rows except line 11 which has '31' minutes.

 

Also could you screenshot me the double index you have created?

 

Again thanks for your help

 

Geoff

spuder's avatar
spuder
Resolver IV
9 years ago

I guess your merge was the wrong way round.

 

Make sure that you've ordered your original time column descending before start to generate the inidices.

 

And make sure that you've generated an extra row for the end of the last time.

 

In the screenshot you can see the merge of the table with itself. It's in German but this shouldn't be a problem.

 

  • JimiH's avatar
    JimiH
    Frequent Visitor
    9 years ago

    Hi thanks

     

    I was refering to your column 'Duration' here ,the 31 mins in row 11 doesn't seem to make sense but the other rows do?

     

     

    thanks for you help

     

    Geoff

    • spuder's avatar
      spuder
      Resolver IV
      9 years ago

      Hi JimiH

       

      oh this was just a small mistake by myself. I chose Duration Minutes for the new column. There must be something like Duration Minutes Total. (otherwise it just returns the minutes without considering the hours)

       

       

      Make this small change and it should look like this. :smileyhappy: