I have two data sources joined using the Data Modeler. There’s one field in each source that I want to compare and keep the lowest value. If I were in a spreadsheet, I’d just use a MIN function, but I’m not sure how to do this in Qualtrics.
As a workaround, I’m currently using a custom metric that multiplies the two values. This doesn’t give the minimum directly, but it produces a number that correlates with the lowest value.
For context, both fields have values from 0–3. Multiplying all combinations gives scores of: 0, 1, 2, 3, 4, 6, and 9.
-
A score of 0 means both values were 0
-
Scores of 1, 2, or 3 mean at least one value was 1
-
Scores of 4 or 6 mean at least one value was 2
-
A score of 9 means both values were 3
This approach gives me the information I need for the dashboard, and I can use conditional formatting to color-code the scores back to 0–3. However, dashboard viewers will still see the raw scores (0–9), which is confusing.
Is there a way in Qualtrics to bucket custom metrics into groups, or another method to compare two fields across different data sources and return the minimum value directly?
