Skip to main content

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?

Hi ​@Bryan Bauer,

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)CREMOVE FIRSTNONBLANK: DimC]

Thank you, ​@oliverlee! This is exactly what I needed and works great!

This has been resolved.

Reply


Ask your question here!

Terms & ConditionsCookie settings