JasonAltenburg Coach

Complete :)

Can't wait, sounds amazing!

Absolutely agree this is needed from an administrative/governance standpoint. De-provisioning power users carries risk without admin visibility to the developer.domo.com tokens.

I like money AND badges. I like using the Dojo to find answers to Workbench, ETL, and Card building questions. Please LOL my responses and posts whenever you see them. Thanks.

Yes Yes I think it was created in an older version of workbench, and we've just been nursing it along. Another user has the job and they can update this dataset through the older (pre 5) workbench still. It's bizarre to me that the new workbench doesn't "see" this particular dataset.

I just wanted to say that I think this is a fantastic idea and happened upon this post today after wanting something similar.

I agree with @ST_-Superman-_ on all of these great points. I would add that whiteboarding sessions are invaluable tools to creating cards that your team feels more invested in. As far as best practices, in our organization we have a templated card description that allows anyone looking at any card to understand what they…

I think you are missing a comma in the DATE_ADD statement. Try changing DATE_ADD(CURRENT_DATE()interval 3 days) to: DATE_ADD(CURRENT_DATE(), interval 3 days) Also I'm not sure why you have so many case/end statements? I use the following block of code for date buckets, and it works fine else-chaining without the Else/Case…

@jaeW_at_Onyx thank you much for this video and for the great explanation on why you would prefer not to do this via ETL. How do I get the lead/lag functions? When I attempt to call them via beast mode I'm getting 'Invalid Formula : This calculation is using a nonexistent function.' Thank you,

@WHM THANK YOU! This was a HUGE help for me today!!!

Hi AnnK, This is a great Idea! I looked for other ideas in the Ideas Exchange regarding the Activity Log having dimension/measure specific data and came up empty handed. I'd suggest posting it over in the Ideas Exchange so that it can be properly voted on. https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas **Say "Thanks"…

Have you tried utilizing the Line+nested bar chart type? In this example I've created a simple beast mode for an average of my values for A1, A2, and A3 divided by 3 and plugged that into the Y Axis dimension. (`A1`+`A2`+`A3`)/3 **Say "Thanks" by clicking the heart in the post that helped you. **Please mark the post that…

Hello Judit, Is there a reason why you would need to do the case statement for only the January month? I would think you would want to create the beast mode for the Service Level, and then another beast mode for the Month/Year. Then you would end up with an average that displays along side the month label. This offers the…

Hi, interesting stuff! I'm struggling to understand the use case for this. If I wanted to have a table card with links to another card with filters for category already applied, would I use this? I downloaded the excel file, plugged in what I think are the appropriate values, and attempted to hit refresh all, but I get an…

Hi CKing, I think that this post over in the ideas exchange is the same feature you are describing/requesting. https://dojo.domo.com/t5/Ideas-Exchange/Add-tags-in-DOMO-Stats-report/idi-p/37806#M6937 I'd suggest adding a kudo to the post to show your support for the addition of these fields to the Domo Activity Log (which…

I think you would be better off doing the SQL step, but I think it is possible in ETL as follows. I utilized the tables from the cross join example on w3resource here After adding these tables using excel upload to function as inputs, I used add constant to the company table of an ITEM_UNIT column containing string 'Pcs',…

I think you would be better off doing the SQL step, but I think it is possible in ETL as follows. I utilized the tables from the cross join example on w3resource here After adding these tables using excel upload to function as inputs, I used add constant to the company table of an ITEM_UNIT column containing string 'Pcs',…

I think you would be better off doing the SQL step, but I think it is possible in ETL as follows. I utilized the tables from the cross join example on w3resource here After adding these tables using excel upload to function as inputs, I used add constant to the company table of an ITEM_UNIT column containing string 'Pcs',…

I think you would be better off doing the SQL step, but I think it is possible in ETL as follows. I utilized the tables from the cross join example on w3resource here After adding these tables using excel upload to function as inputs, I used add constant to the company table of an ITEM_UNIT column containing string 'Pcs',…

I think you would be better off doing the SQL step, but I think it is possible in ETL as follows. I utilized the tables from the cross join example on w3resource here After adding these tables using excel upload to function as inputs, I used add constant to the company table of an ITEM_UNIT column containing string 'Pcs',…

I strongly believe it was shortening the name of the input table and the name of the column with sentences in it for step 2 of the SQL transforms down to <10 characters or so, all lowercase. I also added a magic ETL step prior to this where I stripped out null and blank values from the sentences column. (Filter for…

I did find this! What I did was added the LOWER() function to the text field as my first step in the SQL dataflow. UPDATE table_name SET sentences = LOWER(sentences)

Wow what a journey that was to get it working... I ensured that blank and null values were stripped in my dataflow. I then shortened my table names, in reality my table name was closer to 40 characters and my column name was 22 characters. I shortened these down to about 10 characters each through renaming/data flows. In…

Datamaven, I'm trying to work with this today (it must be in the air). I'm having trouble with step 2. When I copy/paste and modify the code as directed from call_transform_2.sql I'm getting an error. here's my code: #Word Cloud V2 #Example: CALL word_cloud('sample_word_cloud_nolan', '`Sentence`' , 'y','y' ); CALL…

You would need to combine the INSTR,SUBSTRING, and LENGTH functions to do this in a beast mode. With that being said, I STRONGLY ADVISE AGAINST DOING THIS IN A BEAST MODE. But you asked if it was possible... and it is... but it causes what seems to be A LOT of validation time on my 4 line dataset consisting of the…