Unable to use filter in OTBI Column of Maintenance Management Subject Area

Question

Hi!

I am using below formula to filter the WOs Count which are completed when OTBI executes.

FILTER(COUNT(DISTINCT "Work Order"."Work Order Id") USING (("Work Order Status"."Status" = 'Completed') AND ("Work Order"."Actual End Date" = timestampadd(sql_tsi_day,0,CURRENT_DATE))))

But its not showing correct data. Kindly guide.

Thanks.

Nathan CCC · Answer

Hi Umer,

So you will get a count of the distinct work orders that are completed and end is today. Maybe if you post what is your actual result versus what is your expected result. Use the simplest set of data you can. If data security is an issue then change the values to "Apples" and "Oranges".

Looking at your formula to take a wild guess is actual end date a day date YYYYMMDD or a datetime YYYY-MM-DD"T"HH24:MI:SS. If a datetime, it is unlikely any of your work orders end exactly this second on this day so you will get almost no matches? Is that the issue.