-
Re: Resources for the more code-y parts of setting up a dataflow (MySQL/RegEx/JSON)
Google is definitely your friend here, and there is no shortage of information on the web. That said, here's what I've used. GA: https://ga-dev-tools.appspot.com/query-explorer/ This is a f…5 -
Re: Custom Sorting Using a Field (Specifically Sales Funnel)
Whenever this happens to me I force-sort the values using a beast mode to override the default alphabetical sort. Do something like: CASE WHEN `stage_name` = 'Bullpen' THEN 1 WHEN `stage_na…5 -
Re: Counting codes across multiple fields and re-labeling the codes
Welcome! What I'd do is bring your data into a Magic ETL dataflow and put it through the Collapse Columns transform to restructure it: Rec Value A 05 A 10 B 12 B 00 B 19 Then in the card you can…4 -
Re: Data Permissions - Restrict Access to Underlying Data
In the drill path you can click on the box "Prevent drilling to final data grid view". Would that help?4 -
Re: Beastmode - Duration (mins) between 2 Datetime Columns
The TIMEDIFF() function will get you the hh:mm:ss value between the two, and the TIME_TO_SEC() function will give you the number of seconds in time. Nest those two and divide by 60 seconds to get min…4
