I have a dashboard for my project with multi teams. So, I’m trying to use FACET CASES to create conditions to apply filters on entire dashboard.
My query is:
SELECT count(groupedRequestUrl) FROM AjaxRequest
WHERE appName = 'my-app' AND requestUrl LIKE '%mydomain.com%'
SINCE 3 hour ago
FACET CASES(
WHERE groupedRequestUrl RLIKE r'.*conditionA*' AS 'Team A',
WHERE groupedRequestUrl RLIKE r'.*conditionB*' AS 'Team B')
OR groupedRequestUrl
And I’ve marked Filter current dashboard
. This query show me a table like that:
Cases | Total |
---|---|
Team A | 1 |
Team B | 2 |
- When I click on table row to apply filter, it broken my dashboard and shows
Ops! Something wrong!
. It’s a bug? - If I put an
AS 'groupedRequestUrl'
at the end of FACET CASES, the applied filter isgroupedRequestUrl = 'Team A'
, but no results. - If I remove
AS 'Team A'
on CASE, the applied filter isgroupedRequestUrl = 'groupedRequestUrl RLIKE ...'
, but no results. - If I remove
AS 'groupedRequestUrl'
in the end of FACET, it broken my dashboard again.
How can I group urls and filter like I want?
– EDIT
The problem is on OR requestGroupUrl
after FACET CASES.