The store order is different each time Store Authorization KPI is executed. What could be the reason?

The store order is different each time Store Authorization KPI is executed. What could be the reason?

This is true in case of SQL KPIs If a manual KPI is created/generated using SQL then, the store does not come in order. There are certain other limitations in SQL KPI apart from this. As a workaround, we suggest you to publish this as an auto KPI.