MattRK

Discussions

Creating "Other" group in a chart
How do I write a beast mode that will group a large collection of small values into an "Other" group (Say any with a sum of values under 200) without specifying the members of that group? Edit: I should mention that these would be sums of multiple values. Meaning multiple rows per day but the sum is still <200 in the time…
Fun with string functions
I do a lot of string functions to look at URLs. If I want to use a SUBSTRING and INSTR Function what's the best way to move the end a dynamic number of characters? EXAMPLE: I want to show the string after the 1st '=' and before 'the_end' in the 'big_string' field. I wrote:…

Creating "Other" group in a chart
How do I write a beast mode that will group a large collection of small values into an "Other" group (Say any with a sum of values under 200) without specifying the members of that group? Edit: I should mention that these would be sums of multiple values. Meaning multiple rows per day but the sum is still <200 in the time…
Fun with string functions
I do a lot of string functions to look at URLs. If I want to use a SUBSTRING and INSTR Function what's the best way to move the end a dynamic number of characters? EXAMPLE: I want to show the string after the 1st '=' and before 'the_end' in the 'big_string' field. I wrote:…