Exports

In addition to the automatized dashboard notification, there are various ways to manually export data from AgrEGG.

Excel Export

The easiest way is to export data in Excel format.

Over tables you can find the button “Excel Download”. Click it to download the content of the table.

Similarly, click on the button with three lines in plots, then select “Download Data”, and finally “Excel Download” to download the data from which the plot is built.

../_images/download_data_plot.png

EMF/SVG Export

It is possible to download a plot in vectorial form, via the function “Copy”, after clicking on the button with three lines on top of the plot itself. At this point the object can be directly pasted in another program, or downloaded as a file with “More” and then “Save EMF”.

../_images/save_as_svg.png

PDF Export

A whole Dashboard can be downloaded as a PDF file. Click the button “Export as PDF” on the top bar.

../_images/export_as_pdf.png

A preview will be shown. If necessary it is possible to edit it, otherwise click “Export PDF” to download the file.

../_images/edit_pdf.png

Power Point Export

Similarly, a whole Dashboard can be downloaded as a Power Point file. Click the button “Export as Power Point” on the top bar.

../_images/export_as_ppt.png

You can upload a custom template for each By Whom or global via the django admin interface in the “PPTXs Config For Dashboard” table.

The power point could have #title# where do you want the dashboard title. The power point could have #fw# where do you want the current subsite by whom name. The power point could have #period# where do you want the last period selected label if a filter is manually selected. The power point could have #period#-1 where do you want the last period selected label - N year if a filter is manually selected. And in a text palceholder the pptx share string (e.g. !#/cms/menu/1/41/!#106!# ). You can obtain this string by pressing CTRL + Q or via the share menu.

If the graph is a table you can obtain a single value via the following snippet, where C0 is the first column and R0 is the first row.

!#/cms/menu/1/41/!#106!#R0C0

You can also, only for columns, get last column value by using -1 insted of 0 (e.g. !#/cms/menu/1/41/!#106!#R0C-1), or -2 and so on

If the code end with color (e.g. !#/cms/menu/1/41/!#106!#R0C0!#color) a semaphore will be show.

You can select if the power point is global and add a json config to use the power point only in some specific dashboard based on filter (gff):

{"key": "level_item_x_attr_X", "value": "150"}

First of all AgrEGG is searching non global report for specific by whom and filters. If not report is found AgrEGG search for global report

DWH Report

GO under ADMIN->Export->DWH Export. Select the desired period, optionally the currency, and it will be possible to download a csv file with the data, divided by business units, if available.

../_images/dwh_export1.png ../_images/dwh_export2.png

PPTX Report

It is also possible to automatically create customized Power Point presentations.

../_images/pptx_report.png

Go under ADMIN->Export->PPTX Download, then click “New”. Select the business unit under groups. It is necessary to provide a .pptx template file, to be uploaded via the “Browse” button. The power point can be empty or with placeholder item. The placeholder can be obtained via the share menu in each graph. If you want to get a cella value append the row and the column at the end of the snipped: “R3,C4!#” Remember that the coordinates are zero bases and the header count as row number 0.

Give a name to the report and click “Save”.

You will be redirected to the main page of the PPTX Reports.

Here you can Generate the power point with the placeholder with the “generate” button or you can create a bulked action with the “Bulk Generate” button. With the “Bulk generate” action you will be redirected to a page where you can select the by whom you would like to generate the power point or you can select a list of dashboard that will be fully used for power point generation. otherwise if you not select any Dashboard the placeholder will be replaced for each By Whom selected.

Please note that the placeholder string should not have “fwf” strings (that stand for By Whom) and “per” strings (that stand for Period)

Please remember that only user with PPTX Export permissions or staff user can edit all other Power Point templates.

Placeholder configuration

If you want to show the last upload date of an import type id

"upload_date": <import_type_id>

!#/cms/menu/6/69/!#upload_date=%m=None!#
!#/cms/menu/6/69/!#upload_date=%Y=None!#
!#/cms/menu/6/69/!#upload_date=%Y%m=None!#
!#/cms/menu/6/69/!#upload_date=%Y%m%d=None!#

If you want to show the By Whom label

"fw": !#/cms/menu/1/69/!#fw!#

If you want to show the cell value, for example row 3, cell 4 (0 based)

"fw": !#/cms/menu/1/69/!#188!#R3,C4!#