PJG Member

Ah, understood. Yes, my output screenshot is just a simplified version of what I need. Adding in my extra columns is working as intended. The issue is just that my output is only giving me the total for some of the Live column, and for none of the Nov 2023 column. Not sure if it's an issue with my Beast Mode, or if it's…

I believe I need the timestamp as there are other RecordType = Historic with different BatchTimestamps. In this case, I only care about the Nov 22, 2023 12:00:00 AM one. Not following what you mean by bottom branch not doing anything… it's needed to add back in some extra columns that I need that were removed with the…

Oops, sorry, I thought I had that in there. Added to my original post.

Hi nmizzell, you were too quick :) I just fixed that piece and edited my post above. I have it running, but there are only 0's in my new total columns (actually, for Live Planned Cost, there are 0's and 1's). Is my Beast Mode wrong? Thanks!

Hi both, Thank you for your replies. I was starting to lean toward the issue being the way the dataset was configured, so I have created a new dataset with an ETL, where I'm using a Group By to SUM the Planned Costs. This ensures there is just one row per project, and after using Arbor's beautifully cleaned up Beast Mode,…

Thank you for pointing me in the right direction, Colemen. Got it working with this:

Sorry, ignore me, I found the culprit; Under Chart Properties > General > Fixed End Date - this was set. I forgot this existed.

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!