3 Replies Latest reply on Apr 29, 2018 11:42 PM by saurabh.c.0

    Query to bring two aggregates from different data sources

    Elie Rahi

      This is something that I've been unable to do for quite a while.

       

      I need to work out the number of visits to a store in a viz comparing 2018 with 2017 - something like a side-by-side bar chart with a bar for 2017 and the other bar for 2018.

       

      The monthly 2017 data is stored in a flat spreadsheet such as Excel. For 2018, the data is in Salesforce where each row denotes a visit.

       

      I've attached two Excel spreadsheets but keep in mind the 2018 visits are in Salesforce.