Hello, I am new to DOMO and I am learning it as I work on this project.
I am trying to combine two datasets to calculate monthly supplier performance: qty rejected divided by qty received. I have dataset A, qty rejected, with tons of data. I did some calculations and was able to chart the defects of each supplier by month, see below chart. Each color represents one supplier
I have dataset B, with monthly qty received per supplier, see below chart
Prior to grouping the data from dataset A into months, I tried to combine the two datasets using the magic ETL and Blend (DataFusion), but was not able to. Any tips?