PJG Member

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.

Hi @Ashleigh Thanks for the reply. I haven't delved into ETL at all yet, so probably a lot of learning for me there, but I did just manage to get the code working with my entire invert code within my score code. Something I couldn't get to work yesterday, but probably just user error! :) I see ETL being referenced a lot,…

Hi @GrantSmith yes, zoom is a good way to describe it. I'm surprised this isn't a feature, as I thought it would be a common requirement. To show a 2024 Portfolio for instance. Thanks for the reply anyhow.

Hi @Ashleigh thank you for the reply. Can you point me to any Domo documentation or videos on doing this? Thank you so much.

Hi all, thank you so much for taking the time to respond to me. Sorry for the delay in getting back to this topic, but this is not my primary responsibility, and I am always getting pulled in many different directions. For that reason also, an ELI5 is always very much appreciated, as this is not my main area of expertise.…

First option worked, thank you so much!

Oh, I see you added a screenshot. Let me try that, thanks!

Hi Colemen, Thanks. Could you be more specific as to how to find this? The closest I've seen is under Governance > Groups > Default Overview Content, but the problem is that: This only seems to be changing what they see in Overview, rather than opening a specific Dashboard This only allows me to point to a Card, and not to…

@GrantSmith Thank you Grant, just saw your reply also, and that might be exactly what I'm looking for.

Hi @MichelleH, that might actually be optimal, because I do have to add about ~200 users, so it looks like I could use the Bulk Import here. I will test with an individual user first. @Ashleigh thank you also. I will have to check on that too (if Default automatically gets new users added to it). I am still learning the…

Hi @GrantSmith that's not an option unfortunately, and doesn't fit with our processes or how we need to use the system.

Hi @ST_-Superman-_ , thanks for the reply. I'm a bit confused by your question, but I'm 100% sure that's due to my own lack of knowledge :) Apologies if I don't provide exactly what you're asking for. The data is one record = one project. Each project has 9 initial and 9 actual go-live dates as attributes, so it would be…

Hi Michelle, Thanks for the response. That's incredibly disappointing, as I know we can have vertical scroll bars on other card types; tables for instance. EDIT: I do see that the Gantt chart gets a scroll bar when the expand button is clicked, but not directly on the dashboard unfortunately.

I got this working!!! Oh my gosh, what a joy and relief! :) I learned so many things, including how to properly test a line at a time. Turns out that my problems with the initial code that you shared were actually the commented rows. It requires two dashes, but this forum turned one of your dashes into something that…