MarkSnodgrass Coach

That's great to hear @user027926 . If you can mark any answers as accepted that helped you, that would help others in the community.

I forget the text formatting tile is there. I tend to just do it all in the formula tile like this: (CASE WHEN UPPER(`Specific Category`) LIKE '%PEOPLE%' THEN 'People' WHEN UPPER(`Specific Category`) LIKE '%UNKNOWN%' THEN (CASE WHEN `Platform` LIKE '%Amazon%' THEN 'Amazon Likely Retail' ELSE 'blah blah' END) ELSE 'would be…

In your specific category column is Unknown entered exactly like that? Meaning does it have a capital U? These can be case sensitive and it can often be easier to wrap an UPPER() function around your specific category field and then have your like statements be all uppercase. Your Then or Else statement does not need to be…

@GrantSmith by a millisecond .... again. :)

If this is displayed in a table, you can create a beast mode to deal with the sorting. You can use the HOUR() function to extract the hour (0-23) from the datetime field and then drag that into your sorting property and sort by ascending. You could also use the UNIX_TIMESTAMP() function and drag that into the sorting. If…

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.