Description
Description
Currently we display the users that made the most queries in the last 7 days on Usage Analytics feature.
For example:
It would be useful to know in what context these users were in when that query count increased.
What has been reported is that this count also increases for Scheduled Deliveries. Since that's an automated process, should it be part of this count metric? I believe not.
Code
add context(or similar... action?) to:
type DbUserWithCount = {
user_uuid: string;
first_name: string;
last_name: string;
count: number | null;
};
So that we can count queries that users performed on charts, dashboards, scheduled deliveries, syncs, exports, etc
Acceptance criteria
-
users who have run the most queries in the last 7 dayshas the total queries broken out across the differentquery_sourceoptions (as well as the total queries)
Docs
- update the usage analytics docs here: https://docs.lightdash.com/references/usage-analytics#user-activity-dashboard:~:text=%25%20of%20weekly%20querying%20users,viewing%20charts%20and%20dashboards.
to:
-
Users that have run the most queries in the last 7 days: a list of the users that have run the most queries in your project in the last 7 days. This shows the total queries, and also the queries broken out across different query sources.
-
Add a note above
Here's an overview of the fields used in the dashboard:saying:
:::info
Unless specified, the count of queries includes queries executed from running scheduled deliveries, syncs, exports, viewing charts or dashboards, and running queries in the Explore view.
:::