is there a way to group by a segment and get the m...
# ask-stanley-aip
PF
08/21/2024, 2:12 PMis there a way to group by a segment and get the maximum transaction id in a saved search? Currently I get more than one record returned for an OSA in the search
c
Celigo AI
08/21/2024, 2:12 PMAI generated answer (using internal Slack threads):Yes, you can group by a segment and get the maximum transaction id in a saved search. Here's how you can do it: 1. In your saved search, you need to set the "Summary Type" of the transaction id field to "Maximum". This will return the maximum transaction id for each group. 2. To group by a segment, you need to set the "Group" summary type for the field you want to group by. This will group the results by the selected field. 3. To avoid getting more than one record returned for an OSA in the search, you need to ensure that the fields you are grouping by uniquely identify each OSA. If they don't, you may need to add more fields to your grouping to make each group unique. Here's an example of how you can set this up: - Go to the "Results" tab of your saved search. - For the "Transaction ID" field, set the "Summary Type" to "Maximum". - For the field you want to group by, set the "Summary Type" to "Group". Please note that the "Group" summary type is not available for all fields. If it's not available for the field you want to group by, you may need to find a different field or combination of fields that can uniquely identify each OSA. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
08/21/2024, 2:12 PMAI generated answer (using internal Slack threads):Yes, you can group by a segment and get the maximum transaction id in a saved search. Here's how you can do it: 1. In your saved search, you need to set the "Summary Type" of the transaction id field to "Maximum". This will return the maximum transaction id for each group. 2. To group by a segment, you need to set the "Group" summary type for the field you want to group by. This will group the results by the selected field. 3. To avoid getting more than one record returned for an OSA in the search, you need to ensure that the fields you are grouping by uniquely identify each OSA. If they don't, you may need to add more fields to your grouping to make each group unique. Here's an example of how you can set this up: - Go to the "Results" tab of your saved search. - For the "Transaction ID" field, set the "Summary Type" to "Maximum". - For the field you want to group by, set the "Summary Type" to "Group". Please note that the "Group" summary type is not available for all fields. If it's not available for the field you want to group by, you may need to find a different field that can be used for grouping, or consider using a formula field to create a custom grouping field. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
08/21/2024, 2:13 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.809762955
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.804551899
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.800167918
Celigo AI
08/21/2024, 2:13 PMPlease provide your feedback on this answer.
Celigo AI
08/21/2024, 2:13 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.809762955
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.804551899
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.800167918
Celigo AI
08/21/2024, 2:13 PMPlease provide your feedback on this answer.