Production Dashboard

%3CLINGO-SUB%20id%3D%22lingo-sub-2697926%22%20slang%3D%22en-US%22%3EProduction%20Dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2697926%22%20slang%3D%22en-US%22%3E%3CP%3EHI%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20can%20you%20help%20me%20on%20this%20production%20dash%20board.%20Here%20I%20explain%20you%20what%20I%20am%20trying%20to%20achieve%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20When%20a%20job%20finished%2C%20a%20file%20will%20be%20created%20in%20the%20folder%3C%2FP%3E%3CP%3E2.%20There%20are%203%20different%20shifts%20will%20do%20the%20production.%20Shift%20timings%20are%206am%20to%202%20pm%2C%202pm%20to%2010pm%20and%20After%20hours%2010pm%20to%206%20am.%3C%2FP%3E%3CP%3E3.%20So%20In%20the%20First%20chart%20will%20show%20number%20of%20files%20generated%20in%20AM%20hours%2C%20PM%20hours%20and%20AfterHours%20with%20distinguish%20colours.%3C%2FP%3E%3CP%3E4.%20Next%20Chart%20will%20show%20average%20production%20of%20the%20work%20shifts.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20enclosed%20some%20sample%20datas%20and%20What%20I%20have%20achieved.%20Is%20there%20anyway%20I%20can%20do%20better%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20Advance%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKrish%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2697926%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2717463%22%20slang%3D%22en-US%22%3ERe%3A%20Production%20Dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2717463%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F317114%22%20target%3D%22_blank%22%3E%40krish86%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20you%20are%20doing%20well.%20If%20you%20are%20still%20searching%20solution.%20You%20can%20find%20the%20advance%20visualizations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20check%20here%20for%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22No%20Code%20Data%20Visualization%20Add-In%22%20href%3D%22https%3A%2F%2Fchartexpo.com%2FutmAction%2FNCtNVEMreGwrUUorTVNPRlRDTVQr%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EMicrosoft%20Excel%20%26amp%3B%20Office%20365%3C%2FA%3E.%20Image%20attached%20get%20from%20this%20add-in.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20if%20you%20are%20comfortable%20with%20Google%20Sheets%2C%20you%20can%20find%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22No%20Code%20Data%20Visualization%20Add-On%22%20href%3D%22https%3A%2F%2Fchartexpo.com%2FutmAction%2FNCtNVEMrZ3MrUUorTVNPRlRDTVQr%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehere%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

1 Reply

Hi @krish86

 

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

 

You can check here for Microsoft Excel & Office 365. Image attached get from this add-in.

 

And if you are comfortable with Google Sheets, you can find here.

 

Thanks