Chart Data - Aggregate

Chart Data - Aggregate

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

• 

  stevie6410

  • Post Options:
  • Link
    Copy

  Posted 9 September 2017, 8:29 am EST

  Hi,
  
  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?
  
  Regards
  
  Steve Kent
• 

  c1_justinm

  • Post Options:
  • Link
    Copy

  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.
  
  Regards,
  Justin