List of all the dashboards along with date of creation

Hi zohebakber ,

You could duplicate the OOTB Usage Analytics Model and then find the first action performed against distinct dashboards:

SELECT o.dashboardId AS [Dashboard ID], MIN(o.timeStamp) AS EarliestDate
FROM [usage] o
GROUP BY o.dashboardId

Then on a dashboard, it's just a matter of adding count([dashboardid]) as value and then months as category:

Please note though, this will provide the earliest user performed action by dashboard, so I assume that if you upload a dashboard and don't open it it won't appear in this query (this is untested).

There are alternate methods to do this - GET request from the /dashboards endpoint for example - that may suit your requirement better but are more complicated to implement than the above.

 Let me know how you go?

Thanks,

Daniel

RAPID BI

[email protected]

RAPID BI - Sisense Professional Services | Implementations | Custom Add-ons