Opened 2 years ago

Last modified 4 weeks ago

#2786 new New feature

Allow to plot custom variable values (or any rows) by searching & plotting

Reported by: elboletaire Owned by:
Priority: normal Milestone: 2.x - The Great Piwik 2.x Backlog
Component: UI - UX (AngularJS, twig, less) Keywords: custom variables, graphs
Cc: aleix@… Sensitive: no


At the custom variable section, when you select to show them as graphs, there is only one graph that shows the name of the variables used.

What I suggest is to generate one graph for each custom variable, so the data shown will be from its values.

Change History (5)

comment:1 Changed 2 years ago by matt (mattab)

  • Component changed from Core to UI (templates, javascript)
  • Milestone set to Feature requests

Thanks for the suggestion. the question is how to allow plotting any custom variable value ? We would have to add a new "Graph" icon in the "Custom Variables values" subtable, which might not look so good. But we would definitely like to allow plotting any report sub-table.

comment:2 Changed 2 years ago by luto

Any news on this? I would love to have this feature!

comment:3 Changed 2 years ago by matt (mattab)

  • Summary changed from Show graphs for each custom variable to Allow to plot custom variable values (or any rows) by searching & plotting

I think we can implement this the following way:

  • If you'd like to plot the custom variable values for a particular name, you would first "Flatten the report" using the new feature accessible from the Cog icon on the right, in the footer of reports with sub tables.
  • The report will then show $name - $value for each custom variable, "flattening" the report;
  • Then, user could click on the "Graph" icon to plot only these rows in a graph.

Things to do to implement this ticket

To make this use case nice and useful, we would need to:

  • Bug: When a search was made and graph icon clicked, the search term should be kept in the URL. Currently the search term is not forwarded at all.
  • Bug: it seems the API does not return the values properly: index.php?filter_sort_column=nb_visits&filter_sort_order=desc&viewDataTable=graphVerticalBar&module=CustomVariables&action=getCustomVariables&filter_column=label&filter_column_recursive=label&idGoal=-1&filter_offset=0&date=yesterday&period=day&idSite=1&idDashboard=1&enable_sort=1&controllerActionCalledWhenRequestSubTable=getCustomVariablesValuesFromNameId&landed=&flat=1&columns=nb_visits&rows=&disable_generic_filters=0
  • UI: Finally, the search term should be displayed below the graph, in the search box. However the search box should only be displayed when there was a term, not all the time.
  • Graph: it would be nice to display, in the graph footer, the currently applied filters: "Custom Variables names containing '$FILTER'".
    • Later we could also write "Custom Variables names containing '$FILTER'. $SEGMENT_NAME" which would append "All visits from mobile devices" for example.

comment:4 Changed 16 months ago by matt (mattab)

  • Milestone changed from Feature requests to 1.x - Piwik 1.x

comment:5 Changed 4 weeks ago by andyg2

I'm also after this feature.
I've added a blog post with a possible UI flow for this.,112980,113223

Note: See TracTickets for help on using tickets.