Want to split results based on a field value

[leandrot]

Hi all,

We have a field which represets de Offices, and we would like to make 2 different line charts separating between Domestic offices and International offices.

As Example we have:

Domestic offices: PHX, LAX, LGA
International offices: BUE, LIM, MEX

How can we filter the results to dispaly on each graphic the corresponding offices ?

Thanks in advance

[TISKAR]

@leandrot , Can you try this please:

<yourSearch> |eval TypeOffice=if(Offices="PHX" OR Offices="LAX" OR Offices="LGA","Domestic offices","International offices") | chart count over Offices by TypeOffice