2 Replies Latest reply: May 16, 2017 2:57 PM by Andreas Karlsson RSS

    Visualization problem, chart with dynamic reference line

    Andreas Karlsson

      Hi folks,

      I've run into trouble while visualizing the planned hours vs. the capacity hours of different resources in a manufacturing site.

      (This wasn't possible in Qlikview either but could be solved with two line-charts, one with the capacity line in the background and a transparent area-chart in the foreground with the planned hours per resource)

      As dimension I have dates and resources, 2 dimensions makes only 1 measure possible which is the planned hours.  How to add the capacity as a reference line.

      The reference functionality does not care about the dimensions so it cannot fluctuate with the dates.

      I've made a very small app showing the problem.

      ANYONE having any idea how one can display a line in an areachart or have another idea to visualize this?