1
vote
Accepted
PieChart For RSForm for PlotaLot based on a dropdown field
Add a HAVING clause that pre-qualifies aggregrate data in your derived table. The following condition will require that a submission contains a Part No value of 5.
HAVING COUNT(FieldName = 'Part No' ...
- 4,826
1
vote
Accepted
RSFORM combine 2 submission form results in one Plotalot view
I think the simplest way forward is to use a JOIN to relate your first query to your second query. An INNER JOIN (same as JOIN) will only generate rows in the result set where both "derived"...
- 4,826
Only top scored, non community-wiki answers of a minimum length are eligible