GrantSmith Coach

@MarkSnodgrass is getting too quick! As he said it's mostly for display purposes but it's also useful for helping to classify the type of dataset it is or where it came from - from a metadata aspect. If you only have SQL server then there really isn't much of a difference but can be helpful if you're using multiple…

Hi @Domofied If you have Magic ETL 2.0 you can use the regex_replace function to pass in processing flags - this isn't possible with the ETL 1.0 Replace Text tile. By default regex101 as the g (global) and m (multiline) flags enabled whereas Domo does not. Passing in the 'm' as the third parameter should resolve your…

Hi @User_32265 Domo provides a connector called Domo Dimensions (https://domohelp.domo.com/hc/en-us/articles/360042931454-Domo-Dimensions-Connector). There's a list of files in there that you can select for some predefined datasets, one being a calendar (calendar.csv). You'll use the connector to pull in that specific…

@Salmas Its a bit difficult to help diagnose your issue without understanding what the current counts are and what you’re expecting them to be. Do you have any sample anonymized data you can post to help paint a better picture of your issue?

I’m going to add my two cents for a date offset dimension table. It will allow you to compare the same amount of days for the current month for the prior period avoiding the potential dip you can see when comparing the current incomplete month. I’ve done a prior write up about this here:…

@WizardOz Have you tried removing all of your groupings and filters and then reapplying them?

If I recall correctly you should be able to pass in the abbreviation of the time zone like EST or the full ISO name like US/Eastern as parameters to CONVERT_TZ

I’d like to see more detailed errors all throughout the Domo product so I can try and diagnose problems easier instead of having to submit support tickets. You could even make it a flag each instance could enable if they wish.

Is there any error message it tells you or is it something generic? Does the job consistently run successfully on the manual retry? Have you tried creating a new connector for this one spreadsheet to see if that resolved the issue? Are there any spaces or other non-alphanumeric characters in your file name?

Are you using workbench or the connector to pull your Postgres data? Typically when I needed more control locally over my pipeline I’ll write a Python script to process my data locally within the script and then upload the resulting dataset via the API/pydomo SDK

You’d need to log into AWS and generate a key and secret to use. The connector doesn’t support SSO authentication

Hi @Dharshini another alternative is window functions which allow you to aggregate across a partition / subset of your entire dataset. You need to have your CSM turn it on in your instance to utilize them in beast modes. SUM(undergraduate_population) / sum(sum(undergraduate_population)) over (partition by act_score) I…

Our of the box it’s not possible to combine both of those charts in the same visualization. As @MarkSnodgrass mention you could use a drill path which requires the user to click into the graph. @amehdad21 mentioned you could do the tooltip but if you want a pie chart on the map chart you’d need to do a custom app. You…

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: