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:

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: