About Line chart

Certified Senior Developer

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

Parents Reply
  • 0
    Certified Lead Developer
    in reply to thiliniumesha

    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.

Children