Hi I have data type which have data with site id, site name, workingstartDate, workingendDate. I want to create line chart which is for each day of month, nu of sites worked?
how can i do that?
Discussion posts and replies are publicly visible
Is your question about how to do that in general, or about how to implement it in Appian?
In appian
Yeah ... I assumed that the target of your development is Appian.
Are you looking for a way to solve this problem in principle, or do you already know how to do it but need tips on how to implement it specifically in Appian?
If you already have something, do you mind sharing your ideas?
need tips on how to implement it specifically in Appian
OK. Then, what is your principle solution and what are you stuck with?
I tried to get the dates between starting date and end date using enumerate. But with that getting number of site is difficult. I want to know how to do get number of sites for each days
That is what I wanted to know. I had a quick chat with ChatGPT to get a first idea how to attack that problem.
I am not sure whether we can do this kind of aggregation directly from Appian. So I would try to first develop a SQL statement that fits my needs, and then either create a view or a stored procedure to query the data from Appian. Keep in mind that you might run into performance issues without proper database optimization.
I will try that. Thank you very much