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

Hello zohebakber,

Did the solution offered by rapidbisupport  work for you? If so, please click the 'Accept as Solution' button so that other users with the same questions can find the answer faster. If not, please let us know so that we can continue to help.

Thank you.

Reviewing this as we have the same question.  Receiving a syntax error from the query recommended. 
Will also take a look at the API solution, but an OOTB solution/report would be nice!

Hello @zohebakber,

Did the solution offered by @rapidbisupport  work for you? If so, please click the 'Accept as Solution' button so that other users with the same questions can find the answer faster. If not, please let us know so that we can continue to help.

Thank you.