Expand my Community achievements bar.

Please make the (line) chart showing actual history of the selected data

Avatar

Level 2

2/10/23

 

Description

The chart visualization ignores applied filters. Selecting the sparkline as the data source always shows all data for the respective dimension. Selecting one metric as a data source shows the first attribute of the dimension for all metrics.  

 

Warum ist Ihnen dieses Feature wichtig

In practice: it makes it hard to find out, at what point in history a dimension starts being populated. Imagine you implement the dimension somewhen in last year and need to find out, when it was. You create a table/chart for the last year. But what you see is traffic for this dimension for the whole year. 

 

Also the chart gives a wrong picture of the data, if you apply filters to your dimension. It's just a bigger representation of the sparkline, which always shows the history of all data, including datapoints, where there is no actual data ("unspecified").

 

If I select one metric as a data source, the chart will show all metrics and the first dimension attribute only. This seems to be counter intuitive. 

 

Wie soll das Feature funktionieren:

It should be possible to get the history of the selected data considering applied filters. If not by a single click, but by

an option that says "show actual" data. 

 

If I select one metric as a data source, I'd like to see the data for this metric only. 

Either of them should allow me to see the actual historical data for the selected dimension and metric. 

 

Aktuelles Verhalten

 

If you create a line chart based on a table and select the sparkline cell as the data source, the line chart will show the data from the sparkline. It will not change even if you apply a filter to the dimension. 

 

Reproduce:

1. create a Workspaces > Project > Table with rows showing a dimension, columns showing a metric (e.g. Occurences, Page Views, Visit)

2. make sure, that "show unspecified" is enabled

3. create a line chart for this table, select one cell containing a sparkline to make this the data source. The chart shows one line representing the sum of all dimension attributes

4.disable the option "show unspecified"

 

The chart will reload, but it will be the same as before. 

 

5. select three attributes of your dimension and choose "display selected rows only" from the contextual menu

 

Again, the chart will reload, but it will be the same as before. 

 

6. select the actual metric (the green cell) as the data source

 

Again, the chart will reload, but now it will show ALL metrics, but only the first attribute of the dimension