repeated charts

[Eric Bréhault]

Hello,

Imagine I have a data source providing figures about 4 different countries, and I need to display one chart by country.

The direct and easy solution is to define 4 charts (each of them filtering data according one country) and display them into a dashboard.

But there is 2 problems:

- it takes time (I need to manually define the same chart 4 times)

- if my data source change and suddently provides data about 5 countries, I need to update my dashboard.

So my question is: Is there a way to define the chart once, and then use one of the data column as a repeat variable ? (so the chart is repeated for each value of this column)

Regards,

Eric

[Zoltan Szabo]

Hello Eric,

In the case you are using googlecharts, I think the best and easiest solution would be, to use the pivot functionality, combined with the row  filters for pre pivot columns.

First you have to create the pivot in Chart Editor -> Table Configurator -> Table Pivots. Basically you just have to drag the column with the country names under your value column. This will create separate value columns for each country.

Then configure the chart for one of the countries. This will be your default chart, what will be displayed when you go to the view page.

Save the chart and add a new row filter. Now a dialog will pop up and asks for the column to be filtered. You should see the list of columns used in the chart, and some grayed out column names (these are the ones used for pivot). Select the one with the country names (it should be something like country (pre-pivot), then select simple category filter as type. 

Save the  charts and go to the view page. You should notice that a filter appeared, where you can select the country.

The list of the countries is always up to date, as it's generated runtime, so no problem when your data source is changed.

Note:

If you try to use this chart in a dashboard, this filter will not work.

I hope this will help you.

Cheers,

Zoli

[Eric Bréhault]

That's a nice feature I was not aware of, thank you (even if it is not exactly what I need).

Regards,

Eric

--
You received this message because you are subscribed to the Google Groups "EEA Daviz" group.
To unsubscribe from this group and stop receiving emails from it, send an email to eea-daviz+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.