1. If the data extraction priority is higher than 50, it’s better to separate the dashboard and data extraction, so that you don’t need to request the priority update every time you update the dashboard.
2. Under the date, there is show missing data option if you want to show missing value on the x axis.
3. If you want to ignore the action for some metrics, you can check ignore action options

In looker, to change the column name, change it in the dashboard, instead of the query side.

For Synapse data, always add “set nocount on; ” in initiate query.