Monthly Count for Active Users Indicator

SkyGarden · ‎10-16-2024

I wanted to create a Automated Indicator so that it shows the Monthly count for Active users.

could you please help to create an indicator and their Jobs as well.

SumanKumarM · ‎10-16-2024

Hello Arjun43,

Please try below link, it might help you in resolving the issue you mentioned.

Please mark helpful, if it helps you to start implementation.

Best Regards,

Suman

Kenta Koizumi · ‎10-16-2024

You can create a report by using such a below condition.

- Data table: User [sys_user]

- Filter_Active is TRUE

- Filter_Last Login on this month

- Visualization type is Single score

Then, you can see the number of active users for this month. [Photo1]

If you choose "column" for visualization type and trend by "Month by Last login", you can see a column graph for monthly active users. [Photo2]

SkyGarden · ‎10-17-2024

Hi Kenta,

I am looking for indicator not reports.

Thanks

Kenta Koizumi · ‎10-17-2024

Sorry for misunderstanding.

For indicator, firstly you need to create a new indicate source for such as below conditions.

- Facts table == sys_user

- Valid for frequency == Monthly

After that, you can create a new automated indicator for counting monthly active users.