Best Answer

XLS of Branches and Groups

  • 8 March 2023
  • 3 replies

Userlevel 4

I’d like to be able to access a quick XLS report on the number of Groups that are on the platform for an in-house report. This gives me the number of Branches (named after our clients), but I need the number of Groups (aka cohorts) that we provide for our clients. 

Has anyone been able to achieve this? It seems that I have to do it by counting manually. It also seems odd that I can’t get a Group count… 



Best answer by Nicole 8 March 2023, 17:23

View original

3 replies

Userlevel 4

I just found it by fluke! 
For those who also want to know, go to your Users then click on the three dots icon (in scree shot it’s now changed to an X, then select Groups. 
Mystery solved, Scooby Snacks for all. 


Userlevel 4

It’s not a perfect solution, I’d still like to have an .xls download rather than calculating the math myself on how many pages there are of groups and how many groups are on a page. It’d be great if it just listed the Branch and the groups associated with the branch in an .xls

Userlevel 3

You might be able to extract the data through the API and then do some excel magic to sanitise it into a format that you require.