MarkSnodgrass Coach

I used the Microsoft Exchange Rest Connector for connecting to calendar information and it is not on-prem. I found the connector not very useful, though, as it was limiting to only my calendar or ones that were shared with me.

Ahh, interesting. Glad they were able to help out. Once you get the patch installed, the steps I outlined should get you authenticated again.

Unless your IT adminstrators have browsers disabled on the machine that Workbench is installed on, it should open a browser. You may want to reach out to Domo support if you are still unsuccessful.

Are you referring to the 3 lines in the top left of your Domo instance which exposes the pages menu? Hovering over the 3 lines will expose the pages you have access to. In the Admin menu, they are called Dashboards and Privileged users have access to this.

Looks like yours say Authorize. Click on Authorize. It will then launch a browser for you to sign and enter a code. Once done, be sure and click the save button in Workbench.

This happens when your password has changed or expired. You will need to click on the key icon on the left of workbench and then click on re-authorize. It should open a browser and have you enter your credentials and a code. After you enter that, be sure and click on the save icon in workbench in the top right where you…

You can use LEFT(fieldname,1) to get the first character and RIGHT(fieldname,1) to get the last character. You can then test for numeric by using TRY_CAST(leftcharacter as integer). If it returns null then it is non-numeric. I would create separate fields in your ETL for each of these functions so it is easier to test as…

I would start by uninstalling the add-in and then re-installing it to make sure you are on the most recent version of the add-in. If that doesn't work, I would reach out to Domo Support as it supposed to be supported.

The easiest way to unsubscribe is to click on the card, then click on the alerts icon, which exposes the alert details. The icons in blue are the ways you are subscribed. Click on it to turn it grey, which will unsubscribe you from that type of notification.

You can use the split columns tile in Magic ETL to split up your string by looking for the comma. You would do multiple splits in that tile so that you can get to the 3rd and 4th entries. You can then do a filter tile where you filter out entries that have the values you want to exclude. Here's a KB article on the split…

I would just not format the revenue as currency, but as a number with commas. I would think people will know without needing the $ sign. The other option would be to make two different fields, one for revenue and one for the other. Then, you can use the built-in formatting for each of them.

@Ashleigh is well-versed in CourseBuilder. She may have some insight on how she tracks her courses.

Since you are concatenating inside your case statement, it becomes a string, so you can't sum it. You will not be able to have one value show up two different ways inside a sum. I would suggest just having your revenue case statement just return a number and the beast mode should work.

Are you using Magic ETL? If so, the full quotation marks " are your problem. Instead, just start typing the column name without any quotation marks and then select it from the auto-complete list. Domo uses single back ticks ` if you wanted to try and manually type it, but it is much easier to start typing the name and…

That is an odd error. I haven't seen that one before. I would using your Division field first and see if it produces results without an error. I would also try switching to a standard table and see if that works. You might also try removing Division out of the Sorting properties and replace it with your beast mode. Hope…

First, make sure that you are installing it form the Microsoft Appsource here: Second, within PowerPoint, go to File → Options → General → Privacy settings and make sure "Enable optional connected experiences" is checked.

As an alternative, you can use the HTML Single Value Brick. This would allow you to create a border with some basic HTML and CSS. You can find this brick in the Appstore by searching for brick.

I wonder if you could reach out to support to get them to give you at least a one time report on this. You can see the null percentage on a dataset when you go to the stats view on the data tab, so the information is there. It could also be worth submitting an idea in the Ideas Exchange as a Domo Stats/Governance dataset…

There is no limit listed in the Domo documentation. Certainly, the more joins you add, the bigger hit on performance, so that will be something to consider. You can try sending an e-mail to Domo Support and see if they will give you an exact number, if there is one.

I have not heard of a row limit on dataset views. In fact, it is often used on larger datasets, so I wouldn't think there would be a limit. Are you getting an error that is telling you there is a limit?

A Sankey chart could be a possibility for you. Otherwise, I think you would want to look into the custom charts option where you would upload a SVG file that has the hierarchy format you are looking for. I would start by doing a google search for hierarchy SVG files that you could easily adapt. You can also build your own.…

I have found the Period over Period charts to be extremely limiting for reasons like this and will often look to use a standard chart to get the same comparison. You might want to look at this video and see if you can adapt it to your needs as it will give you more flexibility than the PoP charts.

Your ETL will look something like this where you are linking multiple join tiles one after another. In your case, you would start with dataset B since that has the IDs for everything. Next, add a join tile and connect to dataset A and join on Ad ID. Next, add a join tile and connect to dataset C and join on campaign ID.…

You send a new file to that e-mail address and just have it contain the same column headings but no data. If your connector is set to replace, then it will replace the existing data with zero rows.

Pictures of me in a Halloween costume pre-date the digital age, so I will go with a picture of one my kids. One of my kids dressed up as Sonic the Hedgehog as he was a big Sonic fan. Also included is our dog with her Halloween angel costume.

Which suggestion solved it? If you can mark that response as an accepted answer that will help others in the community.

You might need to apply an aggregation to your Dat Avg CPL field. Based on the field name, try adding the AVG() function around it.

I would also check to make sure the Y-Axis is set to Sum (or the appropriate aggregation type).

PDP is the answer for this. This is exactly what it was designed for. https://domo-support.domo.com/s/article/000005116?language=en_US

Colemen is correct. It will temporarily explode your dataset, but then you filter it back down. Magic ETL processes it pretty quickly, though.