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 Datto BCDR
Created by Ricky Cobb
Created on Oct 11, 2022

Gradient - Datto BCDR: Agents Count for per agent billed customers

Useful for Gradient billing integration

For 3 customers returns number of agents if customer is billed by agent

Customer Name 1

Customer Name 2

Customer Name 3

For everyone else not billed by agent, returns 0

Query

multiply(to_number((SystemInfo.clientCompanyName == `Customer Name 1` || SystemInfo.clientCompanyName == `Customer Name 2` || SystemInfo.clientCompanyName == `Customer Name 3`) | replace(to_string(@), to_string(`true`), to_string(`1`)) | replace(to_string(@), to_string(`false`), to_string(`0`))),to_number(SystemInfo.agentCount | replace(to_string(@), to_string(`null`), to_string(`0`))))

  • Attach files