SOLVED

Graph of System Usage

New Contributor

I have a table of users of a system.  Each row contains details of the user account, including the date that each user account was created and, if they have left the business, the date it was deactivated.

How can I create a graph which shows, for each month the system has been live, the number of total live user accounts?

If possible, I'd like to do this using Excel and Pivot Tables / Charts (but could use PowerBI if needed).

Thanks in advance

2 Replies
best response confirmed by Riny_van_Eekelen (Esteemed Contributor)
Solution

@Hugh Murfitt 

See the attached example for one possible solution.

Wow! @Hans Vogelaar   That's awesome.  Thanks!