Dashboard Analytic for Count of Unique Values

Support, Troubleshooting, & Help
, ,
1

I am trying to create a shareable dashboard chart analytic to show count of unique users creating records in a given system, per day, perhaps grouped by site, based on the

I can’t seem to figure out how to do this, so I’m open to any suggestions.

LTS 8.2, private cloud.

2

@jmlowden The good news is that this feature has been added in newer releases. Bad news-- in LTS8.2 I think the only way to do this is going to be some insane unscalable formula like so:

IF(COUNTIF(USER = “USER1”)>0, 1, 0) +
IF(COUNTIF(USER = “USER2”)>0, 1, 0) +
…
IF(COUNTIF(USER = “USERN”)>0, 1, 0)

1 Like
3

Is this included in LTS 11?