MarkSnodgrass Coach

I just did a search for "svg global map with states" and it took me here https://morioh.com/p/1ed2ddd34690 and I downloaded the big map at the bottom. I have attached it for you. You'll have to look through and see everything is properly labeled. You can edit the svg with Inkscape, which is free, or Adobe Illustrator.

Are you entering the full path in the img src? I just tried it and it worked for me. <p>Hello World</p> <img src="https://www.nlcmutual.com/wp-content/uploads/2021/02/nlc-mutual.svg" width="" height="" alt="NLC Mutual">

That appears to be a limitation of the combo box card type. I would actually submit this as a bug, because it should at least match the width of the component when the text is that long. You can send an e-mail to support@domo.com to let them know of the issue.

If I am understanding you correctly, you could make a percentage beast mode for each type, like this: Easy Client Pct: Easy Clients / Easy Clients + Medium Clients + Hard Clients Medium Client Pct: Medium Clients / Easy Clients + Medium Clients + Hard Clients Hard Client Pct: Hard Clients / Easy Clients + Medium Clients +…

@AeyaiSaengkeo that's great to hear! If you can accept any answers that helped you, that will help others in the community.

Your AND statement is slightly off. You are also missing an END statement inside the count. You have to re-state what you are evaluating, like this: CASE WHEN COUNT(case when `FirstSetupApprovedDate` IS NOT NULL then `CaseID` END) >= -1 AND COUNT(case when `FirstSetupApprovedDate` IS NOT NULL then `CaseID` END) <= 10 then…

Have you tried breaking this down and start with a table card and then create a beast mode for each of the functions and see what they return in the table card and then building it up from there? That should reveal where the error in the calculation is. You might also want to look at a nice write-up @GrantSmith did on a…

I was suggesting re-writing total months on SaaS to this: CASE WHEN `Start Date` = '2050-01-01' THEN 0 ELSE DATEDIFF(DATE(`Payment Processing Month`),DATE(`Start Date`) END However, since you are wanting the total months and not the number of days, you will need to do it slightly different. You can use the Period_Diff…

I believe your error is coming using the date_format inside the datediff. Your format that you are changing it to is not a valid date date format. Is Payment Processing Month not an actual date? I would try wrapping the date function around payment processing month in your 2nd formula as well as start date and see if the…

It's probably not the detail drilled map you are wanting, but if you use the global map again as your drill path card and select auto zoom to data in the general properties, it will zoom to the country that was clicked on. However, it won't have the detail of every state or province of that country. You can look on the…

@keeeirs10 Domo's MySQL is currently on version 5.6, which doesn't support lag. I would suggest using Magic ETL and using the rank & window tile and use the lag function in there. It will run very fast and is easy to put together. Here's the KB article on the rank & window tile if you haven't seen it.…

I have found that to misleading at times. If you move your cursor to the first parentheses after the sum, you should see which closed parentheses it is linked to. Due to order of operations, it is going to try and evaluate your revenue field divided by the sum of your other revenue field. I'm pretty sure that is not what…

It looks like you have a parentheses issue again. I see two open parantheses after your first sum. There should only be one there. You also have one too many, just before the comma. Try removing those and see if it works. Sometimes I will move things to separate lines to make it easier to read and make sure I have the…

That formula won't validate as constructed. I would re-write it like this, assuming you have a due date field: SUM(case when `type` IS NULL and DATEDIFF(`duedate`,CURRENT_DATE()) <=14 then 1 else 0 end) This assumes type is actually null and not an empty string. I am using sum instead of count because we need to only count…

Yes, that will work in a card beast mode. Just keep a close eye on the parentheses. You had one too many in what you just sent.

In your screenshot, it looks as though you are missing an open parentheses ( at the beginning as you should have two open parentheses together. You currently have one open parentheses and two closed ones.

Hmm.... I just tried doing the same thing in the formula ETL tile and it worked. Here is what mine looks like using some sample data: POWER((`DaysPast` / `Lag`),.2)-1 Do your rev Yr 5 and rev Yr 1 fields have nulls? It won't be able calculate unless they both have values. Is your formula validating in the editor, but then…

@NathanDorsch I haven't seen a connector where I can choose which columns I want to import. However, I often build an ETL on top of my source dataset, so that I can select which columns I want and rename them as necessary using the select columns tile in Magic ETL. This also gives me the flexibility to swap out the source…

It looks as though you are wanting to count when something is done and due in the same month. In which case, I would do this: CASE WHEN Month(duedate) = Month(donedate) AND YEAR(duedate) = YEAR(donedate) THEN 1 ELSE 0 END You can then sum this beast mode to get the count.

@NathanDorsch Yep! That did it! Thanks!

I would change your beast mode to be like this: CASE WHEN DATE_SUB(`dt`, INTERVAL (DAYOFMONTH(`dt`) - 1) DAY) = DATE_SUB(CURRENT_DATE(), INTERVAL (DAYOFMONTH(CURRENT_DATE()) - 1) DAY) THEN 'Current Month' WHEN DATE_SUB(`dt`, INTERVAL (DAYOFMONTH(`dt`) - 1) DAY) = DATE_SUB(DATE_SUB(CURRENT_DATE(), INTERVAL…

If you do have a date field, you can normalize a couple different ways to get them to be grouped by month and year. The easiest is probably using the Last_Day() function, like this (replacing dt with your fieldname that has the date: LAST_DAY(`dt`) This will create a date field for you and have all the transactions in a…

The connector does seem to be geared towards past meeting information. If you can find the right API call in Zoom's API documentation here: https://marketplace.zoom.us/docs/api-reference/zoom-api/ You could look at bringing it by building your own API connector, or try using the JSON No-Code Connector. You can also send…

I would try and sort on a single date field. If you don't already have it, and you just have the individual month and year columns, you can construct a date field like this in a formula tile. DATE(CONCAT(`Month`,'/1/',`Year`)) Add this formula tile just before your rank and window tile and then sort on this date field…

@Fadem I have not had trouble saving my drill paths and the columns in my table card staying the way I designed them. Are you clicking on the wrench of the main card and choosing Edit Drill Path and then clicking Edit View and then designing your card (I assume a table card) the way you like and then choose Save and Close?…

Isaiah, I have not heard of a limitation of the number of input datasets (or seen it in the documentation), but you could probably ask your CSM to research that for you to get a firm answer. From a management standpoint, I would suggest breaking your ETLs into smaller ETLs, so it is easier to troubleshoot if something goes…

If I am understanding you correctly, I think you have two options: In your main card, use the beast mode that returns your desired date. In Analyzer, set the Date Range filter to use this date field and then set it to graph by week. This will display the week of year for you in the card. When you drill, it will still be…

@user027926 you can't use a lag function in a formula tile within Magic ETL. That is why I suggested doing a lag first with the rank & window tile to put the previous value next to your current value as a new column. Once you have the previous value in the same row as your current value, you could do the formula work that…

You can join the Domo Governance Beast Modes dataset with the Domo Governance Datasets dataset to get the dataset owner of the beast mode. They also have a Domo Governance Cards dataset that you can join to the Domo Governance Beast Modes dataset to get the card owner of a dataset.

You could utilize the Lag function in the rank & window tile get the previous row's flag next to the current row's flag as another column. Then use the formula tile to overwrite the unique id if the previous and current flag are the same. Finally, you could use the rank & window again and use the row number function and…