NateBI Contributor

@DanHendriksen Ok I'll have a crack at it and keep you posted thanks!

The task is assigned to individuals as a part of an onboarding workflow. The group method is less appealing, I presssume I would need to create a group, assign new users to the group, asign tasks to the group and track the responses at the individual level (feels like a lot of faff). The function may be the way to go here…

Great news @DanHendriksen. In summary the video could touch on identifying the data structure returned, and identifying the data type required. For example, the SQL query function returns optional outputs a list or rows and then for each feature it could be TEXT, INT, PERSON etc. The conditional input requires the list…

Quick summary of the less intuittive aspects well-explained by Dan: Data types are configurable in the SQL Query per column This is how you assert for a "person" (see user id) The current row object then becomes it's own module so when you select take action see below this then accepts the currentrow.variable rather than…

Hi @DanHendriksen , Yep this is already the case: However, when I select the custom to insert this variable it doesn't give me the option to select the variable: I thought the issue here may be that you've said "a list of variables" i.e data type = list whereas this has text (ABC). However, the same applies for the "Loop…

Thanks @Ashleigh and agreed, it's a shame because (at least to us) in renders the CourseBuilder ineffective.

Hi @DanHendriksen , thanks but not sure where this output is?

Hi @chetan_cricut, No, there is no "Set Column Widths" available with pivot tables to my understanding. A workaround would be to use the General / Allow Text to Wrap option, since this may have a default width configured.

This sounds interesting, thanks @ColemenWilson I'll pm you.

Hi @ColemenWilson thanks, how would adding an education sandbox to another instance look? Why would this be better? I've just watched @Ashleigh 's presentation here: https://www.youtube.com/watch?v=eWRDkXo1AuU Seems like you were able to get indivudal email addresses if you used Google Analytics. I'll have a think and…

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.