NathanDorsch Member

@GrantSmith @MarkSnodgrass This is what I'm trying to do. The chart will show the last 12 complete months and the value for the prior year's month to that? I don't want to see the current month on the right side. For right now, I'd want to see September 2022 listed on the far left side of the chart (with September 2022 as…

@MarkSnodgrass I did somethign similar where I created a "difference month" BM - PERIOD_DIFF(date_format(EVENT_DATE,'%Y%m'),date_format(now(),'%Y%m')) I filtered to include data < 0. The problem is then I see this… where it'll show September (from last year) twice - both on the left and right.

Thanks @MarkSnodgrass I should have clarified… The main issue I'm running into is trying to eliminate the currently (incomplete) month. Is there a way to pull the last 12 complete months? So right now, I'd want to see the first column on the left be September ending in August. Below is what I see with the basic bar line…

thanks @marcel_luthi I'll take a look at this.

@colemenwilson two issues: 1) some of the IDs will be associated with upwards of several hundred IDs. 2) there will be new IDs added and new ID associations (with other IDs). I'm familiar with the split column function, but would need a dynamic way of splitting up the columns and then associating them.

@colemenwilson I'm not sure I've properly explained what I'm attempting to do here… Each row is a unique ID - so there aren't any duplicate IDs. What I am attempting to do is create an overall last modification date for each ID (based on it's last mod date and the last mod dates of the IDs it is associated with). So for…

Thanks @colemenwilson, but I'm not sure I follow. I can rank the IDs by their last modification date (see new columns: "Date Rank"), but I'm still left with the same issue. Can you elaborate more on how I can use the date rank column? ID name last modification date Date Rank associated IDs Latest date associated Notes 1…

Thanks @MarkSnodgrass and @DavidChurchman I'm thinking the null values must somehow be impacting this. I should be able to address this with a BM that combines them and replaces nulls with a value.

can you use wildcards in an In statement? =when SESSION_MEDIUM in ('%Email%','%email%') or SESSION_SOURCE in ('%Email%','%email%') then 'Email'

I combined the second ETL into the top one. Still doesn't work. I submitted a ticket and received this response: "I checked the ETL in question and there are 2 output datasets in the ETL with 2 different ETL processes. An ETL tile can only output one output dataset. To fix this issue, I suggest creating a separate ETL for…

That's what I've been trying to no avail. When I click save and run (or just save), that's the message I get.

After looking at this further, I do normally have the run option on ETLs (I am an admin), but for this one, I don't. And think the reason might be because it's still in draft mode… perhaps? If you look at my screenshot above, you'll notice it says "Draft" and I'm wondering if that is preventing me from running it from…

I don't see an option to run. Only view tags, create copy, or delete.

How do I get to the "ETL overview page"? Do you mean the overview page for the output dataset?

I was signed in. I think the issue was I had some colors for fields (from prior dataset of the card) that were still in there and preventing me from saving.

No and it just happened again to me!!!

@GrantSmith I got all the transformations to run. However, when I look at the resulting dataset, it doesn't have the data pivoted like I wanted… it looks the same as the input dataset. My whole objective is to convert a concatenated value of Retailer-Field-Strategic Priority-Target set up as columns - and just one row of…

that worked! But now the 4th one is still failing:

Actually, it looks like I'm having issues with the third step:

Thanks @GrantSmith I'm having issues with the 4th step: Call Pivot(); I get an invalid error message: Procedure dataflow_schema.Pivot does not exist

Well you can check my availability here. If you or anyone can schedule a quick call with me to walk me through this, I'd be very grateful. Or if someone knows the person who wrote this article on how do this and can point me to him/her: Thank you.

@MichelleH I ended up taking it in many different directions and honestly can't tell you what is happening, I just keep getting errors saying "whoops, something went wrong" or other things… It'd probably be a lot easier if I can just walk you through it and hoepfully you'll discover what I'm doing wrong pretty quickly.

Would you possibly be willing to jump on a call with me?

Thanks. I did end up switching over to using the Table transform. Still having issues though…

Just bumping this…. can anyone help me? maybe @GrantSmith Thanks.

Could somone possibly jump on a call to walk me through this? I feel like this is something that should probably only take a few mins for someone who knows what they're doing. But it take me hours of headaches until I give up…

I found this article which provides essentially the same solution and walks me how to do this via mysql. I've never used mysql in here before though… and the directions are a bit confusing to me. Can you advise what I'm supposed to do? I first created an output dataset which reduces the columns down to just two columns:…

solid. Thanks man.

thanks. How will that handle double spaces? Will it count a double or triple (etc.) space as a single space?

When they hover over the value in the legend, I want it to show the percentage - not the count. How do I do that?