But on my 1st graph, I'm having trouble.
Take a Customer file of 500 records.
You want to see a simple chart (bar/column) of Sales (RO = Repair Orders in these examples) to determine the top 10-20 customers - you certainly can't see ALL Customers because there'd be too many bars.
Even if it was just "Sales for this month", it could be too many bars. So the time frame isn't the issue (meaning a simple WHERE clause for just this month won't solve this).
If Aware, here's what I can do (which doesn't work because there's no facilities in the charting config to sort/limit the data):
Code: Select all
FIND RO WHERE RO.DateCreated BETWEEN '1/1/2019' and '3/31/2019'
Code: Select all
SELECT top(10) CustName, SUM(RO.ro_grandntotal_nodisc)
FROM RO
WHERE RO.DateCreated BETWEEN '1/1/2019' and '3/31/2019'
GROUP BY CustName
ORDER BY SUM(RO.ro_grandntotal_nodisc) DESC
Aware's chart mechanism offers only the Aggregating portion. And thats why this simple chart can't be done (at least by the Aware users who wish to stay "native aware").
So I ask the group: How can I get this simple chart done?
thx