Hi @Mykol Sutton which subject area are you using for this? You can actually use the headcount column and filter it by respective assignment status type along with the month column, it will give you end of the mpnth headcount value. for ex: Filter(Headcount USING Assignment Status Type IN (Active, LOA)) Raghu

Hi @Mykol Sutton is this in FAW or OTBI? Can you provide the name of the subject area and if possible, please archive and post the analysis here? Raghu

Hi @Raesah Kachwala These data reside in two different subject areas Create a report with person number, assignment number, assignment start date, assignment type. Have a filter criteria like below Count(Distinct Assignment Number BY person number) = 1 and Assignment Type = 'P' You can pass this person number obtained in…

Hi, you can use the below formula TIMESTAMPDIFF(SQL_TSI_DAY, <Task Assigned Date> ,CURRENT_DATE) Raghu

Hi @User_0RJUC please post this in OTBI forum https://community.oracle.com/customerconnect/categories/hcm-reporting-and-analytics-for-hcm Raghu

Hi @LipLooi Try the following HCM - Workforce Core -> Worker -> Manager Information -> Manager Name HCM - Workforce Core -> Workforce Headcount Facts -> Facts - Workforce Person Count -> Worker Count Raghu

Hi @User_0RJUC You must post this question in the OTBI forum , link below Raghu

Arpita, you should post this ask in the OTBI forum, link below Raghu

Hi LipLooi, thank you for testing this and reaching out to me. I think you might be missing something here. I created a similar report where a specific requisition has gone through 'suspended' state twice with different intervals. Against the requisition, the cumulative suspended duration value is displayed(the viz on…

Hi @User_2XRUB Can you please illustrate your requirement with an example, screenshot or mock up? Raghu

Hi @Melody Herbert We can plan to enhance the Workforce Core subject area to include this column. Until then you can bring it into the subject area through augmentation. Raghu

Hi @Melody Herbert This requires you to create a custom column in the dv and use it for reporting. You can use the subject area HCM - Workforce Core Raghu

Hi Ruvina, can you share what attributes did you use in the query? If possible, attach the dv output here Raghu

Hi @CAMIL_Q you are right, this column is not exposed in the Workforce Performance - Performance Task Status Real Time. Can you please add this to the idea lab? I can try and add it to the OTBI roadmap Raghu

Hi, glad it's working now, you can continue with the Rank, i was trying to understand the use case Raghu

Hi @MikeW Have you run the diversity feed report to check if that returns all the workers that have updated all the 3 columns? btw, why do you use the Rank function in that? The case that you have mentioned can happen only when the feed report is not rendering the data Raghu

Programmatically there is no way that you can allow only one of the prompts to have values out of the 3. You could alert the customers with a text just below the prompt like below - Raghu

Vaughn, apologies on this post from me last week I believe, details like host, id/pw, SID, and port number of the specific Fusion instance are not available for the customers currently so, i would like change this post as Reviewed instead of already available Thanks Raghu

Geetha, this is same as the following request http://appsconnect.custhelp.com/posts/4ae23d04bf This request has been reviewed by Oracle for future enhancement Thanks Raghu

Andrew, can you please elaboarate on your idea here? do you mean, you need the history information of all the logins into Taleo or OTBI applications? Thanks Raghu