MarkSnodgrass Coach

Do the URLs have a consistent format to them? If so, you can use the formula tile in Magic ETL to extract the ID at the end of the URL to create a new column called Product ID. You can then use the Join tile in Magic ETL and join the two datasets together. An example to use for the formula tile based on the two samples you…

If you have added the DomoStats datasets to your instance, the People dataset has the last login as a column. Pulling the information from there might be the easiest.

Dealing with counts is a little different. Try this: SUM(SUM(1)) OVER (PARTITION BY `id`) / SUM(SUM(1)) OVER ()

I think I have something for you to get your started. /* check to see if the start hour is too late */ (CASE WHEN HOUR(`startdate`) >= 17 THEN ((UNIX_TIMESTAMP(`enddate`) - UNIX_TIMESTAMP( /*move it to the next day and start at 9 */ ADDTIME(ADDDATE(DATE(`startdate`), interval 1 day),9*60*60))) / 3600) ELSE /* subtract and…

This is an interesting one. I started sketching something out and there are a lot of scenarios to account for. I think you will need multiple nested case statements and you would use the WEEKDAY(), DATEDIFF(), and HOUR() functions to help with doing the math. I'll see if I can come up with something workable over the…

I would use the Pivot Tile in Magic ETL to do this. This is what it is designed for. You can read more about how to do it in this KB article: https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot

You need to make sure the "window functions in beast modes" is enabled in your instance. Your CSM can get it enabled for you if it is not. You can then do something like this, changing the name of the field to yours: sum(amount) / sum(sum(amount)) You can watch this video for a good walkthrough about it.…

Have you tried wrapping the DATE() function around your column in your MySQL dataflow to force it to be a date column? SELECT DATE(`last_update`) FROM

Just to be clear in case you aren't aware, CURRENT_DATE() is a built-in function that will return today's date whenever the card is viewed. MONTH() is a built-in function that returns the month number of a given date.

You might need to be more specific as to what your are looking for, but if you are wanting the number of months left in the calendar year, you could do this: 12 - MONTH(CURRENT_DATE())

@azyda when view the dashboard, if you click on the card title of one of the cards that is not displaying correctly so that you can view it individually in full screen mode, do the colors work? If so, it seems like there is some sort of bug and you might need to reach out to support, support@domo.com .

@GrantSmith has more direct API experience than I do and he might have done this before. Grant, do you have an example that you might be able to share?

I would suggest looking into two different options, leveraging the Domo API or using the Java CLI tool: Here's a link to the API documentation:https://developer.domo.com/ Here's a link to the Java CLI Tool: https://domohelp.domo.com/hc/en-us/articles/360043437733-Command-Line-Interface-CLI-Tool Hopefully one of these works…

If you switch to the line + stacked bar, the general chart properties has the option for number of running total bars. I'm not sure why it isn't available in the curved line card, but you could do it if you switched card types.

I don't have a good dataset to test this with, but I wonder if this would work: SELECT a."Opportunity ID", a."Owner ID", a."Created Date", a."Close Date", a."Snapshot Date", a."Last Modified Date", a."Next Step", a."Competitor", a."Amount", a."Stage", COUNT(pushes."Opportunity ID") AS "Push Count" FROM…

The curved line will use what is in the y-axis, so drag the field that you want as your first curved line into the y-axis field. To add a second curved line, go to the Chart Properties - General and enter 2 in the Series on Left Scale property. Next, drag the field that you want as the 2nd curved line into the series and…

Try adding offset to your parameter, such as: offset=499&limit=500

I have run into this before and I think the Analyzer just gets a little confused at times. I would try removing the field that it is currently tied to from your table list of columns and see if that unlocks it. You have a lot of columns, but I think I have also just re-build the card from scratch to fix it as well.

I just came across this KB article and this might be useful to you as well. https://domohelp.domo.com/hc/en-us/articles/360043430133

When comparing by months between 2022 and 2021, there is only one month in 2022 that has occurred, so the rest of the months would be zero causing your math to result in a negative value. You might consider looking at this post when building period over period analysis.…

Domo has a JSON No Code OAuth Connector that you might be able to use in this case and avoid the process of building a custom connector. You can read about it here: https://domohelp.domo.com/hc/en-us/articles/360052105454-JSON-No-Code-OAuth-Connector

@MattGo not a problem. Happy to help. If you can mark any answers as accepted that helped you, that will help others in the community.

Are you using the HTML table card? This is not the standard table card, but is found under tables and textboxes in the chart type dropdown list.

This is what the beast mode looks like: CONCAT('<a href=https://www.google.com>Google</a>') If your url is coming from the dataset, you would add additional concat arguments and use your fields.

I noticed some of your case statements don't have an ELSE clause. I would start by adding ELSE 0 to those as Domo doesn't like subtracting when one value is blank. Hope this helps.

@MattGo I did just do a test using the HTML table card and if you have a column that has a hyperlink, it renders properly in the e-mail body itself and will take the user to the link. I did find that you need to make sure that your link is in one of the first few columns because it doesn't seem to show all of the columns…

A good place to start is to install the Domo Stats dashboard in the Domo App Store. It will create a number of datasets that will have this type of information and it will also build a set of cards for you. There is also the Domo Governance datasets in the App Store. I would look into adding those to your instance as well.…

Unfortunately, you need to create a new account, which you can do in the data center under the accounts sections, and then you can go to the dataset using the connector and then choose the new account you just created under the settings section. You can share the account, but you can't change the owner.

On some connectors, in the configuration settings, there is the option to include the file name as a column. If you have this option on the dropbox connector, select that and then you can use the formula tile in Magic ETL to extract the information you need.

@Andrew_Chaffin works with John Stevens and may be able shed some light on finding these missing items. Andrew, any help you can provide?