Checked why the foot traffic and stock snapshot report has no value on the generated file, as per checking, the foot traffic is extracting data from the MySQL table, checked the data in the table, as per checking the latest data is January 2021 only. Checked why the stock snapshot has no value, as per checking, the where condition in the query did not change into a brand field, modified the query and tested, as per checking, there are data generated now. Deployed the changes into the test environment, for checking on sir Mark's side.