Performance Analytics:

[Rajesh101]

Hi All. 
I have a question on PA indicator source (Interaction table) build with filter condition to retrive data(sys_created_on) based on fisical calendar(Quarter) and configured to pa_job run daily. Indicator source is mapped with multiple breakdowns on dashboard. 

Once configured with time series widget and published on dashboard where job runs daily ,could see mismatch of data (FYQ2) while comparing with table embedded query(List view) against  dashboard widget . 

Query on XXXXXX  table: 

" sys_created_onONLast Fiscal quarter@javascript:sn_bc.GlideBusinessCalendarUtil.getCalendarStart('Fiscal quarter', '-1', 'Last Fiscal quarter')@javascript:sn_bc.GlideBusinessCalendarUtil.getCalendarEnd('Fiscal quarter', '-1', 'Last Fiscal quarter')" 

To validate data accuracy new  report (same query ) created and compared with indicator source exist on dashbaord , could see data mismatch .

 Can I know what might be reason in difference of data , is this due to breakdown's filter while fetching data during job runs.

Regards, 

Rajesh 

[AndersBGS]

Hi @Rajesh101 ,

As far as I understand your description, there are some mismatch between the records display through PA widget and the same query created through report designer - Is that correct? According to your comment "Indicator source is mapped with multiple breakdowns", notice that no breakdowns is mapped on the indicator source. but instead on the indicator.

What is the difference you see? Can you please share snip of the report conditions and count together with the widget display in analytics hub?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Rajesh101]

Hi Andres , 
Thank You . You are correct breakdown are mapped to automated indicators , Please find the conditions used in report and indicator .

Both report ad widget are displayed in column type.

Report Condition:

All>Created >= 2023-02-04 00:00:00>HR Related = true>XXXX XXX = true>Assigned to is not empty

Calendar:  Fiscal calendar   😕 per: Fiscal Quarter

Count of Records: FY Q2:  15500

Indicator source condition:

Created on This Fiscal Quarter.and. HR Related = true.and Assigned to is not empty

Count of Records: FY Q2:  15650

Even in table list view(By query) I see the difference and matching with report data. 

Could you please suggest me where can I fix or correct. Data which I have tested for FYQ2 and difference of records count observed from report & indicator source.. 

Let me know your suggestions and do provide more information.  
Thanks in advacne. 

[AndersBGS]

Hi @Rajesh101 ,

Thanks for the provided - how is your job configured? 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Rajesh101]

Hi @AndersBGS  
Job is configured to run daily during CST time zone. 

-Raj