Starting from 9.3.0 String Function can be used in Derived Metrics

Starting from 9.3.0 String Function can be used in Metrics;

1. Create a Max (Attribute-1) as ‘Derived_metric-1’

2. Create a Max (Attribute-2) as ‘Derived_metric-2’

3. Create a third metric as ‘Concat(Derived_metric-1, Derived_metric-2)

4. Place it in the report……it works (verified in desktop)

 

Additional Tip: similarly, you can create count (attribute) on the fly (as derived metric) – Cool…..

About Senthilraj

DW BI Architect and BI Project Management (Specialized in MicroStrategy). Hobbies/Passion about photography, tennis, music, travel-trekking. Website: www.b-diamonds.com www.facebook.com/SENRAJ81 www.linkedin.com/in/senraj


Notice: compact(): Undefined variable: limits in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Warning: count(): Parameter must be an array or an object that implements Countable in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 399

One thought on “Starting from 9.3.0 String Function can be used in Derived Metrics

  1. Pingback: Linkedin

Comments are closed.