It it possible to add an exsists in custom metric?
Let's say I have col "A", "B", and "C".
In col "C" I want to count +1 when "A" >= 50 or when "B" = Y AND THERE IS NO OTHER VALUE IN "A" GREATER THAN 50.
Is it possible?
Hi @Stefano_Mazzocca,
Can you please try using CASE Statement like following:
CASE WHEN (A > 50 AND B = 'Y') THEN (C + 1) ELSE C END
Hope this help.
Cheers,
Hi @Bhaskar Konar , unfortunately it doesn't help because current metric is:
CASE WHEN
(A >= 50 OR (A < 50 AND B = 'Y'))
THEN
(C + 1)
ELSE
C
END
This produces a +1 for both lines but I want +1 just for the second one since when there is a line with A >= 50 only that one should be counted. In fact the (A < 50 AND B = 'Y') condition should be used only when there is no other line with A >= 50
Can you please validate the requirement and my understanding.
Are you looking for something like below?
Hi @Bhaskar Konar , not really.
I must do the count for every person, my initial image was filtered by just a person for simplicity sake.
One person may have different rows and only one row for each person should have the +1:
Person1 is ok because there is only one row with A >= 50 and B is always N Person2 is ok because every A is < = 50 Person3 has an hybrid situation
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…
Hello Team, In the fusion source, we have the records maintained in multiple language say in english as well as in arabic.. ex: dept name is stored in both english and arabic in oracle fusion source with 2 records with different language code like EN and AR. But the same data in FDI is getting extracted only with the…
Hi Team, can oracle provide a standard decks to have a demo and presentation with new customer? Please share any links or attachments if available. Thanks, Manoj
hello, Is there a way to hide the "back" button in the FDI menu bar? Thank you in advance for your help!
HI, I am trying to get data from the Enterprise Contracts - Contracts subject area in FDI. However, it is not returning any records when I use this subject area. Are there additional configurations or setup tasks needed to pull enterprise contracts data in FDI? I have checked the following: In Oracle fusion, I have access…
