topic Count Number of Groupings in Dashboarding

Count Number of Groupings

awassel — Fri, 04 Oct 2024 20:24:19 GMT

I'm using the below query but it's not giving me the exact

SELECT userSessionId, COUNT(*) FILTER > 1 FROM usersession GROUP BY userSessionId

This give me the table with all the results, but I'm looking for the total number of groupings. Basically, this is the result:

However, I'm looking to get 5 - or the total number of rows (groups) in the table.

Is this possible?

p_devulapalli — Mon, 07 Oct 2024 02:52:36 GMT

Hi @awassel , Does something like below work ? If not, could you please elaborate your query a bit further

SELECT COUNT(DISTINCT userSessionId) AS sessionCount FROM usersession

Peter_Youssef — Mon, 07 Oct 2024 06:06:24 GMT

As per the attached query the below result will be presented

And as per the query provided by @p_devulapalli, the below result is presented.

BR,