-
MySQL mapping fields to columns
I have a MySQL dataflow that contains all the metrics for our sales reps (new customers, pipeline, leads, etc.) from 8 different sources. I need to remove all the sales reps who are inactive/terminated, and I already have this field (Roster Status) available in one of the data sources (the Roster data). How can I remove…
-
beast mode within a beast mode
Hello, I'm creating a card based upon the changes in tenure buckets of our sales reps. I am using start date and "As of" date (or the date we import the roster data. "As of" would be today's date, for instance). From there, I want to bucket it into different ranges like "0-6 months," 1-2 years," and so on. Another piece of…
-
How to change/reroute specific values in a field and leave all others the same
I have a table card. It shows the amount of deals closed by each sales team. In some cases, sales reps change industry teams. I want to be able to say "If sales manager = Joe Smith, then change team to Retail" but since there are 100 managers, I don't want to go thru and put each one in since the rest of the mappings…
-
Days Since Last Instance
I need to build a beast mode that gives me the days since the last time a sales rep transacted. My dataset includes several transactions by the same rep but I only want one line per sales rep and however many days it has been since their most recent sale. Does anyone have experience with this? --I've built a beast mode to…
