QV 12 Performance

[cbaqir]

I recently expanded the scope of a dashboard to mock up a lot more detail.  There must be something wrong with my join because I cannot get all the pieces of data to show in one chart.

I added the Orderables table. When nothing is joined, the charts on the Orderables tab in the dashboard works fine. Please help! TIA

Use the bookmark to enable the mocked up data of DESCRIPTION = Comfort Care (Palliative) for the Imminently Dying Patient

[Lisa_P · Accepted solution]

Something is wrong with the key between those tables, there is no matches.
PP_USAGE has 18414 values out of 18451
ORDERABLES has 37 values out of 18451
No values are the same to match the data between these tables