1 Reply Latest reply on Jul 24, 2013 6:51 AM by Willem Botha

    Time series charts & period filters

    Shalin Bhatt

      I have a time series chart with a period filter (period: Jul'12- Mar'13).


      When I reduce the period of analysis e.g (Jul'12-Jan'13), the axis adjusts to show only these months.

      What I desire is to still show the entire period (Jul'12-Mar'13) with the months Feb'13-Mar'13 showing blanks/zeroes.


      I've attached the file, please revert if you have a solution.





      PS: As an additional follow-up question, could this then be applicable to filters in general (e.g select two out of three elements, and show a zero for the unselected element)

        • 1. Re: Time series charts & period filters
          Willem Botha

          Hi Shalin


          Right click on your x-axis and select Edit Axis, then tick 'Fixed' under Range. It should default to your current selection of dates, but you can set it to whatever values you want. Now if you filter your dates it keeps it on your fixed axis, showing all the months not selected as zero, but still having the month's position visible.


          Hope that helps.