KayodePrince The VM Insights dashboard is a great working example using advanced Kusto. I was not aware you could use Kusto Queries to generate variables, way more complex than I've built to date. More to learn from this*.
We started using Grafana's Cloud hosted solution in addition to Azure Dashboard sometime ago. Grafana's integration with Azure Metrics and Logs is the only solution I've found which integrates with Azure APIs rather than exporting data. Azure Hosted Grafana is an interesting alternative from both security and cost perspectives. We are beginning to explore Loki for legacy application log aggregation. Azure Hosted Grafana might be a better solution if Loki is supported.
*Note: I found I needed to update the Kusto Resource Group queries in VM Insights dashboard from '/p(.*)' * to '/providers(.*)' * to get the queries to work in our environment.