PJG Member

I do have both filters in Analyzer and on a slicer card, but if I set up the exact same filters in the source system directly, I have Start Dates that range from 01-Mar-2020 to 01Aug-2024 and End Dates that range from 31-Dec-2023 to 30-Jun-2027. In Domo, no matter what I do, I can't seem to get it to show 2024 and beyond.

Hi nmizzel - thanks for the quick reply. Here's a very simple example of the input and the desired output The issue is that I cannot see Project4 in the Output, but I suspect it's being removed at the Split action, since it has no Div values set. Thanks

I have this working after adding a few extra steps, and please feel free to let me know if there was a better way to do this I added the Group By action where I added my code from my OP to group the 19 values into just 5. Then in the Add Formula action, I added the following: CONCAT(`ProjectName`,`Div Grouping`) This…

I think I have finally succeeded with an extra step! I added the Join Data tile, but this added ALL the input dataset rows back in, so I then added a tile for Remove Duplicates, and it works! Thank you SO MUCH - easily the highlight of my week so far!

The columns already exist in the input dataset with data in them. I just need them in the Output dataset also; no changes to them. I did refresh the data. I can't add them in the "Add Formula" tile, as they're not available to select there; I assume I'm only seeing what is produced by "Group By" Thanks!

Hi all, Thank you all so much for your help here for an ETL newbie like me. Just today, I have been given full access to ETL, so I am following the first solution from @ArborRose. I have built it exactly as described and when looking at the Output, it is giving me the result I expect! - thank you! I do have one follow up,…

Hi Arbor & Michelle, Thank you both for the replies. The issue was a little strange. Even though the card was quite wide horizontally, which you'd think would give it enough space to show the labels on the Y axis, the issue was actually that I had to add more vertical height to the card to make the labels show. Not ideal,…

Hi Arbor, thanks for the reply and really appreciate you taking the time to explain that step by step. Unfortunately, I don't have access to run things in ETL at the moment; something I'm working on resolving.

In magic ETL, I have the following flow: Input Dataset > Split Column > Group By > Unpivot > Output Dataset Where I'm struggling is Group By, and I'm not sure I have these configured correctly: Select what columns identify the grouping = Is this my new columns 1 through 19 from the split? Name a new aggregated column =…

Within ETL, I have a banner stating "The DataFlow feature for Magic ETL is not activated. Please contact support to enable this". I assume this is referring to the company providing us our Domo instance and who are in charge of our datasets?

Hi Coleman, thank you for the assistance. I'll take a look at the link. Here is some example data with the pipe delimiter. Impacted Business Division_p Biologics - example1|Biologics - example2|Biologics - example3|Biologics - example4|Biologics - example5|Biologics - example6|Biologics - example7|Biologics - example8…

Hi Colemen, I've never used ETL yet - can you point me to a good guide/video that would be what I need to achieve this? Thanks

Hi @DashboardDude Sorry for taking a month+ to get back to you - been pulled in many different directions since. Is this useful at all? My On-Budget code is: case when ForecastCost < PlannedCost * 1.01 AND ForecastCost - PlannedCost > 20000 then 'Over Budget' when ForecastCost > PlannedCost * 1.01 AND ForecastCost -…

Hi @ColemenWilson, thank you for the reply. Should I be concerned about using Append because this is already by far our largest dataset, at 210,000 rows, 181 columns, and the data gets updated very frequently.

Just a quick follow up to this in case anyone else experiences this issue. No I have not found a perfect solution. Making the card bigger, or moving the Legend to the bottom had no impact. The best option is to move the Legend to the Left or Right. That's the only way I've found to solve the vanishing legend entries, but…

Hi @MichelleH perfect, thank you!

Any chance these are on the development roadmap yet? Thanks!

Okay, thanks for all your help. I have a meeting with them on Friday.

Thanks - started watching & following, but ran into a problem already; one of the datasets I need is type = domo-federateddata, which seems to not be compatible with ETL. Another question for the dev? Maybe it can be converted to type = Microsoft SQL Server?

I've never used or learned about Magic ETL, but it sounds like it allows you to use attributes from two different datasets? That sounds like a solution

Update: I took another look at the dataset. It seems if a project has no Financial Category set, the project does not appear in the dataset at all. Not sure if there's a workaround, or if I just need to contact the software dev, as they manage my datasets

Thanks, Mark. I've used this elsewhere, but couldn't get it to work here. Thinking about it a bit more, I think it's because the PlannedCost is not just a plain attribute. It lives within a particular module of our software where the user first has to select between 1 & 9 FinancialCategoryName (Internal Resource, External…

Well, I learned that just in time! :) About to have our first launch. Thanks so much!

@GrantSmith Very simple, very clever. That works, thanks!

Hi MichelleH, yes, true. I think I explained that badly, apologies, as I don't really have any original field labels to use. Essentially I have code to group costs into ranges, so my Beast Mode includes rows such as: 0-100 100-500 500-1000 1000-10000 The problem is that while they should sort as per above, the 500-1000 is…

The table from my screenshot includes the record name also, but I can't show that here. A record appears as many times as there are Phase changes. It's incredibly rare (<1% of the time) that a project would have more than one transition from A0 to A3, but if it does, I would like them all included in the calculation.

Hi Grant, is this helpful? Just note the header labels are a little different from my code earlier which was more of a mockup, but the two Phases I'm interested in here are the ones starting A0 and A3, and I need to know the average number of days between the dates they were set for all records that have had both set (or…

Hi @GrantSmith , thank you for your help as always. I am not following why I need to include MAX, but perhaps I left out a key piece of information in my previous post. I need the total number of days between these phase change dates for all records, and I would then set the Aggregation to be the Average. It's the Average…

Perfect, thank you!

Hi @ColemenWilson & @Ashleigh I must admit, I didn't realize Filter Cards were so simple, and I implemented my first ones today. Thank you so much for pointing me in the right direction.