Skip to main content
Question

SecOps Dashboard: Display Analysts with Zero Active Cases

  • Nov 18, 2026 6:01 PM UTC
  • 2 replies
  • 25 views

gopinath_n

I’m trying to build a Google SecOps dashboard widget to display the active case count per analyst.

Currently, the query returns only analysts who have at least one active case. However, I would like to provide a predefined list of case assignee names as input to the query and include all those analysts in the results, even if they have no active cases.

For analysts with no active cases, the widget should display a count of 0 instead of excluding them from the results.

Is there a way to achieve this in Google SecOps Dashboard?

2 replies

MitchellR
Forum|alt.badge.img+3
  • Bronze 1
  • Nov 18, 2026 7:31 PM UTC

Hi ​@gopinath_n - 

Yes, you can achieve this. Here are a few examples:

  1. If using YL2 syntax in your dashboards, you can define each analyst as an outcome variable (assuming the number of analysts suffices within the limits for your use case): 
  2. If you have SQL available to you in dashboards (it’s still a preview feature), you can then do the join necessary to keep your analysts in a data table that could be referenced: 

    The data table is very basic in my example here, simply one string column of analyst names, though you could also do the same syntax with an `UNNEST([‘array’, ‘of’, ‘stuff’, ‘here’])` if you don’t want a data table. 

Let me know if this helps / meets what you’re looking for. Cheers! 


cmorris
Staff
Forum|alt.badge.img+17
  • Staff
  • Nov 18, 2026 8:04 PM UTC

I have used this query:

stage analysts {
%analyst_list.name != ""
$analyst = strings.to_lower(%analyst_list.name)
match:
$analyst
}

stage open_cases {
case.status = "OPENED"
$assignee = strings.to_lower(if(case.assignee.given_name != "", case.assignee.given_name, case.assignee.name))
$assignee != ""
match:
$assignee
outcome:
$active_cases = count_distinct(case.response_platform_info.response_platform_id)
}

$analyst = $analysts.analyst
left join $analysts.analyst = $open_cases.assignee

match:
$analyst

outcome:
$active_case_count = max(if($open_cases.active_cases > 0, $open_cases.active_cases, 0))

order:
$active_case_count desc

 

With a basic data table called analyst_llist with a name column that contains my analyst’s names. Email would work here too.

 

Results: