6 Replies Latest reply on Jun 21, 2018 6:25 AM by Simon Runc

    For line graphs why start value have -1

    Shahin Khosrowshahian

      Hi,

       

      When i have columns that have values of zero in the line graph, the line graph has a fixed start of -1 instead of 0 for columns that have no existing records within my data model.

      Here is my view:

      Sepember, October, and March have no existing records and thus their value is zero according to my function below:

      IFNULL(Sum({include [Incident Sys ID] : min(if [Severity Level] = "P1" then [# of Incidents] end)}),0)

       

      Is there any workaround or if tableau is fixing this to combat this anomaly?

       

      Any help would be appreciated.

       

      Thanks,

      Shahin