Skip to Main Content
Liongard Library

Welcome to Liongard Library, where Lions share! This is a community-led space where Liongard users can come to teach and learn from one another.
Share custom Metrics, get inspired and see what’s trending in the Pride.

Pride Etiquette:
➕ Have great custom Metrics? Add them as entries!
🌟 Want to use a Metric? Copy the query and
follow this doc.
👍 Tried a Metric from the Library? Like it!
📣 Have a question or feedback on a Metric? Add a comment!
🔎 Not sure where to start? Learn about Metrics and how to write them.
💬 Need help writing a metric or want to help support others? Join the conversation in our Liongard Lounge #metrics slack channel.


🥴 See something off? Open a support chat to let us know.

Categories KnowBe4
Created by Josh Archibald
Created on Aug 2, 2024

KnowBe4: Participation Percentage Rounded

This metric assumes you have KnowBe4 configured in a progression style where users are not phished unless they receive training. In this metric, it's looking for users in a standard group containing the word "included" versus the users in a group containing both the words "phishing" and "campaign". From there, it measures participation by calculating the percentage between the groups.

To visualize, users are manually in the "included" group. They take training and are automatically placed in the "phishing campaign" group for continual phish testing. If they don't take the first training, they never 'graduate' to being phished, meaning that they aren't participating.

This metrics measures the difference between the groups to identify participation percentage AND it rounds the number properly to the nearest whole number.

Query

percent_of(~.Groups[?to_lower_case(name) | contains(@, 'campaign') && contains(@, 'phishing')] | [0].member_count, ~.Groups[?to_lower_case(name) | contains(@, 'included') && contains(@, 'users')].member_count | [0]) | to_number(slice_string(to_string(@), '-2'))>= `50` && ceil(@) || floor(@)

  • Attach files