When joining two tables transactions values are missing in Dashboards

Products

• DX SaaS
• DX Operational Observability

Issue/Introduction

We noticed that when when joining two tables , some data appear to be missing . 

Environment

DX O2

Cause

Our limit today for dashboard / elastic is 10K

Enhancement request DE649737 has been created to extend current limit to 65K

Resolution

WORKAROUND: Redefine the query so record size is smaller

Additional Information

DX O2 Techdocs - Create Dashboard