Update Quickchart dinamically based on filter

Hi guys,

I’m trying to use a quickchart template to create a graph in a virtual column. The chart should get the value of the filter and show only specific rows. Also, my filter responds to some buttons I’m using in my app.

Currently my formula looks like this inside a concatenate() statement (where ‘json’ is the table I want to show in the chart):

{
  type: 'bubble',
  data: {
    datasets: [
      {
        label: 'My First dataset',
        backgroundColor: 'rgba(255, 99, 132, 0.5)',
        hoverBackgroundColor: '#ffa9a3',
        borderColor: 'rgb(255, 99, 132)',
        borderWidth: 1,
        data: ["&LIST(SELECT(json[json-medio-risco], ANY(Filter[Area])=[Area],TRUE))&" , ] ,
        ],
      },
    ],
  },
}

I’m able to generate the graph I want to, however chart is now changing according to filter selected. Any recommendations on how to achieve my goal?

Thanks in advance

It is unclear what your goal even is, or what the current issue is.

1 Like