topic Re: Set analysis for Dimension in App Development

Set analysis for Dimension

Milaf — Tue, 27 Feb 2024 19:17:49 GMT

Hi everyone,

I couldn't get the metrics with a score of zero to come by team name. The metric with a score of 0 is different for each team, so I thought I prepared the dimension that provides this control correctly. But as it is, it brings no value.

I also tried with only, it didn't work.

=aggr(({<IS_SCORED={'0'}>},[Team Name]),[Metric Name])

Re: Set analysis for Dimension

BrunPierre — Tue, 27 Feb 2024 20:06:47 GMT

Hi, have you already checked "Include zero values" under Data Handling?

Perhaps, something like this as an expression.

=Avg(IS_SCORED) + Avg({1} 0)

Re: Set analysis for Dimension

Milaf — Wed, 28 Feb 2024 10:57:07 GMT

Hello, thanks for the data handling warning. I have activated it but still no metric name is listed. How does the formula you wrote work? I need to list the metrics of the teams coming in condition 0, all fields are as I wrote.

Re: Set analysis for Dimension

BrunPierre — Wed, 28 Feb 2024 17:46:53 GMT

To clarify, does the problem revolve around the Team name not being visible when its value is zero?