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
@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