Forum Discussion
Helper Vtop 5 VALUES by month
Helper Vi have a demo file. How do i attach it?
Super UserHi,
Please share the link of the pbix file.
You can try to use onedrive, googledrive, or dropbox to share the link.
Thanks.
- PPStar
https://drive.google.com/file/d/1E1BQCz6HY3xgmUo3LePYUG8OarQG1M7y/view?usp=sharing
can you access the file via that link?
Note
Consumer Usage is the measure i am using. We only want to see Consumer Usage of items. Therefore the consumer usage is te metric we are measuring against. So we want to see top 5 consumer used item by Month.
Thanks
- Jihwan_Kim
Hi,
Thank you for sharing.
However, it is difficult for me to understand the data model.
- Where can I find consumers information?
- PPStar
- Items table consists of item and each item has a ID
- Audit consists of the audit history of that item such as which operations they do to that item, (view it, edit it, export it etc), it also contains the ID of the item and the date that audit of that item took place.
- Activities is seperate table i created to define if an operation is a consumer activity or a admin activity. It connected to the audit table, so if the audit history table says the item was viewed, then i can state that was a consumer activity. If the audit table says that item was exported, then i know it was an admin activity.
The consumer is the operation they did from the audit history table labeled as a role.
Hope that makes sense