login reccurence analyzed by group

stephr — Mon, 19 Oct 2020 14:57:54 GMT

Hello,

I have a table with all my login connexion, date of the connexion, and the organisationid.

It looks like this :

I'd like to create a graph to know how many organisationid came : "1 to 2 times", "3 to 5 times", "6 to 10 times", "More than 10 times".

So the result could be (with a bar graph).

1 to 2 times : 1000 Disctinct OrganisationId

3 to 5 times : 500 Disctinct OrganisationId

6 to 10 times : 200 Disctinct OrganisationId

More than 10 times : 50 Disctinct OrganisationId

I need to be able to add a filter by date and by tool id (third collumn of the picture).

Thanks a lot for your help

Stephen

Re: login reccurence analyzed by group

stephr — Tue, 20 Oct 2020 13:51:28 GMT

Please help 🙂