Skip to content

How can i set aliases for @EventType on dashboard? #1306

Answered by nblumhardt
XaspMe asked this question in Help
Discussion options

You must be logged in to vote

Hi! It's a bit clunky, but this should work :-)

select count(*) as col0
from stream
where @eventtype = 0xCB325EAA or @eventtype = 0x0969c1fd or @eventtype = 0x071d713a
group by
  if @eventtype = 0xCB325EAA then 'first' else if @eventtype = 0x0969c1fd then 'second' else 'third' as eventtype,
  time(15m)
limit 10000

Let me know if this helps,
Nick

Replies: 1 comment

Comment options

You must be logged in to vote
0 replies
Answer selected by XaspMe
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Help
Labels
None yet
2 participants