Hi @User_UE94E, We also have no data in the article status column. What are you trying to report on? Below are the steps to generate statistics on Knowledge Articles: The CRM Calendar should be configured in the system for current year. The below processes should be scheduled: Knowledge Content Batch Process (run daily)…

Have you set up the Presentation Variable similar to below? If yes, could you please attach your xml for your report? Thanks Mark

HI @Tyler Buczynski, Can you share the report xml? Thanks Mark

Hi @rrr, Have you tried entering the century as well? The format is set to YYYY-MM-DD so maybe try 2024-06-30?

Does the employee have access to these roles?

Hi @Priya Natesan, If you go into the report and click on Results tab and click on xyz. Then on the pop up tick the Duplicate Values box and click ok, this should resolve the problem.

Hi @Tyler Buczynski I have something that may be something similar to what you require. Please let me know if this is what you are looking for. Thanks Mark Employee Contact Data.txt

Hi @Melissa Hunt, We don't use the Estimated End Date ourselves, but can you send across the xml so I can see if I can replicate the results on our system?

Hi @Melissa Hunt You can find it in the Subject Area highlighted below.

So, the with statement is similar to a cte? I will take a look through the information you have provided, but thank you so much for your advice.

wow, whole new area of OTBI I have never seen before. Thank you, I never knew this existed (although I am not experienced enough to know what I am looking for)! Although when checking the view log I picked up on this snippet:- Measure '# Of Absences' fixed to 'grand total' level in dimension 'Person Work Permit' because of…