Counting Unique Dates on Unique Entities

Has anyone been able to Count unique dates on a unique entity? We’ve only been able to get a query field to count all dates associated with the entity, so where there should only be 6 unique dates we get a count of 100+ since it’s counting all. Any help or insight would be appreciated!

1 Like

Hi Rachel, I think you may need to narrow down the information a little bit further in the filtering part of the query to get the data you’re looking for. I don’t think there is a way to get the number of unique values/dates only. What specific type of entity dates are you looking for?

Hi Jessica!
Thanks for your response. We have a dialogue entity with a date recorded field.

We were hoping we could use the date recorded field to count the number of sessions used with talent by counting the unique recorded dates, but so far we’ve only been able to count all the lines with a record date.


Unfortunately at the moment you can’t query unique instances of a number in a query field.

The only solution I can think of us to use a widget. You could create a graph widget that graphs the the talent by talent name and grouped by the date recorded field. This would visually show you what you’re after, if that helps!

1 Like

Thanks Jessica - I’ll give that a shot!

Do you know if there is anything in the works to be able to query unique instances of a date or number in a query field? That would be helpful!