Parsing Enum values to Strings in Dashboard

Follow

Eric Groves

• September 21, 2015 15:33

So I've got a search like the one below-

_index=app_hudl _sourceHost=p-getpaid* Func=Create AND NewSignUpFlow | count by role

where role returns an int between 0-4, which is an enum. But, for displaying on a dashboard, it would be more meaningful if instead of 1 we showed admin for example. I saw that this could be done with a lookup operator and a CSV file.

Although, for what would be a small CSV file like this (4 rows), can it be done inline without having to call a HTTPS server to snag the CSV?

0

• 

  Mario Sanchez

  • September 21, 2015 16:50

  Eric,
  Since it's a small set, a simple way to do it is with a few IF statements:
  ...
  | if(role = 1, "Admin", role) as role
  | if(role = 2, "Poweruser", role) as role
  | if(role = 3, "Analyst", role) as role ....
  ....
  | count by role

  0

  Comment actions Permalink

Please sign in to leave a comment.