Domo Stats: how to filter out inactive licenses
Comments
-
Good morning,
After playing around with the Domo Stats data sets I unfortunatley was unable to find any sort of indication to wether or not they have an inactive license. The only thing I could think of at this point is to calculate based on the last day they logged in and if it is after a certain threshold to flag that account as inactive.
Let me know if you do discover anything!
1 -
Hey Guys
We used a beast mode on the domo stats data source - DATEDIFF(max(`Last Login`),CURDATE()) - kind of like @Cartergan said. but that enabled us to hit the "inactive" users
Nick
1 -
How does that find the inactive licenses? I get inactive users as those that no longer log in but I'm referring to employees that once had a license but no longer are at the company and thus the license isn't active.
0 -
ah, sorry my misunderstanding ?
hmm, difficult one - i guess if the hr department don`t access/update Domo, then I guess maybe your admin would need to be notified to remove them from your instance?
Edit: The data I believe is driven from usage, so Domo doesn`t have an inactive flag as it`s your companies data ?
OR maybe if there`s no login for x/y/z duration, work on an assumption that the user is no longer with the company? (dangerous - eg long term sick etc however you could add them back in if needed?)
0 -
Do you know if there is a way to get a list of active accounts from domo stats? If that's the case, I could simply overlay active accounts with historical data but I don't believe that's available.
0 -
hmm, i`d say no as I believe they only record logins, I`ve used a beast mode as other post, then either hit the license holder for why they`ve not logged in etc or I`ve been told that x/y/z has left business (I`m the admin)
sorry i cant add anything other than this
0 -
Yea, I'm the admin so I remove licenses from people as they leave. I guess I can apply a filter to every card using a custom beastmode that just lists ex-employees.
1 -
One possibility would be to create a list of inactive employees and join this to the domo stats data which would allow you to easily exclude those employees.
-----------------
Chris0 -
@D-Rab the DomoStats dataset People should only include the users in your instance. If you filter out social user that would be all of your active licenses. The dataset does not keep people in there who are not in the instance anymore. You could join this dataset with the one feeding the cards and only include matches so that old user data is not included.
**If this answer solved your problem be sure to like it and accept it as a solution!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive