2 Replies Latest reply: Sep 14, 2011 10:42 AM by Razvan Köpe RSS

    How can you limit a dimension

      Hello,

       

      this might be really simple, but i can't think of an elegant way of doing it. For example you have a graph with a monthly value, and the data is retrieved only half of the last month, because then is when you last refreshed the report. How can i make the chart ommit the incomplete month?

       

      See attached image, in this case in august the data was retrieved only partially, and i dont want to show it. I don't want the user to filter it himself, i want to do it by default. So it would end up only Jan - Jul values. And let's assume the metric is something like sum(apples)

       

      Selecting only complete month data from the database is what it comes to my mind, but maybe there is a more elegant way?

       

      Thanks!