Combine similar items from 2 fields in 1 chart - possible?
Hi All,
I have come across one very simple looking obstacle i can't seem to be able to get over on my own.
I have 2 fields in my raw data that contain the same values (Root Cause 1 and Root Cause 2) - and i just need to have one bar chart which should show the total count of each root cause from both fields. And i am not sure if i can use set analysis because root cause names can change over time.
