10 Replies Latest reply: Nov 29, 2015 2:49 PM by Ritesh Sharma RSS

    Dynamically change the axes in a chart

    Ritesh Sharma

      I was using this sales vs date chart with Daily Sales on the Y-axis and Dates on X-axis.

      At the top, I have filters to choose the start and end dates. But if I set the filters in a way that the date difference between the start and end date in 30+ days, then it becomes cumbersome to read it properly. Is it possible to calculate the difference of selected date & store it in variable and  if variable < 15 days then, show graph_1, if variable >15 & < 30, then show graph_2, else graph_3 where

       

       

      graph1 - will always shows date wise sales

       

       

      graph2- weekwise

       

       

      graph3- monthwise
      Please help.