Expand my Community achievements bar.

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

Avatar

Level 1

8/10/23

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 Comments

Avatar

Level 9

8/21/23

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. 

Avatar

Level 10

8/30/23

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.