Hi Ajay, Did this work for you?

emp_mgr.zip Hi Ajay, Could you add this column and check if it indicates the record which matches the manager on the UI - "Worker"."Primary Assignment Flag" Attaching a sample report i created.

Could you please share the XML of the report you have created.

Hi Ajay, Even after applying the filter the inactive records are coming? Is that the case?

Hi Ajay, Is there any active manager flag? I do not have access to a Fusion HCM instance, so unable to check for myself.

Hi Dawn, Were you able to make it work?

Hi Dawn, It should work, i have tried it, and, was able to see data for all the GROUPs. Do let me know if you need any additional inputs. Best Regards, Amrita.

Hi Ajay, Could you please share the xml from the analysis you have created so far.

Hi Dawn, Directly using the calculated GROUP column to segregate the data in the pie chart did not work for me either. I figured out a work around. Attached is the steps for it, along with the sample reports. It is a bit complicated for a simple requirement, but, this is the only way i could make it work. Will let you…

Hi Ravi, Few clarifications related to your query - * The 2 data sets, even though related, you do not want to combine in a single view? * The only reason you want to combine both queries in a single report is so it can be downloaded as a single excel with 2 tabs. Is that right?

Hi Ajay, Could you please share the xml of the report. Also, could you trying setting the format for the date column and then re-running the report. To set format go to - Column Properties -> Data Format -> select a date format based on what value you are passing to it -> Save as Default -> the below highlighted option.

Hi Dawn, Your query is not very clear. In the data you have shared i see 5 groups alone. Is this the column you are referring to?

Hi Ajay, Yes, it needs to be applied in the column formulae itself. Good to know your issue is resolved. Regards, Amrita.

Hi Ajay, Try applying the a MAX() function on all the attributes apart from the employee number. Regards, Amrita.

Hi, Could one of you please share the report, either the XML, or archive the report and share.

You should then create an analysis and a dashboard prompt separately. The dashboard prompt should have default values set. Then place the analysis and prompt on a dashboard. When you run the dashboard, the analysis will automatically filtered to the default prompt value.

Could you change the case when as below. The report renders at my end, without any errors. However, does not return data(we do not have workforce enabled). The quotation around 25, is not needed, since the comparison is carried out with a numeric column. CASE WHEN ("Absence Calendar"."Absence Days"/100) > 25 THEN 'SHOW'…

@Joshua C. Stewart, We have not been able to test it out as yet. It got pushed back due to some other priority tasks. Once i am able test it out, will let you know.

Agree with Michal completely. This has been my experience as well.

Hi Sahithi, As far as I am aware, this is not feasible. In Data Actions we do not have the option to set the type of filter operation in the parameters being passed. The way we do it in classic is through presentation variables, or, through a filter report. Neither of those options are available in DV currently.…