New Idea
More day filtering options in report builder
Currently when you build reports off of the case object and you summarize by Date and filter for last 90 days the report reflects the Fiscal Year settings in SFDC. We would like to see the option to filter more granular (IE Fiscal Day, Calendar Day, Business Days), and have the option to select Fiscal Settings in SFDC or an option for Month.
+4This is a very big deal to us. Our fiscal settings are setup the way they are for finance reasons.
But when I create reports using "Last 90 Days" for example, the results show like this:
Of course if I use "Last X Days" and enter 90, I get the desired results (except for the decimals):
According to support, the bug is in "Last X Days" not "Last 90 Days" and when they fix the bug BOTH reports will reflect the Fiscal settings - which looks ridiculous.
Engineering designed this to respect the fiscal settings but I don't know why. The above report examples are from the Case object depicting Cases Closed over Last 90 Days.
What do support cases have to do with the fiscal values? Most objects upon which we would want to aggregate by date don't have any correlation to fiscal values, therefore this design seems flawed.
But when I create reports using "Last 90 Days" for example, the results show like this:
Of course if I use "Last X Days" and enter 90, I get the desired results (except for the decimals):
According to support, the bug is in "Last X Days" not "Last 90 Days" and when they fix the bug BOTH reports will reflect the Fiscal settings - which looks ridiculous.
Engineering designed this to respect the fiscal settings but I don't know why. The above report examples are from the Case object depicting Cases Closed over Last 90 Days.
What do support cases have to do with the fiscal values? Most objects upon which we would want to aggregate by date don't have any correlation to fiscal values, therefore this design seems flawed.
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.