EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB11683: How to create a metric which counts only a single key of a compound key attribute


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This article explains how to create a metric which counts only a single key of a compound key attribute

In order to create a metric that counts only a single key of a compound key attribute complete the following steps:
 
Validate the formula and save the metric
 

  • Create an attribute with a compound key
     
  • In the metric editor, drag the attribute to the metric definition
     
  • Consider the following: if the attribute you created is made of the keys "ID" and "ID1", and you would like to consider only the first key, the following formula should be used: "count(distinct attribute@ID)"
     
  • On the metric definition, right click on "Count", and select "Count Parameters" as shown in the image below:
     
ka02R000000kbp5QAA_0EM440000002Fj5.gif
  • A new window called "Count Parameters" opens and should look like the image below. Change the Distinct parameter to True and click Ok

     
ka02R000000kbp5QAA_0EM440000002Fj7.gif

Comment

0 comments

Details

Knowledge Article

Published:

June 8, 2017

Last Updated:

June 8, 2017