GrantSmith Coach

Hi @Domofied You might be able to do this as a calculated field in a Dataset View but because you're on ETL 1.0 you wouldn't be able to use it as an input into your dataflow. It'd have to be your last step before you visualize your data.

Hi @WizardOz I’ve found removing the group by and replying the groupings usually resolves this issue but I would definitely reach out to Domo support to raise this issue with them.

Hi @Rvannoy What is this section of code doing? and (case when right(`CurrentMonth`,2)-0 = '1' then 'Q01' when right(`CurrentMonth`,2)-0 = '2' then 'Q01' when right(`CurrentMonth`,2)-0 = '3' then 'Q01' when right(`CurrentMonth`,2)-0 = '4' then 'Q02' when right(`CurrentMonth`,2)-0 = '5' then 'Q02' when…

Hi @user095063 This is because you already have a dataset with the date listed multiple times. There are a few options to do an upsert using Magic ETL 1, Magic ETL 2.0 and MySQL. Note that as your dataset grows these will take longer to run. Magic ETL 1.0: Creating a Recursive/Snapshot Magic ETL DataFlow Magic ETL 2.0:…

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…

@Ritwik Thinking about this a bit more - you could utilize a Dataset View and a calculated field with a window function to calculate the rolling max and then use that as an input into your Magic 2.0 Dataflow. Just make sure your partitioning correctly based on your assets. MAX(`random_number`) OVER (ORDER BY `dt`)

Hi @Ritwik You can use the LAG function in the rank and window tile to calculate the different columns/values for the past X rows (depending on how long your window is). Assuming you have Magic ETL 2.0 you can then utilize an Add Formula Tile to calculate the GREATEST value of all of your lag columns. Not pretty but that…

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