dashboard are not showing all values for variables

Products

• DX OI SaaS

Issue/Introduction

Most of the dashboards are showing the issue where the dropdown is not showing all the items that it should be showing. It is also random where some time it shows some items in the list and other items other items. Experiencing an issue with the DX dashboards, where the data is present and the variable logic appears to be accurate; however, not all qualified variables items are visible in the dashboards. The visibility of these variables items seems inconsistent, as they sometimes appear and at other times do not. 

 

Resolution

Optimized queries to retrieve all unique application names, removed unnecessary aggregations, increased limits, and synchronized variables.