1 Reply Latest reply on Apr 30, 2016 5:40 PM by Bill Lyons

    Displaying Service Performance (SLA) based on a list of incidents

    Thomas Drapier

      Hi,

       

      I'm trying to chart the SLA % for a number of services. My source data is a list of incidents recorded against these services.

      Each incident occurs on a certain date and has a duration. Aggregating the durations gives me a total incident duration in a given period for a given service.

      I created a calculated field which translates the sum of incidents duration into a percentage and defaults to "1" when the value is null:

       

      IF ISNULL(SUM([Effective Duration])) THEN 1 ELSE

      1-(SUM([Effective Duration])/2678400) END

       

      This works well when I display the data in a text table.

      However when I display the data into a bar chart, the services which had no incidents have no bars on the chart.

       

      How do I force tableau to show a 100% bar for services which had no incidents recorded in a given period?

       

      Thanks

      Thomas