distinct count

[Brian Fornelius]

Is there a way to get a distinct count of users.   I am trying to create a dashboard that shows total number of sessions and distinct count of users associated.   As of right now I am not sure how to get the distinct count of user ID's.

Any help would be appreciated.

Thanks,

--Brian

[AshishKM]

Hi @Brian Fornelius ,

Please share the table name , you are using for this dashboard. Transaction Log or Logged in users.

Did you try with pivot table report on which given the aggregate count result on defined column.

Example : the below pivot report on syslog_transaction table. 

[Brian Fornelius]

Hi there.   I am trying to do this under the Platform Analytics/Technical Editor.  So basically building the dashboard in UI Builder Advanced Analytics.   I am trying to apply it to a single score vs a pivot table

[Brian Fornelius]

I see I can select a distinct count from the single score when choosing the Metric Field selection.

Thanks,

[AshishKM]

nice to see , that it works form you.