I am working on visualizing survey data and have encountered an issue when using graphs and pivot tables. I keep receiving an error that states I need to include all fields in the well. However, I do not want the Response ID to be included in the calculations or visualizations. The Response ID is currently part of a calculated field, but I need a solution that allows me to exclude it from the calculations without causing errors. How can I resolve this?
Hi Vihang,
It is not necessary to include all fields in your visualizations. However, based on your description you have a calcuated field that is refering tour Response ID in a way that it is necessary for that field to be avaialble in the visual for the calculated field to produce a result.
When you don’t include the field your calculation can not perform.
Can you share what your calculated field is doing and how you are trying to visualuze? We can comment once we have the details.
Hello Girdhar,
Thank you for the quick response. I am using the following calculated field:
count(ResponseId) / countOver(ResponseId, [{Question_ID}])
I would appreciate any suggestions on how to resolve this issue or adjust the calculation so that it works without including the Response ID in the visual.
Thanks again,
Vihang
Hi @Vihang
Can you send me details of the visualizations with the field wells where the error is coming?
I also find your calculation interesting. What are you trying to calculated from a logical point of view?
Regards,
Giri
This calculation is designed to give me a ratio of the count of Response IDs to the count of Response IDs grouped by Question ID. However, when I remove the Response ID from the visual, the calculation doesn’t seem to produce a result.
The ‘Question ID’ column is a pivoted column, which contains multiple unique identifiers for different questions, such as Q1, Q2, Q3, etc. Each of these question IDs corresponds to a set of values that represent the responses given by respondents. The response values, which could be numerical (like 1, 2, 3, 4) or textual (depending on the question), are organized according to the ‘Response ID’. These values are aligned to each respondent’s unique ID to indicate the answer they provided for each question.
Let me know if it is helpful to understand better!
In a graph or table i just want to hide the response id column break down!
Hi,
If you are using a Pivot Visual, you can simply hide the column using hide option available in field wells.
Hi @Vihang,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!