1 Reply Latest reply on Aug 6, 2014 12:00 PM by Shawn Wallwork

    Date Parameter Ranges Consolidation

    Jason Belsky



      I have a date filter question.  I am trying to display my data over a range of years. (2013 Q2-2014Q2).  However, I would prefer to only have one paramater control as opposed to 2 (end date and start date).

      Can this be consolidated? also will taking out the year in the column, consolidate everything correctly, or will the calculation be off?





      attached a screen shot

        • 1. Re: Date Parameter Ranges Consolidation
          Shawn Wallwork

          Jason, parameters can only have one value at a time, which is why you had to setup two of them in your viz. Is there a reason you didn't just set up a Date quick filter? If you can then you'll have lots of options on how the filter will work.


          On your second question, I'm not sure the YEAR(Date) is doing what you think it is. The map on the left is summing up 2013 Q2-Q4. The map on the right is summing 2014 Q1-Q2. If that's what you want then, yes you will want to leave the year in there. If on the other hand you want the totals for all the quarters in your date range, then you should take year off and get a single map of with all the totals.


          Hope this helps,