Can someone please assist me how to add multiple items in charts.
Table for leaddocs
SELECT
ID,
LeadID,
Type,
Date,
reference,
Document
FROM leaddocs
I am using a stacked graph item to capture the number of documents processed on a daily basis and then want to add stacked items within the chart to show the type of document captured based on a filter variable depending on the "type" of document captured which is a lookup field . I am able to created 2 seperate graphs;
- Total documents captured
- Total Invoices captured
I would like to show both with the same graph but not sure how to add a filer item in the querry and at the same time show the total documents captured.
Not sure if this makes sence. The Invoice is captured by the type field in leaddocs
Query for "Processed Invoices"
SELECT
Date AS Process Date,
COUNT(Type) AS COUNT(Type)
FROM leaddocs
WHERE (Type = 'Timeout Invoice')
GROUP BY Date
ORDER BY Date DESC