Question

How to make a bar/line chart component for dynamic filter set

Forum|Forum|3 years ago
November 24, 2022
5 replies
0 views

Hi Folks,

So the scenario is to that we have a case dashboard where we are showing case count over time.

In that screen ,the use case is if we have a date range, from -to date and if we click on filter it should show us the graph along with the cases count between selected date range. How can we make a graph for this , including the X AXIS data points? Like how do we make range displayed as batch for each filter, data wise we are good as we can have data for specific time range,but how to display in graph.

stefanhelzle0001

Brainy

I am not sure I fully understand your idea, but maybe the following recipe fits?

docs.appian.com/.../recipe-filter-the-data-in-a-grid-using-a-chart.html

shikhatAuthor

Hi [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05]

So my use case is that the user will have case creation dates, one start date and one end date field (where end date cannot be future date, of course ) , with no validations as of now. So suppose, the user wants past 1 month data, he will enter the respective date fields and click on filter button , so I should have a bar/line graph showing the past one month's data over time , basically the cases count. My ques is how will we make the dynamic dataset. Trying to do something like below link , but here the datapoints are defined already in the graph , basically categories parameter. How to make this as dynamic because user can enter any date range.

https://docs.appian.com/suite/help/22.2/Line_Chart_Component.html#display-date-and-time-fields-in-a-line-chart

E

eunnelarciee103779

have you tried using query filter on your data(query). And map the date range to query filter?