Chart Data - Aggregate

Posted by: stevie6410 on 9 September 2017, 8:29 am EST

  • Posted 9 September 2017, 8:29 am EST


    I am trying to work out the best way of displaying date range information in Lightswitch.

    I have a table of requests and a RequiredDate field. I have created a query in LS query builder to filter the date range I want. Say this month... But I want to see all days of the month, not just the ones where I have a request. So if there are no requests due on the 19-Sep I want it to display 0 rather than leave it out of the chart. What is the best way to acheive this?

    I have created a view with a left outer join to a calendar table in SQL (to supply me with all of the dates in the range) and used it in LS, but this seems really messy and not very flexible. I would prefer to use LINQ in LS if possible. But I do not have much knowldge of LINQ.

    What is the best way to use a date range chart with the C1 chart tool?


    Steve Kent
  • Replied 9 September 2017, 8:29 am EST

    Hello Steve,

    I do not currently see a way in which to do this. I will be working with the development team as I think this is good functionality to have in the extension. I will update this post when I have more information.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels