Hello everyone,
I’m building a survey for people in which I combined (coalesce) fields together, since we are asking similar questions at 2 moments on the survey. The way it’s built, respondents will answer either one or the other of the 2 questions assessing the same thing.
I already coalesced questions together into new fields. However, in the dashboard, I would like to show global scores for all coalesced fields from a dimension (e.g. a score for Satisfaction with activities which would be the average of Coalesce1, Coalesce2, and Coalesce 3, which are all combinations of questions on satisfaction with activities).
I thought combining the coalesced fields together with the formula function would work, but I don’t see my coalesced fields in the field selection.
Have any of you ever done something similar? I would appreciate guidance on this.
Thank you!