GrantSmith Coach

@MarkSnodgrass beat me to it :) I’d recommend his. Those are some good articles he posted haha.

Hi @Alex_us There's a "p"ublic API (not officially supported by Domo, can change at any time, use at your own risk) that will get you a list of all of your embeded cards or dashboards - you can even filter based on the name. You can inspect your browser's network traffic to see which endpoint Domo is accessing and…

Currently there isn't a way to do it with embedded dashboards to have the filters persist across sessions. It's not currently possible in Domo proper. Programmatic filtering would be the closest you could get. My javascript/web development is limited but you might be able to track their filter options in the iframe and…

I love that idea @RobynLinden!

So this isn't easily possible however you could implement a mysql data flow using some creative hackery using variables. I was able to write up an example using your sample data you had provided to get the results you expected. SELECT `Dept`,`Value`, COALESCE(`Value`, IF(`tbl`.`Dept`=@pred, @prev+@offset,…

Hi @User_32265 You could use a contains filter instead of selecting a value from the list. Alternatively you could have your dataset list each record with the different tag for each record making sure to handle any possible duplicate records in your card processing.

@Ashleigh is correct. Here's an ETL2.0 example TRIM(`Column`, 'CHARACTER TO STRIP') If you leave off the second parameter it'll strip spaces by default. Magic 1.0 example:

Hi @Jessica Looking at the color rules it appears that it's using the same 6-color palette as the post you linked. There is a difference if you're using the diverging colors as those have 5 or 9 colors. I went through and pulled all the hex codes for them: Here's a copyable list: #FCCF84 #FBAD56 #FB8D34 #E45621 #A43724…

Hi @MB_Dem If Grade and Passing Grade are columns does your beast mode use single quotes or back tickets? With the way you have it now it's comparing the string 'Grade' with the string 'Passing Grade' which will always equal Incomplete (P comes after G so Grade is never greater than Passing Grade). Try this (it's expanded…

Hi @Ajeet_Mahajan Did that solve your problem? If so can you accept the answer so it's easier for others to find the solution in the future? Thanks!

No, you can run your script without supplying a dataset ID and it'll create a new one automatically for you. After you run the script the first time then you can get the dataset ID and use it in your script so it doesn't create a new dataset every time your script runs.

Hi @LoveBindal Have you looked into Window functions? You can do it in either an ETL using the Rank and Window tile (https://domohelp.domo.com/hc/en-us/articles/360042922814-Magic-ETL-Tiles-Rank-and-Window) or you can use window functions within beast modes. Specifically utilizing LAG and LEAD will allow you to get the N…

Hi @swap700 When you browse to a specific dataset's overview page (Data -> Search for the dataset) when you look at the URL of the page it'll look something like this: https://customer.domo.com/datasources/[DATASET_ID]/details/overview That is where you can get the dataset ID for your dataset in your Domo instance when…

Hi @swagner I've taken a stab at it to help simplify the code a bit and make sure your spaces are correct and closing brackets are aligned. CONCAT('<a href=''https://customer.domo.com/page/#########/kpis/details/##########?pfilters=[{"column":"branch","dataSourceId":"DatasetID","dataType":"string","operand":"Operand…

You might have some line breaks in your string causing issues. We can try and pass in the 'm' modifier flag to treat it as a multiline string: REGEXP_REPLACE(`note`, '^.*(W\d{15}).*$', '$1', 'm')

What values are you attempting to filter on? Are you using the correct column name?

Hi @rwalsh25 If you're wanting to keep the original text and split work order number into a new column you'd need to split your dataset, pull just the key fields and the note field, then use the regex and then join the data back together using your key fields. If you're using ETL 1.0 If you're using ETL 2.0 you can just…

pydomo is the supported Python SDK for interacting with your Domo instance. You can use it to upload datasets. There are several examples which they show you how to perform different operations. You can find the documentation at https://github.com/domoinc/domo-python-sdk

Hi @RichardC My guess is that when the email is being automatically sent its just sending the URL as text and not a link itself. When you're forwarding the email your mail client then helpfully makes the URL into a link which Domo can then find. There isn't a simple way to fix this unless you can get the email to send an…

Hi @melyeo I was playing around with this today and noticed that there's a bug with Domo's code where it's expecting you to provide additional columns besides just the single column. To get around this issue I just created a new transform where I added a new static string column: SELECT `value`, 'HACK' as v2 FROM ... Then…

@bp_paulo_fernandes Are there other columns you can utilize in your join to restrict the number of rows being returned? Right now you have a one to many join happening which is causing the number of rows to skyrocket which it sounds like isn't intended. What columns define each row? Can you put all of those as your join…

Hi @sunny How is it not working? What have you tried? Are you able to log into the sample login page with mike as the user? Did you start up the yarn server to connect to? There's a lot of moving pieces with programmatic filters. It'd be helpful to know what you tried and what the outcome of it was.

Hi @user046467 Are you filtering for 'include' values or excluding 'exclude' values? If you're checking for only include values anything prior to 2021-07-01 won't be found because you don't have an else clause to mark it as include (it's returning NULL). How do you want this to behave for records prior to 2021-07-01?…

@user04105 I'm working with too many different SQL version, so sorry! It should be DATEDIFF not DATE_DIFF. Domo has some issues processing with the coalesce inside and not populating the date correctly. This modified version does the same and sets the difference to 0 if it's the first date in the partition.…

You'll need to examine your join conditions. It sounds like your join isn't restrictive enough and it's generating multiple rows. Are there additional columns you can filter on? Are you able to filter your dataset before your join to only include the records you need?

Hi @user041053 You'll need to utilize a window function and a date diff function to calculate the difference between the two dates. DATE_DIFF(`Date`, COALESCE(LAG(`Date`) OVER (ORDER BY `Date`)),`Date`)) DATE_DIFF is calculating the number of days between the two dates LAG(`Date`) OVER (ORDER BY `Date`) gets the Date value…

A few trouble shooting questions: 1 - Does the dataset exist in Domo? 2 - Have you tried the Windows fix? (turning it off an on again / restarting the workbench server)?

Hi @swap700 You might try looking into the new Dataset Views to append/union your datasets together. You can also use it to rename columns. https://domohelp.domo.com/hc/en-us/articles/360046074774-DataSet-Views The data needs to be of similar types. My question is what are you trying to solve by getting these IDs in the…

Hi @tobypenn You can utilize a window function in a beast mode to get the last date for a week and then compare it to the activity date and filter when they're the same CASE WHEN `Activity Date` = MAX(MAX(`Activity Date`)) OVER (PARTITION BY YEARWEEK(`Activity Date`)) THEN 1 ELSE 0 END YEARWEEK returns the year and week in…

Hi @OllieSouthgateAKA My assumption here is that when Domo is processing your data the underlying architecture / platform they're using to process the data doesn't respect row ordering when performing a rank operation. This is typically the case with Big Data solutions because it's faster to read your large data set in…