Description
Looking at the data on the indicator from analytics hub with time series as "Fiscal Quarterly" shows records from the earlier fiscal quarter, resulting in an incorrect score.
Steps to Reproduce
Reproducible on demonightlynewyork:
1. Generate Fiscal Periods, with regular type:
Start month 11 ( November)
Unit = Quarter
Generate for about 2 years 2018-2020 data.
https://demonightlynewyork.service-now.com/nav_to.do?uri=%2Ffiscal_period_list.do
2. Update the system property: com.snc.pa.fy_start = 11 ( November)
https://demonightlynewyork.service-now.com/nav_to.do?uri=sys_properties.do%3Fsys_id%3Dbca93733d7130100ba986f14ce610334
3. Create a new indicator source: (Example: https://demonightlynewyork.service-now.com/nav_to.do?uri=pa_cubes.do?sys_id=4e5f2d12db994010c28f5223dc96197f )
Frequency = Fiscal quarterly
Facts Table = incident
Condition: Opened on This Fiscal Quarter (Expand Schedule option to find this option)
4. Create a new indicator to use this indicator source from step 3
https://demonightlynewyork.service-now.com/nav_to.do?uri=pa_indicators.do?sys_id=0bbf6d92db994010c28f5223dc961969%26sysparm_view=automated
5. Associate this indicator with a job and run the job for last years fixed schedule: (2018-11-01 to 2019-11-25)
https://demonightlynewyork.service-now.com/nav_to.do?uri=sysauto_pa.do?sys_id=5fff29d2db994010c28f5223dc9619ab
6. Run the job as System Administrator user and observe the date conditions on the logs.
https://demonightlynewyork.service-now.com/nav_to.do?uri=pa_job_logs.do?sys_id=8640b116db994010c28f5223dc961983
Result: Even if there are records for the fiscal quarter the hub shows 0 records.
Expected Result: The date condition should evaluate correctly for "Fiscal quarter schedule" correctly based on system timezone.
Workaround
There is no known workaround for this issue.
Related Problem: PRB1376093
