Metric Set Formula Grouping By

#1

Is there a way to “group by having” with a formula on a metric set? I would like to use data cube warehouse on a complex table of data. Each row would have multiple filterable slicers but then I want the resulting formula visualization to display the result as a grouped by result having a value < 0.

#2

I figured it out, just create a formula visualization from a metric set on a dashboard and apply the filter parameters to it. The formula I used was:

if(SUM($table9.Metric Set 1.Payment$,$table9.Metric Set 1.Id$) < 0)
return SUM($table9.Metric Set 1.Payment$,$table9.Metric Set 1.Id$);
else
return 0;

3 Likes