Active, Passive, and Inactive Users report

Hello, a year or two ago there was a correlation noticed between # of active users in an account and stickiness or renewal probability. There's no easy way to pull a report on that in Reports or in DOMO, but I've received it from the Partner Relations Team a few times. Can we add that to the mix so consultants can pull it? Basically 4 or 5 columns -- Company Name, Health Indicator/Status, # of Active Users, # of Passive Users, and # of Inactive Users.

Thanks!
Clayton