Staff Roster Chart

[vardhancse]

Hi,

Have a requirement to build a chart based on attached excel sheet.

Data: Raw Data (sheet name)

Chart: Chart (sheet name)

can please help me out to achieve the same.

Please not e we have some staff coming like 8:30 to 17:30 as well so we need to display the in chart as well

[duncanblaine]

See attached.
I haven't added days in, but should be easy enough.

Create a bar chart with Stacked style,

then have 3 Expressions:

• 0-Start Hour
• EndHour-StartHour
• 24-EndHour

Details in the QVW

[vardhancse]

Hi,

thank you so much

All good and as expected , but one issue is that if staff roster details are from evening to early morning then graph is little bit odd.

PFA updated QVW, once can please have a look

[duncanblaine · Accepted solution]

Hi Varaha
To add in night shifts we just need to adjust the Expressions a bit and add an extra one.
See attached app

gantt‌ gantt chart‌ roster‌

[vardhancse]

Hi

to same chart, now need timezone conversion like SGT, AUS, UK & USA.

Would you be able to help me out