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.
Discussion posts and replies are publicly visible
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
Hi Stefan Helzle
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
have you tried using query filter on your data(query). And map the date range to query filter?
Hi , Thank you but my question is more on how should we make X axis data points , I do have the data set for the date range.
Hi,
I have a similar functionality to implement, Any Idea how to proceed?