I have this dashboard that displays a table of field values from a data set. At the top are some filters, including time range. I'd like to indicate in the table which values in a certain field are unique across all time - i.e. have never been seen in the whole data set.
For example if, in the last 24 hours, the user names "Bill", "Fred" and "Emmy" have been input but only "Emmy" has never been seen in the data set ever, I want that flagged up.
I really would want the solution to be "live" i.e. not rely on a lookup table but be computationally light as the dashboard refreshes regularly.
... View more