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

Month filter not working

Stefano_Mazzocca

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?

Find more posts tagged with

FDI

Calculation

Accepted answers

Stefano_Mazzocca

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)

All comments

Bhaskar Konar

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.

Stefano_Mazzocca

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):

Bhaskar Konar

Hi @Stefano_Mazzocca,

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.

Thank you.

Stefano_Mazzocca

The result is the same

What do you mean about the criteria? Since it's standard I can only see this:

Thank you

Bhaskar Konar

Hi @Stefano_Mazzocca,

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.

Thank you.

Stefano_Mazzocca

MATZ_260925_HR_Dashboard_V01.dva

Sure, thank you for the support!

Bhaskar Konar

Hi @Stefano_Mazzocca,

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.

Thank you.

Stefano_Mazzocca

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 :(

Bhaskar Konar

Hi @Stefano_Mazzocca,

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.

Thank you.

Stefano_Mazzocca

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)

Upcoming Event

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…

Top Leaders