Qrew LegendThis is an older (pre formula query post), but for those coming across this thread, this is how you can achieve this today...
See this post for references in the video: https://www.quickbasejunkie.com/blog/how-to-cumulative-charts
I am getting this error:
using this summary formula on a line chart:
var text QUERY = "{56.EX.'XXXX'}AND{101.EX.'XXXX'}AND{278.EX.'XXXX'}AND{299.EX.'0'}AND{351.EX.'XXXX'}AND{352.EX.'XXXX'}AND{85.GTE.'1'}AND{85.LTE.'12'}";
SumValues(GetRecords($QUERY),363)
What am I doing wrong?
Fields 56, 101, 278, 351, and 352 are text fields and the 'XXXX's replace specific text values for filtering. Field 299 is a checkbox field. Field 85 is a numeric field and I want records with values from 1 to 12. The sum field, 363, is a numeric field.
Qrew LegendTry tjhis
SumValues(
GetFieldValues(
GetRecords($QUERY),
