The export button on the Dashboard exports the raw data to a CSV. To export the Dashboard keeping the colour scale and comparator indicator, shown in Local Insight, follow the below steps:
- Highlight the cells in the Dashboard that you want to copy
- Right click and select copy or hold Control+C on your keyboard
- Open a new Excel sheet
- Right click on the first cell and under the paste options select Keep Source Formatting (k)
How does the colour scale on the Dashboard work?