Cloud graph of calculated field displays wrong result

[Fotis_flex]

Hi ,

I am getting a strange result in a cloud visual I create from a calculated field. The calculated field is:
ifelse(isNull({Departure Airport City}) OR isNull({Arrival Airport City}), 'None', concat({Departure Airport City}, ' - ', {Arrival Airport City}))

It creates a combination of the departure and arrival airport name when none of the two are Null. Afterwards, when I put the field in a cloud visual I get the below graph highlighter with “Other”. I try to filter the graph to remove this value but I can’t. I can’t figure out how is this value produced at first place as the fields I use do not contain the value Other. Anyone has an idea?

[ErikG]

Hi @Fotis_flex
the visual only excepts a fix number of elements, rest is grouped as “others”

You can try if 500 (max value) will be help.

BR

[Fotis_flex]

Arghh… No that won’t do, I tried many but “Other” is still there. I just don’t get where this “Other” value come from…

[ErikG]

As i said, if your cityPairs has more then 500 different values all values over the 500 will go into the “other” group.