Super simple for someone other than me. When using database view (or query) of two numerical values I want to show in the SAME pie chart depicting license usage, the gadget actually shows up as two seperate pie charts. Driving me insane. What am I missing?
Statement: SELECT * FROM qryTestOutput: TotalLicences = 12 InUse = 3
Outcome: two pie charts, not showing expected single pie chart made of 12 units of which 3 licenses are consumed