4 Replies Latest reply: Oct 6, 2015 8:18 AM by Jonathan Poole RSS

    How to get only latest 10 weeks as a dimension in a bar chart

    hemantha kumar bandari

      Hi all,

       

      I have a field coming from database which has only Friday dates in that example 10/02/2015,09/25/2015,09/18/2015 etc upto 2014. I need to create a bar chart where the dimension is the above week ending date field and expression is if(xy=%,avg(values),sum(values)). I need to get only latest 10 weeks to be displayed on the chart starting from today. the dimensional limits tab of chart is only getting the highest values based on the Values field. Do we have a option of setting range in the dimension of the chart.

       

      Thanks in advance.