2 Replies Latest reply on Oct 24, 2013 1:08 PM by Shawn Wallwork

    Removing gaps in a dual axis graph (bar and line), when the line spans multiple panes

    Reginald Green

      Hi Everyone,

       

      Does anyone know of a way how to remove gaps that appear in dual axis chart where the graph spans two or more panes. An example is shown below. The bars show monthly averages, and the orange lins shows a 2 month Moving Average calculated using the below formula:

       

      WINDOW_AVG(SUM([Column_1]) / COUNTD([Column_2]), -2, 0)

       

      Dual Axis Example.png

       

      Thanks in advance.

       

      R