Resolved: Removed the ELSE statement. distinct_total_apples CASE WHEN row = 1 THEN total_applesELSE 0 END

@AndreaHenderson I had missed this feature that's certainly heading in the right direction. I guess the first step would be requiring this field to be selected rather than defaulting to a Many-2-Many selection.

Update here: When I change the variable to a list using the above method. It now disapears in the orginal variable output space:

@AndreaHenderson Let me know your thoughts…

I agree. The previews also prevent important examining of the data during joins. I've created an idea for this too: The Magic ETL needs to include more functionality in the GUI for testing. Alternatively a game-changer would be an option to convert the ETL to a SQL window with boilerplat tests and running as you would see…

I would prefer version control - saving each version and requesting an authorized merge.

See the below idea for a similar issue for joins. I agree the Magic ETL hides really valuable information that supports testing and without experience they're easy to forget - or manually include based on experience and create a huge spaghetti mess - as ETLs become more complex.

@DavidChurchman Yep the detailed view is essentially what I want in the dashboard view. Ok, it's not possible is the consensus I guess. I'll look into different visuals thanks for the recommendations.

@MichelleH Thanks, although I am asking why it has to become this giant bar chart with squeezd labels in the first place but to answer, I agree another visual would paint a clearer picture I'm considering something closer to this: but the original bar chart has the same concept baked in (as would a table) since I just want…

@DanHendriksen The main objective is the same as it was when we spoke. It is to get users to view a coursebuilder card and complete a form for data compliance. However, I made this question post because I found that unless the users has access to the queue (that the form exists within) they cannot complete the form. Now,…

[MAD LAUGHING] It was the cardId variable incorrectly spelt.

Watched this: https://www.youtube.com/watch?v=Qy0aXeJWSlI Testing with original access key but in the headers not bearer token. new error message: { "status": 400, "statusReason": "Bad Request", "message": "The following input values are invalid: [Invalid type: expected NUMBER. (Expected non-null value)]", "toe":…

@DanHendriksen I can't figure out that one. I have tried with user_id and with a list of user_ids and neither provide the var option (this is so jarring). I've built the same concept with pydomo locally and it worked nice and easily. I've looked into adding this code to the code engine as a package but then I'm stuck -once…

While I'm here @jaden.hoenes I'm now looking to access the share content functions (to share a card) and getting a Full authentication is required to access this resource I've seen the authentication documentation and I'm doing this: full_auth = "https://api.domo.com/oauth/token" data = { "grant_type":…

Hi @jaden.hoenes thanks : Yes it's the sendEmail function from Domo notifications version 2.1.6 You're right, it was the params name, I interpreted "any // these should match your function input parameters" from the documentation to mean the names of the variables the .js params get passed to (code engine fuction). Thanks!

@DanHendriksen 1) I've created a "dynamic group" via Admin » Group - I haven't incldued rules since the rules don't apply. 2) I've created a job via Group Management » Admin » The Governance Toolkit - I used the dataset config The dynamic group "rules" don't have an option for new users. And the job feature runs but…

Hi @DanHendriksen - I had to deprioritize it for a week - hopefully get a moment this week to build

@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…