How to download and use data from your rate and demand dashboard
In order to further manipulate and analyse data in your rate and demand dashboard, it is possible to download data behind each chart in the view.
Selecting the 'Export CSV' from the ••• icon in the top right of any of the various charts will download a CSV file to your computer. The produced file will include dates and values underlying the displayed graph that corresponds to the filters that are in use.
You are able to import to a google sheet through file>import... and selecting where you wish the import to be entered. If you are using excel, read on...
If after opening the CSV file, the text is all in a single column and you prefer it to be separated at each comma into individual columns, follow the next steps:
1- Click and drag the cursor to highlight the column you want split.
2- Navigate to the “Data” tab (located in the top menu bar).
3- Click “Text to Columns”.
4- Choose the “Delimited” option, then click on “Next”.
5- Select the “Comma” checkbox, then click on “Next”.
6- Click “Finish”. All the text that was previously separated by commas will now be placed in separate, individual columns.
From here you will be able to filter and present different elements of the raw data for your own analysis and tracking.
Hopefully that's answered your questions! If not, feel free to drop us an email at support@seetransparent.com, or use the chat function from your dashboard, and we will be happy to help you with any questions you may have.