nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

What's wrong with this Key Metric?

Stefano_Mazzocca

I tried both versions

Find more posts tagged with

Fusion AI Data Platform

Accepted answers

Benjamin Arnulf-Oracle

I believe Key metrics expressions must be measures.

Your current formula is resulting in a row-level calculation, not an aggregated value.

To fix it, you might need to wrap the formula in aggregation function like SUM().

Try:

SUM(CASE WHEN CAST(PER_ASG_PERCENTUALE_INCARICO_ AS INT) > 0 THEN 1 ELSE 0 END)

All comments

Benjamin Arnulf-Oracle

The formula should be:

CASE WHEN condition THEN expression ELSE expression END

Stefano_Mazzocca

Hi @Benjamin Arnulf-Oracle , unfortunately it seems not :(

Benjamin Arnulf-Oracle

I believe Key metrics expressions must be measures.

Your current formula is resulting in a row-level calculation, not an aggregated value.

To fix it, you might need to wrap the formula in aggregation function like SUM().

Try:

SUM(CASE WHEN CAST(PER_ASG_PERCENTUALE_INCARICO_ AS INT) > 0 THEN 1 ELSE 0 END)

Upcoming Event

AI Data Platform - Creating High Code Agents and Using Developer Tools in AI Data Platform
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…

Top Leaders

GTA 50