GrantSmith Coach

one addition to @MarkSnodgrass answer is to wrap it in a case statements to handle the situation where you don’t have any send email activities (your denominator is 0)

Because how workbench is designed it reads from the same local database so anyone with access to the server can see the different jobs. If you want to keep the two users separate you’d need two separate sever instances for workbench

You may be able to utilize the API to determine which type of page it is but it wouldn’t be a supported API and is a very technical solution. It would be nice if the governance or domostats datasets contained the page type

If you can’t use the connectors append update method I have utilized the DataSet Copy connector to take daily snapshots of a dataset and set that method to append. https://domohelp.domo.com/hc/en-us/articles/360043436533-DataSet-Copy-DataSet-Connector

Support@domo.com is one way. You should be able to click the question icon in the upper right to to to the knowledge base and then select support in the upper right but like you I’ve had issues in the past attempting to log into the support site. Try the email.

change your logic a bit so that you’re adding your different sums together since you want to add all the sums together based on your filters . SUM(CASE WHEN test = 1 THEN forecast ELSE 0 END) + SUM(DISTINCT CASE WHEN test = 2 THEN forecast ELSE 0 END) + SUM(DISTINCT CASE WHEN test = 3 THEN forecast ELSE 0 END) Sorry for…

@MarkSnodgrass apparently I can’t stay away…Can’t let you catch up :)

Have you confirmed that the file names are included in your dataset or not? What specifically does your date field represent?

Sounds like an issue with the connector. You might want to reach out to Domo support. They typically will have additional logs to help diagnose your specific error you’re getting

Hi @Jbrorby It sounds like you’re doing a recursive dataflow. The null check is for making sure only new records are being pulled in to avoid duplicates. I’d look at your timing on when the underlying daily dataset and when you’re pulling that data to see if it’s a possibility that when you’re pulling the API data that…

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