Skip to main content
andrew_cummins
Helper ⭐️
Feb 1, 2016 10:33 PM UTC

Need more date filters for reports 2.0

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 ⭐️
    Mar 14, 2016 9:13 PM UTC
    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. 
    Translate
    brendan_hsu
    Contributor ⭐️⭐️
    Mar 15, 2016 10:26 PM UTC
    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.
    Translate
    gaurav_kotak
    Expert ⭐️
    Apr 25, 2016 10:47 PM UTC
    Hey Brendan, just looking at this thread. have you tried between filter for dates?
    Translate
    gaurav_kotak
    Expert ⭐️
    Apr 25, 2016 10:47 PM UTC
    Hey Brendan, just looking at this thread. have you tried between filter for dates?
    Translate
    andrew_cummins
    Helper ⭐️
    Apr 25, 2016 10:57 PM UTC
    problem with between filter with dates is it is not dynamic they are static dates for what he is trying to do I believe. 
    Translate
    brendan_hsu
    Contributor ⭐️⭐️
    Apr 25, 2016 11:20 PM UTC
    Andrew is correct.
    Translate
    cristina_postolache
    Contributor ⭐️⭐️⭐️⭐️
    Sep 21, 2016 7:23 AM UTC
    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.

    Translate
    andrew_cummins
    Helper ⭐️
    Sep 21, 2016 2:38 PM UTC
    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. 
    Translate
    cristina_postolache
    Contributor ⭐️⭐️⭐️⭐️
    Sep 21, 2016 2:50 PM UTC
    Yeah, this would be exactly what I need, it would avoid so much confusion with my internal consumers of Gainsight reports, dashboards etc
    Translate
    sudarshan_vig
    Contributor ⭐️⭐️⭐️⭐️⭐️
    Sep 22, 2016 12:48 PM UTC
    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.
    Translate