I have 2 chart widgets that I am trying to automatically filter and load based on a 3rd grid widget.
The grid has a date filter to show a set of transactions for a date.
Chart 1 shows a bar chart by hour showing number of transactions per hour.
Chart 2 shows a column chart by day showing number of transaction per day for the month based on the date filter in the grid.
I have logic in a button program and in the filter programs for each widget to update the filter values in the other widgets.
I can update the filter values using app variables. But how can I automatically apply the filter once the filter values are set?
Tried 'refresh' and the grid is refreshing, but the underlying data is not getting required.
Part of the issue, I believe, is that the data source is refreshed in the filter program based on the filters. So just executing a 'refresh' in Valence is not reloading the data source.
Associated question: The filters are on date fields and are using 'from' and 'to' values (a 'between' filter). I set both the 'from' and 'to' values but I only see either the 'from' value or the 'to' value getting set.
In one Chart I see the 'from' date get set, in the other chart I see the 'To' value get set. And it is consistent. Chart 1 always only shows the 'To' value and chart 2 always only shows the 'From' value.
Again, thanks for your attention.
Paul
The grid has a date filter to show a set of transactions for a date.
Chart 1 shows a bar chart by hour showing number of transactions per hour.
Chart 2 shows a column chart by day showing number of transaction per day for the month based on the date filter in the grid.
I have logic in a button program and in the filter programs for each widget to update the filter values in the other widgets.
I can update the filter values using app variables. But how can I automatically apply the filter once the filter values are set?
Tried 'refresh' and the grid is refreshing, but the underlying data is not getting required.
Part of the issue, I believe, is that the data source is refreshed in the filter program based on the filters. So just executing a 'refresh' in Valence is not reloading the data source.
Associated question: The filters are on date fields and are using 'from' and 'to' values (a 'between' filter). I set both the 'from' and 'to' values but I only see either the 'from' value or the 'to' value getting set.
In one Chart I see the 'from' date get set, in the other chart I see the 'To' value get set. And it is consistent. Chart 1 always only shows the 'To' value and chart 2 always only shows the 'From' value.
Again, thanks for your attention.
Paul
Comment