Combining Dashboard Subscriptions and Alerts

Get Help
1

Hello,

We have access to the Usage Analytics and there’s very helpful dashboard for Dashboard subscriptions and alerts which I would like to be able to combine into 1 single question.

The need here is to be able to look at how many notifications/alerts are sent on a given hour and while I can figure that out separately, I want to be able to look at all the alerts in 1 view.

I wasn’t able to find a way to join the two tables using the visual editor so my guess there is that it’s not joinable? This would make my life 5x better

2

This is probably easier in a native SQL question inside the Usage Analytics collection, not the visual editor. The built in subscriptions and alerts models don't expose one clean join in the GUI, so I'd duplicate them into Custom reports, join on the pulse or dashboard id there, and group by the send timestamp hour. If you need actual sends instead of configured alerts, use the execution or notification history table rather than just the subscription definition tables.