I have a query that generates a standard tabular report, and I'd like to chart that same data where the first column holds the x values and each other column holds a new series of y values.
select sale_dt, item_count, sale from sales where . . . Day Items Sale -------------------- Sun 15 $ 122 Mon 11 $ 95 Tue 6 $ 63 Wed 18 $ 158 Thu 13 $ 104 Fri 8 $ 92 Sat 17 $ 147
The day of the week is the x-axis and there are two lines: Items and Sale. Assume that each column will use the same y-axis scale. Is there a way to chart this easily?
To create this type of chart I have been rewriting the query to select each series separately and combine them using unions.
select 'Items', sale_dt, item_count from sales where . . . union select 'Sale', sale_dt, sale from sales where . . .
Is there a way to avoid this?