Date Field Group by on flattened survey object

  • 6
  • Idea
  • Updated 4 months ago
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. 
Photo of Cameron Wright

Cameron Wright, Employee

  • 2,674 Points 2k badge 2x thumb

Posted 4 months ago

  • 6
Photo of Leanne

Leanne, Champion

  • 4,348 Points 4k badge 2x thumb
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.