I have a customer that has been trying to work through building reports on a flattened survey object, they were following the documentation here: https://support.gainsight.com/Product_Documentation/Surveys_and_NPS/Examples_and_Tutorials/Create_CS...
We show the ability to adjust the summarization on our Date field in the Survey Flattened object.
After speaking with L2 this is not a supported function. They mentioned that he summarization on our Date field will only be shown on objects that are stored in SFDC (or) Redshift and this is not available for objects in HAPOSTGRES.
As survey flattening object is stored in HAPOSTGRES we do not have this as an option.
The problem here is we have documentation saying this is possible and not only does this frustrate the customer but also support as we rely on the documentation also.
If this could be added as a function I think it would help not only the customer that has experienced this inaccuracy but also customers in the future that will want to do this.
New Idea
Date Field Group by on flattened survey object
I just ran into this too. I'm trying to slice our NPS reports by another question on the NPS survey, and so need to use the flattened survey report. What I was told by Support is that the Summarize option is not available for the objects that are in PostgreSQL, and as survey flattening is in PostgreSQL, we don't see this option.
No idea what PostgreSQL or HAPOSTGRES are, but whichever is the right thing, I agree that we need to be able to group date fields. The report I'm working on will quickly become unusable if I can't.
No idea what PostgreSQL or HAPOSTGRES are, but whichever is the right thing, I agree that we need to be able to group date fields. The report I'm working on will quickly become unusable if I can't.
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.