XY Chart in Dashboard

Dashboard Digest - Shared Knowledge from all Dashboard Experts

Hello and welcome to the Dashboard Digest. There are so many wonderful digital dashboard related websites (dashboardspy, dashboardinsight, dashboardzone to name a few) including some vendor specific blogs. This website serves to be just a digest for all the dashboard content. If you would like to include your blog as part of this digest please email us a link. (dashboard.kpi"AT"gmail"dot"com).

To create this chart all that is needes is just the X and Y information.

The first column in your SQL should be the X value and the second column should be the Y value. If you are going to have multiple series then the X value is shared axis. The third column represents the second series.

select film_id,count(inventory_id),count(store_id)+3 from inventory
group by film_id

ShareThis