Comparing 2 datasets

MGDOMO
MGDOMO ⚪️
edited January 4 in Charting

Hi there,

I am new to DOMO and I am trying to find a way to combine two datasets with same column names. I would like to calculate the variance between current pay vs industry pay and be able to sort it by job title and location (DMA). I have tried ETL, Join and Segment for the baseline but none of these methods work for me. The current data comes from ADP connector and the industry pay data comes from an Excel file at the moment. In the future the Excel file will be updated on a monthly bases a saved on a FSPT folder which I will need to connect to my card.

Please advise.