n8isjack Contributor 
-
Re: Joining One-to-Many relationship datasets
First you need a clean id to join on. I don't know if those are typos under your [Object UID] field or not, but it would need to have all non-numeric characters removed. Then you can join the two tab…1 -
Re: Week over Week Metrics - Multiple Stores to Show
I would start with a Sumo Card, using the pivot settings. Stores in the row categories. Date in the column categories (with a date grain of weekly) Sales in the values section1 -
Re: Magic Replace Text REGex, remove anything outside of delimiters
You could possibly do it in one step: REGEX: ^.*\|(.*)\|.*$ REPLACE: $1 The trick is to make sure your pattern matches the ENTIRE string. Use parenthesis to capture the part you want to keep and when…1 -
Re: Only Show Unique Entries in Text Field
Yes you can, but if you are showing a lot of columns it could be difficult. If any single column is aggregated then the others will only show unique values. To test it simple just add two columns suc…1 -
Re: Google Analytics session data showing improperly
Sure! When I say 'simplify' I mean pick as few "Dimensions" as possible. Here is a screenshot of the selected dimensions for a Google Analytics connector: Google Analytics Connector There a…2
