Back to Pricing Dashboard User Documentation - Main Page
My Data Report is the module of the pricing dashboard where it is possible to display and download the raw data tables you need for your analyses in an Excel/Spreadsheet format.
Data accessibility is linked to the visibility model, if your profile does not allow to see costs/ICM data, you will not see all the information of this page!
My Data Report Navigation
There are several data set available in my data report
- Sales Report
- Margin Waterfall
- Sales Chart
- Campaign report
My Data Report Information
Find all the dimensions and measures available in my data report.
How to download data?
Right-click the table in My Data Report you want to download data from.
Select
Download as... and Export data.Click the link to download the data file.
Open or save the file.
The default maximum number of rows and columns in the Excel export file is:
- 1048566 rows per sheet. For pivot tables: 1048566 column dimensions. 10 rows can be added after the export.
- 16384 columns per sheet. If the number of columns exceeds the limit, the exported file is truncated and a warning message is sent.
3. Sales Chart
1- Displays the table either in combo chart or scatter-plot chart
2- Information can either be displayed in EUR or USD currencies. Sales and Unit price are also available in DC as Measures
RSB=Yes Uses the period's last month Fx rate to convert Document currencies into EUR/USD
RSB=No uses the average monthly Fx rate
3- Dimensions and measures added appear there. They can be switched off or removed. You can also reorder them by dragging them to the desired position.
4- List of available dimensions
5- Timeline filters
6- List of available measures. These can be searched and typed directly in 3.
1) Only one dimension can be selected for the sales chart; up to 3 measures can be selected.
2) In Scatter-plot chart, when 3 measures are selected: the first first measure is related to the size of the bubbles; the second measure is the Y-axis; the third measure is the X-axis. If you wish to switch the X/Y-axis or use another measure to show the size, you need to delete the selection and select the measure(s) in the sequence of in the chart you wish to display.
1) Next to each measure, a default chart is proposed. However, we can switch the chart type by left clicking on the chart icon, and select another chart type.
2) How to show data points/labels?
3) How to change the columns order?
For example, I wish to display Volumes first, then Sales, ICM comes the last. First remove the selection of the 3 measures, and select first Volumes, then Sales, and then ICM.
4. Download the data
Right-click the table in My Data Report you want to download data from.
Select
Download as... and Export data.Click the link to download the data file.
Open or save the file.
The default maximum number of rows and columns in the Excel export file is:
- 1048566 rows per sheet. For pivot tables: 1048566 column dimensions. 10 rows can be added after the export.
- 16384 columns per sheet. If the number of columns exceeds the limit, the exported file is truncated and a warning message is sent.