Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have FIELDA and FIELDB and I concatenate them in the script to be FIELDA_FIELDB. I then do a count to see how many occurrences we have of the matching pair of fields count(FIELDA_FIELDB). However, sometimes the same values could be listed as FIELDB_FIELDA. I want to group them together when the 2 fields are the same, regardless of which order they are in. Is there a way to do that?
How do you combine them? May be combine them like this
RangeMaxString(FIELDA, FIELDB) & '_' & RangeMinString(FIELDA, FIELDB) as COMBINED_FIELD
How do you combine them? May be combine them like this
RangeMaxString(FIELDA, FIELDB) & '_' & RangeMinString(FIELDA, FIELDB) as COMBINED_FIELD
I was using FIELDA & '-' & FIELDB as FIELDA_FIELDB
Sunny,
When I add the combined field as a dimension, I am still seeing one option for A_B and one for B_A.
What I am after is a way to combine them here. Any ideas?
Are you really sure you are using Sunny's suggested calculated field and not yours?