Comparing 2 datasets

MGDOMO
MGDOMO Member
edited January 2023 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.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    I would suggest doing this in Magic ETL. You can use the Join tile and do an Inner Join between the two datasets and join on both Job Title and Description (assuming the data is spelled the same in both datasets). After the join tile, add a formula tile and create a column called variance that subtracts (or divides) the two values.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories