I have a metric that includes three dimensions—DimA, DimB, and DimC—along with a corresponding dollar amount for each intersection. I’d like to create a new metric where DimA and DimB remain as dimensions, but DimC becomes the result instead of a dimension for each of the intersections in the first metric. In doing this, I also want to drop the numeric data type and just have it as a dimension data type What would be the best way to achieve this in Pigment?
Solved
Changing Data Types of a Metics and Removing the Current Value
+1- Apprentice Helper
Best answer by Bryan Bauer
Thank you,
+12- Master Helper
Hi
I think the easiest way would be to use an IFDEFINED statement to return DimC element if your source metric has a value, and then remove your DimC dimension afterwards.
IFDEFINED(SourceMetric, DimC)[REMOVE FIRSTNONBLANK: DimC]
+1- Apprentice Helper
- Answer
Thank you,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.