1 Reply Latest reply on Aug 21, 2018 6:01 AM by Okechukwu Ossai

    How to sum from a data source using date ranges from another data source

    Trevor Hungerford

      I have an issue where I need to show the total distance travelled by machines between two dates.

       

      The view below is the data from one table in a datasource and there is another datasource with all the machine distance information in it.

       

      Basically, I want to sum up the machine distance between the two dates and show the sum in the same row as the two dates.

       

      Any help would be appreciated.