How can I count distinc users authentications in a reporting configuration ?

I am trying to implement a reporting feature that counts the number of distinct users who authenticated to a given application over a specific time period.

To do this, I am using the accessDetail collection, which provides all the information I need (user identity, application, and authentication date). I was able to successfully apply filters on the application and the date range.

However, I am not sure how to filter or aggregate results based on unique identities.

For example:

User A authenticated to the application on each of the last three days, user B authenticated yesterday on the same application.
If I query with filters for that application and the last three days, the counter should return 2, since only two distinct users authenticated.

From what I understand, the fixedMatchOperator described in the public documentation does not seem to allow this kind of distinct identity filtering.

Do you know if this is possible with the available operators, or if there is another recommended approach?

Thanks in advance!

Hello,

If you use a counter chart with count(user.id) you should be able to count the number of user according to your criteria.

Here is an example from import report:

<display>
                        <chartType>COUNTER_CHART</chartType>
                        <counter>
                          <aggregationExpression>sum(numberOfCreatedIdmObjects)</aggregationExpression>
                          <borderColor>green</borderColor>
                          <counterColor>green</counterColor>
                          <icon>icon-note</icon>
                          <text>tenant.reporting.sync.created.title.label</text>
                          <title>tenant.reporting.sync.title.label</title>
                        </counter>
                        <displayOnInit>false</displayOnInit>
                        <legend>
                          <display>true</display>
                        </legend>
                        <size>
                          <cssHeight>500px</cssHeight>
                          <cssWidth>100%</cssWidth>
                          <radiusPercent>50</radiusPercent>
                        </size>
                      </display>

Regards,