+3Hello,
I have 3 text-type metrics with the same dimensions, and I would like to combine these 3 metrics into a single text-type metric.
In this new metric, I would like to add a category dimension to be assigned to each of the values from the original metrics.
Please let me know if I'm not clear enough!!
Thank you for your help :)
A basic example below :
Best answer by Issam Moalla
Hi
A possible way to apply this is by Applying the same logic but referring the unique text property in the Target metric:
'Metric 1 (D)'.Name[BY: Category."Metric 1"]and using the Item function in your formula to convert back to the dimension of your metric:
item('Metric 1 (D)'.Name[BY: Category."Metric 1"]
&
'Metric 2 (D)'.Name[BY: Category."Metric 2"]
&
'Metric 3 (D)'.Name[BY: Category."Metric 3"], ID100)Where :
However, keep in mind that each source metric (Metric 1, 2 and 3) must have the same dimension and the text property that you are using must be the unique property.
Hope this answers your request,
Issam
+11Hi
To combine the three metrics, you would need to create a new metric with an additional dimension Category.
The Merge text formula will collect the text from each metric and attribute it to the corresponding Category item:
'Metric 1'[BY: Category."Metric 1"]
&
'Metric 2'[BY: Category."Metric 2"]
&
'Metric 3'[BY: Category."Metric 3"]where:
Hope this helps,
Issam
+3Hi
Thank you, this is exactly what I was looking for.
This leads me to another question, somewhat similar.
If I wanted to do exactly the same thing but instead of text metrics, these were dimension metrics. What would be the equivalent of "&" for concatenation ?
Thank you for your help :)
+11Hi
A possible way to apply this is by Applying the same logic but referring the unique text property in the Target metric:
'Metric 1 (D)'.Name[BY: Category."Metric 1"]and using the Item function in your formula to convert back to the dimension of your metric:
item('Metric 1 (D)'.Name[BY: Category."Metric 1"]
&
'Metric 2 (D)'.Name[BY: Category."Metric 2"]
&
'Metric 3 (D)'.Name[BY: Category."Metric 3"], ID100)Where :
However, keep in mind that each source metric (Metric 1, 2 and 3) must have the same dimension and the text property that you are using must be the unique property.
Hope this answers your request,
Issam
+3Hi
Thank you for your previous responses. I still have the same case, except that this time I want to do it for a "Boolean" type metric. However, when I try to apply the same concatenation logic with "&", it turns the boolean into text. Do you have any solutions to suggest on this matter?
Thank you in advance for your help.
Have a good day
+11Hi
When it comes to the booleans, you need to apply logical operators: AND/OR and your target metric needs to have a boolean data type.
Since you are looking to merge them by adding each metric to a category the OR would be the correct operator where at least one condition is met.
Hope this answers your question,
Issam
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.