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

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

  • August 10, 2023
  • 2 replies
  • 647 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

Level 8
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. 

RobertBlakeley
Community Advisor
Community Advisor
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.