How to group a field that is set up to not store d...
# suiteanalyticsg
Gustavo Doná
09/28/2020, 7:51 PMHow to group a field that is set up to not store data and are defaulted to a formula. I'm trying to do so but I get errors when I try..
k
KevinJ of Kansas
09/28/2020, 9:09 PMwhat's the error? and what is the field type? field name?
g
Gustavo Doná
09/28/2020, 9:11 PMUnexpected error when I try to load the saved search, it's a custom field (I tried date and text..)
k
KevinJ of Kansas
09/28/2020, 9:12 PMYeah, but what is the field type?
KevinJ of Kansas
09/28/2020, 9:13 PMIs it based on a date field?
KevinJ of Kansas
09/28/2020, 9:13 PMDepending on the date field you are using as the formula - you could have problems summarizing it as a "group" - you may need to use "max" or "min" instead.
KevinJ of Kansas
09/28/2020, 9:14 PMOf course - if that's a valid field for grouping- meaning you can get matching results with different dates - max or min doesn't work - and you'll have to get more... creative.
g
Gustavo Doná
09/28/2020, 10:36 PMHahahah ok, I'll try that out. Thank you very much for your help
2 Views