Scenario: There are multiple Cases associated to a Company Record.
Created Date = Created Date of the Case
GSID (Case) = the GSID of the case records
GSID (Company) = the GSID of the company records.
Will the results only show the GSID (Case) for the case that has the Maximum created date? OR will it show all cases?
Note: doing this in data designer.
Best answer by romihache
Hi
You can’t use non-aggregated data with aggregated data, if you try to save that, it will give you an error
If what you are trying to do is identify the newest Case by Company you have to:
1: Bring in your initial dataset with the fields that you need
2: Do a transform grouping by Company GSID and the Max of the created date
3: Last, do an inner Join of 1 and 2, using both the Company GSID and date as identifiers
I recorded a quick walkthrough, hope this helps 😊
+8Hi
You can’t use non-aggregated data with aggregated data, if you try to save that, it will give you an error
If what you are trying to do is identify the newest Case by Company you have to:
1: Bring in your initial dataset with the fields that you need
2: Do a transform grouping by Company GSID and the Max of the created date
3: Last, do an inner Join of 1 and 2, using both the Company GSID and date as identifiers
I recorded a quick walkthrough, hope this helps 😊
Thank you! I thought it would give me an error too, but it didn’t. I didn’t validate to see whether there was only one row for the aggregation though. I guess I can go that route to validate.
I went the route you recommended to get what I needed though. Thank you!
+8Great news! Happy to help 😃
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
