Count users per month in a dashboard

[Luca_Dipa]

Hi guys,

I would like to ask you a question. How could I calculate the number of registered users per month if I have the registration timestamp available?

I have this Dashboard table to manage everything and the timestamp in the Users table:

Thanks

[Darren_Murphy]

My suggestion:

• In each of the two tables, create a math column that converts the Dates (Month of the Year and Registered Timestamp) to integers in YYYYMM format. Use the following formula:

Year(Date)*10^2
+Month(Date)

• In your Dashboard table, create a multiple relation column that matches the integer date column with the same column in your Users table
• Do a rollup->count through that relation

[Luca_Dipa]

Much easy than I expected!

Thank you Darren for the help!!!