Skip to main content
andrew_cummins
Helper ⭐️
February 1, 2016

Need more date filters for reports 2.0

  • February 1, 2016
  • 25 replies
  • 131 views
It would be great to have more date filters. Maybe a custom filter that allows you to see anything you want. You would not longer need all the filters you have and no one would probably ask for another filter after this update. You could have it set up so that you say case "Close Date" = DROPDOWN ["last" and "next"] then have a number field I can input any number I want and then after that DROPDOWN ["days, weeks, months, years"]

    25 replies

    andrew_cummins
    Helper ⭐️
    March 14, 2016
    what date are you using in the "by" section and what date are you using in the filter section...i.e. "created date" or "closed date". I have experienced the same and if you put something like "created date" in the by section and then "closed date" in the filter section for Next quarter or vice-a-versa then you may get what you want but yes that is a limitation I have faced as well. if you feel comfortable just share a screenshot so I can see what your report looks like just remove any sensitive data like account names or numbers, ect. 
    brendan_hsu
    Contributor ⭐️⭐️
    March 15, 2016
    Thanks for the help, Andrew! Unfortunately, the object I'm pulling doesn't have too much other helpful info. I've already filed a ticket with support, who determined that what I'm looking for is not currently possible.
    gaurav_kotak
    Expert ⭐️
    April 25, 2016
    Hey Brendan, just looking at this thread. have you tried between filter for dates?
    gaurav_kotak
    Expert ⭐️
    April 25, 2016
    Hey Brendan, just looking at this thread. have you tried between filter for dates?
    andrew_cummins
    Helper ⭐️
    April 25, 2016
    problem with between filter with dates is it is not dynamic they are static dates for what he is trying to do I believe. 
    brendan_hsu
    Contributor ⭐️⭐️
    April 25, 2016
    Andrew is correct.
    cristina_postolache
    Contributor ⭐️⭐️⭐️⭐️
    September 21, 2016
    I would need more flexibility at month level, my CSMs always think that there is something wrong with the data, but it's because of the filter I use for some reports, and that is Last 120 Days. The problem is that some months get truncated because of this, and the graphs won't show the full picture.

    In the example below, May is truncated because the Last 120 Days only includes some of the days in May.

    andrew_cummins
    Helper ⭐️
    September 21, 2016
    So you would simply need something that gave you "Last N Months" we have the ability to show "Las N Days" but not months right now. If we did you would capture the entire month in each time interval. 
    cristina_postolache
    Contributor ⭐️⭐️⭐️⭐️
    September 21, 2016
    Yeah, this would be exactly what I need, it would avoid so much confusion with my internal consumers of Gainsight reports, dashboards etc
    sudarshan_vig
    Contributor ⭐️⭐️⭐️⭐️⭐️
    September 22, 2016
    Sure Cristina, we can go ahead and add some more standard duration filters like "Last N months" and "Last N weeks". I will add it to the roadmap and let you know when we pick it up.