Skip to main content
Share Your Experience: Take the 2024 Developer Survey
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' ...
mickmackusa's user avatar
  • 4,801
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"...
mickmackusa's user avatar
  • 4,801

Only top scored, non community-wiki answers of a minimum length are eligible