Another question from me, I am trying to pull out ...
# gooddata-cloud
c
Another question from me, I am trying to pull out activity by workspace, so far I am looking at Workspace Title and how many dashboard executions they each have. I am trying to see which workspaces have no executions in a month but I don't be able to see this, is there any advice for this?
m
Hi Chris, Thank you for your follow-up question. We have created an insight for you titled "`Dashboard Executions: GD.`" In this insight, you will find a table displaying the workspaces and their respective executions. For example, over the last month, all workspaces had at least one execution, which is why you won't see any workspaces without executions. Please take note of the metrics included in the insight.
Copy code
SELECT SUM(IFNULL(Actions count,0)) WHERE Action type IN ( "dashboard executed", "dashboard executed in inactive window")
If there are no values, for executions you will see the '0'. I have sent you by DM the link of the insight.
c
great thank you