NathanDorsch Member

Ahhh…. got it. Thanks @MichelleH !

Thanks @MichelleH this is exactly what I'm looking for…. but I can't seem to figure out how to set up a dashboard-wide control. I watched the entire video… I created a variable in a card on the dashboard… then when I go to add a control and insert a variable, there are no variables to select from….???

@GrantSmith now I have a request to identify the value following the Capacity (that you determined above). So for example, with "YM103Kl" I'd want to identify "K". Can you help me with that regexp formula? thanks!

Wow @GrantSmith ! Thanks!

thanks @MarkSnodgrass what happens when new rows (values) are pulled in. Do I have to go back in and manually collapse them as well?

@ColemenWilson I finally discovered the issue from Domo support. Within the ETL, I had set up a filter by batch coming in from the input dataset…. not sure why the preview would still show the data, so apparently this is only applied when actually running the ETL. Thanks again for jumping in a call with me the other day!

Thank you @ColemenWilson for willing to jump on a call with me! I scheduled something on Monday - appreciate you offering to help!

thanks for the suggestion @ColemenWilson , but I do have (all) the append rows steps set to "include all columns".

@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.