Forum Discussion

bottyz's avatar
bottyz
Qrew Trainee
17 hours ago

Counting Instances of String across records for use in a Gauge Chart

Hi all, I want to use a gauge chart the displays the number of records that contain the letter 'R' as part of a string of in a 'Job Number' field, out of the total number of records in the table. ...
formula query
KathyQB1's avatar
KathyQB1
Qrew Member
16 hours ago

To get the count, try changing your query to that below.  You can use the built in CT operator (contains).

var text QUERY = "{6.CT.'" & "R"  & "'}";

bottyz's avatar
bottyz
Qrew Trainee
16 hours ago

Thanks for the suggestion. Its done something, but not what was intended.

Out of 73 total records, its now generating a number over 21,000! Maybe its counting the number of characters in the string now instead?