If this is not currently possible, it would definitely be nice to have since it's already a feature in other aspects of Report Builder.
Question
Summarize Date Field by Fiscal Quarter in Report Builder?
+1Does anyone know if it is possible to summarize a date field in Report Builder by fiscal quarter? It looks like there only option is calendar quarter which is fine but not ideal for a number of reports. For example, we would like to be able to report on our NPS results quarter over quarter and our leadership cares more about fiscal rather than calendar.
If this is not currently possible, it would definitely be nice to have since it's already a feature in other aspects of Report Builder.
If this is not currently possible, it would definitely be nice to have since it's already a feature in other aspects of Report Builder.
Hey Calvin!
You should be able to set your Fiscal Quarter from within SFDC: https://help.salesforce.com/articleView?id=setting_the_fiscal_year.htm&type=5
Does that get you what you need? Thanks!
Tim
You should be able to set your Fiscal Quarter from within SFDC: https://help.salesforce.com/articleView?id=setting_the_fiscal_year.htm&type=5
Does that get you what you need? Thanks!
Tim
+1Hey Tim,
Thanks for the quick reply! I believe we've already set that up in Salesforce and it already works for reports were we are filtering by dates.
The issue we are facing right now is that when we summarize a report by date, it seems like quarter is set to CQ instead of FQ. For example, we are still in Q2 but our reports are showing some responses as Q3 (end of July is the end of our FQ).
Thanks for the quick reply! I believe we've already set that up in Salesforce and it already works for reports were we are filtering by dates.
The issue we are facing right now is that when we summarize a report by date, it seems like quarter is set to CQ instead of FQ. For example, we are still in Q2 but our reports are showing some responses as Q3 (end of July is the end of our FQ).
Hm... Let me ask internally. Is this object in SFDC or MDA?
+1Thanks, Tim! We are building the report off of an SFDC object called NPSSurvey Response.
Strange - that should obey the fiscal year settings in SFDC. Can you check that setting and I'll check internally as well? Thanks!
+1Update - I was able to get the report to summarize by fiscal quarter. I changed the date filter from Response Date <= This Month to <= Current FQ and that seemed to fix it.
1 person likes this
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.