2 Replies Latest reply on Oct 15, 2019 4:13 AM by Manuel Silva

    Shadow area between percentiles in line chart

    Manuel Silva

      Hi,

      I would like to be able to do a chart as follows:

      I am displaying a yield quarterly and for the last quarter I have done a forecast, so I have the corresponding p10 and p90 values:

      I have created line charts for p10 and p90 as calculated values as follows:

      if [quarter] = date('04/01/2019') then [p10] elseif [quarter] = date('01/01/2019') then [yield] else float('') end

      if [quarter] = date('04/01/2019') then [p90] elseif [quarter] = date('01/01/2019') then [yield] else float('') end

      I would like to display a shadow area between P10 and P90 charts, and display at the same time yield as a line chart

      I have tried playing with dual axis, measure values, area charts... But this is all I can get:

      Any help would be much appreciated