PJG Member

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…

Haven't quite got the numbers adding up yet, but I managed to get rid of the Unknown by adding an extra line: WHEN `Adjusted Business Go-Live 1 Date_p` IS NULL AND `Initial Business Go-Live 1 Date_p` <= DATE_SUB(CURDATE(), interval 25 day) then 'On-Time'

I think I see the problem, ignore me for a minute :)

Understood. Any other ideas? Have a chance to look at the file? Is there a quick way to look at the specific projects/dates it's identifying as Unknown, Overdue, etc. And again, thank you so much for your help. Massively appreciated.

Hi Grant, Stared at this for a while. If more than one line is true, is it causing issues? For instance, these can both be true: The adjusted can be </= to 25 days after Initial (On-Time) The adjusted can be > 25 days after today (Overdue) Thanks

Hi Grant, Sorry, you were too fast; I got it working and added an edit above. I'm not exactly sure what the problem was, but I will call it user error :) I tried to strip out the comments too, so this is what got it running for me: CASE WHEN `Actual Business Go-Live 1 Date_p` IS NULL THEN CASE WHEN `Initial Business…

Hi Grant, Happy Monday to you. Back on this today. Understand the commenting method now. Silly me. EDIT: Deleted this, as I think I may be making progress. Further update soon….

Hi Grant, Backticks just don't paste into the forum for me, but I think I have those per screenshot? Though I am a bit confused, your lines 2, 4, 8, 10 don't have backticks either, while others do?

Hi Grant, Thank you so much! First, I should have expressed how I am completely new to Beast Mode, and my coding experience has been almost zero since I graduated college 20+ years ago. I suspect you wanted me to convert a few of these lines into more codey things, but that might be beyond me :) I apologize for the stupid…

Wow, that reply was incredibly fast!!! And it works; thank you so much; I didn't realize it would be that simple!