NateBI Member

Update:

Hi @DavidChurchman and @ST_-Superman-_ Following @MarkSnodgrass's video - creates a many-to-many relationship for me. Constants on every day joining constants on every day. It's similar to what I have but I had added a constant 'dummy_person' against every calendar day, then left joined on the dates which should have been…

@ST_-Superman-_ This sounds similar to @DavidChurchman 's suggestion - which is looking promising. The issue I have with this is that it requires the filter context of the week to display the nulls/blanks. So when placed in the values section of the pivot options it aligns with the summed hours but once brought into the…

Hi @jessdoe to clarify it's not for users to see the last refresh date but thanks! @GrantSmith this sounds perfect, thank you!

Hi Folks, Having the same problem using this code: CASE WHEN Client = 'CLIENT_NAME' THEN CONCAT(' <img src="','[SHAREPOINT_LINK','" style="width:128px;height:128px"> </>') END Is this because I'm using Sharepoint to host the image? If so where is a better place to host images for Domo? All support is appreciated, Kind…

Hi @Marianne , Check the post here if you haven't already: https://community-forums.domo.com/main/discussion/44731/can-the-user-with-default-social-security-roles-see-the-shared-cards/p1 Why don't you want to use the PDP feature? I doubt there's a way to restrict views without using PDP in Domo and the response to that…

Update: Workaround for this is to overlay the conditional field. To do this, I inputted the main line metric as the output of the condition CASE WHEN [insert logic] THEN [Main Metric] ELSE NULL Not pretty but closer to the look & feel I want.

Hi Folks, Has this feature been added since? Would be a solid option to have.

Totally Agree! A fundamental feature for any editing tool

@colemenwilson Sweet, spoken with @GrantSmith and he suggested: step one: cumulative sum to calculate the group ID step_two: rank partitioned by step_one field Which landed this here: I then run a lead over step_two to get the previous value and where previous_value_step_two = step_two then then 0 else step_two.…

@colemenwilson The order field is working fine, it's based on the date. It's the Rank field that wasn't set up correctly to match the dummy table I sent in the first question. So now, I'm going back a stage to replicate the rank field - if possible - to support the final stage - your solution - of running a lead over each…

@MichelleH @colemenwilson Issue Update: My rank field is not skipping nulls or restarting the count - this is impacting the logic you've sent. Here are the settings:

@MichelleH thank you, this would be plan B since it would only highlight 8 and above but I need them all to be labeled. @colemenwilson I figured that someone would enjoy it! 😆 This looks right, I'll keep it in Reedshift - in Magic ETL that's 7 R&W tiles, plus Join tiles, per scenario and I have another two to sort like…

@GrantSmith Version: 3.10.5 Full error message: 00:00:02.282 Traceback (most recent call last): 00:00:02.282 Traceback (most recent call last): 00:00:02.282 File "<stdin>", line 40, in <module> 00:00:02.282 File "/home/domo/domomagic/io.py", line 48, in write_dataframe 00:00:02.282 write_array_dict(d) 00:00:02.283 File…

@MichelleH very interesting thanks!

@MichelleH Sweet - any chance this can be linked to a filter visual instead?

@MichelleH Thank you, this workaround would have been the second go-to but @rco this worked for me. Thanks, both!

@MichelleH Yeah, this is in a Group By tile but with the formula column feature

@MichelleH it's a Syntax Error: I've also tried DISTINCT LISTAGG(Resource_Name, ' / ')

Hi @MichelleH this seems to throw an error for me.

Hi @ArborRose & @GrantSmith ok thank you

@MichelleH & @Airbear Thanks I'll have a go with these workarounds

@MarkSnodgrass a solid workaround: 1) Join the table once 2) Join the same table again 3) 'Fix' all dupe named columns to the right/left - this auto generates the prefix as we know 4) Remove the first join The 2nd join widget keeps all the prefix columns. Hope this helps for the time being folks!

@Domomon Yep I've added this as an idea here, give it a vote if you still want! https://dojo.domo.com/main/discussion/57659/option-to-add-prefix-in-magic-etl-joins/p1?new=1

Done!

Hi @MichelleH That's solved it, superb! thank you.

Hi @RobSomers thank you for this -- this concept worked I just adapted it to filter out the Blues but keep NULLs with : IFNULL(`status`<>'Blue',TRUE) Thanks!

Perfect, thanks @MichelleH

Update: The configuration tab solves this.

Hi @GrantSmith , ok that's a shame but thank you!