Show Product Quantity and Sales
I'm trying to create a chart that shows the individual product sales.
I'm using the standard "orderdetails" table with eCart.
I've tried:
X Label "DetailItemID" group by value
Y Label "DetailPrice" calculation SUM
which shows a chart with the productID.
I tried selecting "show multiple datasets from column" but the chart says "undefined"
How do I get the product name instead of the ID?
Thanks