5 Replies Latest reply on Jan 29, 2019 3:54 AM by Zhouyi Zhang

    Change chart axis type in relation to Relative Date filter

    Tim Kennedy

      Hi,

       

      Apologies if this has already been covered. If so it would be great if you could point me in the right direction.

       

      I need to change the Date Axis on a charge relative to the Relative Date filter i.e. if I choose 'last 6 weeks' on the filter I want my date columns to change to 'Weeks'. If I choose 'last 6 quarters on the filter I want my date columns to change to 'quarters' etc.

       

      I have attached an example of a chart and a filter. currently I have the x axis set to months but if I charge the filter to 'last 6 weeks' the x axis stays at months. I want the columns to 'weeks' as per the filter.

       

      Thanks,

      Tim