I’m trying to come up with an expression that counts only unique values in a table field to use in an analytic calculation.
Basically think of having a table where each record is a batch record. We might run 3 or 4 batches in a day. There is a field in the table that records the text format of MM/DD/YYYY (month / day / year) for each batch.
I’m trying to figure out a way in an analytic that will calculate the number of working days.
So what I need is a Count Unique function (or workaround), that Counts the number of unique values for our Start Date field (which is a text field).
I think it would look something like this as an aggregated expression:
SUM( COUNTUNIQUE( [Table.Start Date] != ‘Null’ ))
Any ideas of a workaround?