Forum Discussion

krish86's avatar
krish86
Copper Contributor
Aug 30, 2021

Production Dashboard

HI All,

 

Please can you help me on this production dash board. Here I explain you what I am trying to achieve

 

1. When a job finished, a file will be created in the folder

2. There are 3 different shifts will do the production. Shift timings are 6am to 2 pm, 2pm to 10pm and After hours 10pm to 6 am.

3. So In the First chart will show number of files generated in AM hours, PM hours and AfterHours with distinguish colours.

4. Next Chart will show average production of the work shifts.

 

I have enclosed some sample datas and What I have achieved. Is there anyway I can do better? 

 

Thanks in Advance,

 

Krish

excel

1 Reply

  • Qaiser_j's avatar
    Qaiser_j
    Brass Contributor
    Sep 03, 2021

    Hi krish86

     

    Hope you are doing well. If you are still searching solution. You can find the advance visualizations.

     

    You can check here for https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr. Image attached get from this add-in.

     

    And if you are comfortable with Google Sheets, you can find https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr.

     

    Thanks