Hi Dear Community folks,
I have been scratching my head for past two weeks to implement a requirement. It looks simple, but when I try implementing it I am lost somewhere.
We have a data source which determines if we have missed Service Level Agreement for each calendar day. If we met SLA, we have a field called SLA Status and it says 'SLA Met'.
If we missed SLA, it would say 'SLA Missed'. If we missed any SLA, we need to find out the reason and attribute one from a defined list. We would have missed SLA because we held our jobs (code) not to run during some code migrations to production (Reason Code - Production Implementations) or we would have missed SLA if there was a system wide outage (Reason Code - System Outage) or we would have missed SLA because we held our jobs (code) not to run during some patching or version upgrade for any applications (Reason Code - Application Release) or we would have missed SLA because of some manual error which would cost us.
Based on this data source, create a Tableau dashobard that displays two bar graphs, SLA Met and SLA Missed. Filters should be "Month - Year" , "Reason Code".
By Default , bar graphs shall be populated such that all SLA met will be one bar and all SLA Missed shall be in another. The Reason Code filter shall be "All".
Except when the reason code is "Manual Error" all other reason codes effectively means we would have met SLA if that outage / application patching was not there. So, if a business director wants to look at the picture in case we did not have those planned releases/implementations/outages, he would deselect one reason code , lets say "Application Release" from Reason Code Filter. The number of SLA Misses that were due to "Application Release shall be deducted from the SLA Missed Bar. However that number should get added to SLA Met Bar Graph with a different color. This way they will have a picture of how many SLAs would have been met except for Manual errors.
I do not have a personal machine to install Tableau Public and cannot copy anything from client environment . I have created an excel spreadsheet that has mocked up data and how the bar graphs should look like.
Really appreciate any help !