Add a counter for the number of characters of a dimension value | Community
Skip to main content
A
as18400340
New Participant
August 10, 2023
New

Add a counter for the number of characters of a dimension value

  • August 10, 2023
  • 2 replies
  • 642 views

Description -

Why is this feature important to you -

For checking the value length of a dimension, the calculated metric is needed, so we can create certain alerts when the value exceeds the established length.

E.x. when a dimension contains a two letter country code, we want to get all the country codes exceeding the established length 

 

How would you like the feature to work -

Count the length of a dimension value

 

Current Behaviour: none

    2 replies

    RobertBlakeley
    RobertBlakeley
    New Participant
    August 30, 2023

    I typically do this by downloading the values into excel or report builder and use an excel function. However, that does not get you the alert.

    J
    jdonley
    New Participant
    August 21, 2023

    Interesting idea.

     

    Shorter term workaround: Create a classification for char count. CRB doesn't have capability to count, but writing a server-side ETL script to do the classification is low LoE. 

    Terms & ConditionsAccessibility statement

    Loading footer...