My data:
My Calculation - above in the last column you can see it works great:
So why the heck my table goes blank for every value in Month End Date filter?
The solution seems to be adding the Headcount to the chart, which is not optimal since now I need to keep a not required metric (it can be hidden from a table chart but not from a bar chart)
Hi @Stefano_Mazzocca,
It seems the issue may be related to the Month End Date filter rather than the CASE calculation itself.
Looking at the first screenshot, Enterprise Hire Date is available as a row-level value, but Month End Date isn't shown in the table. Since the calculation works when Month End Date is only referenced inside the calculation, but the table returns No Data Found when Month End Date is added as a filter, I'm wondering if the filter is eliminating all rows before the calculation is evaluated.
Could you try adding Month End Date to the table as a regular column (without the calculation) and check what values it actually returns?
If possible, could you also share the formula used to create Month End Date? That might explain why the filter is removing all the rows.
Thank you.
Hi @Bhaskar Konar ,
there is no formula behind the field since it is standard, if I add it as pure column I have the same value for all rows (last day of current month):
Thanks for providing the details.
Can you please check what criteria has been chosen for the Month End Date and also can you please do a range for an year or so like below screenshot and it should return data now.
The result is the same
What do you mean about the criteria? Since it's standard I can only see this:
Thank you
I was trying to check what filter condition you have used for Month End Date (and that has been mentioned as Criteria in my previous post).
Like - if I choose 'Relative Time' - No data is returned. If I choose the Date range I'm getting the data.
If possible, please attach the Catalog file that's not returning data so that can be replicated in our instances to see if there's any quick resolution.
Sure, thank you for the support!
Thanks for sharing!
I had a look and it is returning data in our instance. I would request you to check the filter on Legal Employer whether it has correct value selected or if possible remove the filter and see if it populates data.
Hi @Bhaskar Konar, no actually I can see the same but I see no value when in the "Month End Date" filter I select any date different from current month end date, that's the nonsense I face :(
Yes, agree with you.
Actually 'Month End Date' will always return the End Date of the Current Month. As a result, if the selected date range does not extend to the end of the current month, no rows will be returned.
Hope this help.
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
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
All, I don't see there is a pre built data lieneage which gives more spectrum of solutions or answers for the BI leadership. 1.How many reports each users are owner and what is its path 2.Is these insights are sourced by Subject areas , data sets , Local Subject areas etc 3.Which content duty roles are associated to each…
hi All, The existing FDI pre-built artifacts/Common Subject Areas give us useful information about data reload and warehouse refresh activities. However, I see a gap when troubleshooting Data Augmentation execution at row level. For example, we have a BI Publisher report returning approximately 1M rows, but the…
hello, Is there a way to hide the "back" button in the FDI menu bar? Thank you in advance for your help!
