Can't refresh pie chart on date range change

💬 App Building
4

try using an query json with sql resource type doing something like the following in the

SELECT * FROM {{formatDataAsArray(yourTable.value)}}
WHERE  ((your_date_column_name >= {{ yourDateRangeField.value.start}} and value_date <= {{ yourDateRangeField.value.end}}) OR ({{yourDateRangeField.value.start == ''}} AND {{yourDateRangeField.value.end == ''}}))

And set it to run when inputs change and then use it as the source for the pie chart... this way you won't have to use additional scope

Reply