Use Filter Box selected value as parameter in chart metric

[fedecere94]

I have the following environment (a dashboard with a Table Chart):

Database Table (the one the chart refers to):

  name     A     B     C     D
 --------------------------------
    x      1     0     0     1
    y      1     1     1     1  
    x      0     0     0     1
    y      1     1     0     1   

Table Chart:

name     SUM(A)
-----------------
  x         1
  y         2

What I want to do is:

add a FilterBox with the Column A, B, C, D of the table like choices and when the choice X (a generic one between the four choices previously cited) is selected, the second column of the chart should show SUM(X)

In few words: I want to change the metric of a chart based on a filter Box value

Is this possible?

[issue-label-bot]

Issue-Label Bot is automatically applying the label #enhancement to this issue, with a confidence of 0.76. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[fedecere94]

I finally found the solution by myself. I used filter_values macro that can read the filter values through the analysis of the url parameter form_data (in which all of your filter are stored).
See #5547 to better understand how the filter_values macro work