MarkSnodgrass Coach

Unfortunately, there isn't. The closest thing is at the subtotal level and the option to suppress single item subtotals. Another option is to create a beast mode for your value field and replace values with null on items you don't want totaled and use that field as your value instead.

@GrantSmith is the king of window functions. He will be able to tell you what to do.

Is there anything in your sorting properties? That is often a common cause as to why it is not grouping as expected.

Domo uses MySQL 5.6 so keep that in mind as far as leveraging recursive features in MySQL. This article might be of help to you. https://explainextended.com/2009/07/20/hierarchical-data-in-mysql-parents-and-children-in-one-query/

Yes, try SPLIT_PART(url,'copeland-sku',2) and see if that gets you what you want.

I like to use the SPLIT_PART() function for this. It would look something like this: SPLIT_PART(url,'/',7) This should return everything after the last slash (i.e. copeland-sku-zp20kae-pfv-130) SPLIT_PART(STR,SEP,N) Returns the Nth substring of str split by sep. If N is zero or smaller, returns null. If there are fewer…

That's great to hear @loganherzog . If you can mark the answer as accepted, that will help others in the community.

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.