MarkSnodgrass Coach

The first thing to check would be to see if your company's firewall is allowing Domo to connect. There are a list of IP Addresses that need to be whitelisted. You can find the list here: https://domohelp.domo.com/hc/en-us/articles/360043630093-Whitelisting-IP-Addresses-for-Connectors?cid=connectorips I would verify that…

I would send an e-mail to support@domo.com to start a support ticket on this. That is been the best way I have found to open up support tickets. They will reach out to the connector team to troubleshoot the issue.

Did you have a question that you need answered? Or were you just sharing for the community?

It doesn't appear their are any switches available for the workbench exe, which limits your options. You could try creating an msi package via some online tools and then you will be able to deploy it via Group Policy. You could also reach out to your CSM or Domo Support to see if they have an msi package available.

I was wondering if the settings were what you were actually looking for. I meant to mention that in my first response. Glad you found it!

That is not possible right now. You could submit it as an enhancement in the Ideas Exchange section of the Dojo. This allows it to be voted up by other people in the community and then the development team can consider including it in their product roadmap.

the directions you reference are not for Domo, but for Google. In Domo, if you want to edit an ETL for a dataset, the easiest way is to go to a dataset or dataflow in the datacenter and find your dataset and then go to the far right and click on the wrench and choose Edit. If edit is not an option, you likely don't have…

@Mario how did this go for you? Did this solve your problem?

The KB article indicates that you are going to need to work with your Doom CSM and support in order to get it configured as the connector isn't completely ready. I would reach out to them to get it configured. Note: The user interface for building this connector is not yet available in our Connectors listing in the Data…

I would check the Activity Log dataset which is available through the DomoStats connector. I see there is an event type of invited.

You can build your range dynamically in Magic ETL with the use of the formula tile. I broke it up into groups of 10, but you could break it up into different groups by changing the numbers around if you wanted to. In the screenshots below, I am building a range dynamically using a few formulas: This is what it result in:…

@FreshSqueezed if you can provide a couple rows of data from the dataset that you are building the card with that would help @mhouston and I a better understanding of what might be going wrong with the formulas that you have tried.

Here is what you can do assuming you are using the Line + Stacked Bar card. Create another beast mode called PreviousYearSales that looks like this in and put it in the Y-axis: (CASE when YEAR(`execdate`) = YEAR(CURRENT_DATE())-1 THEN `invoiceamount` ELSE 0 END) Create a beast mode called CurrentYearSales that looks like…

@NathanDorsch yes that is the beta I was referring to. I was hoping it would include some features that would help you with this. That's a bummer that it does not. Are you finding that they have to be a certain size when exporting in order for the axis to show up? I'm not sure it helps with exporting, but the chart…

Unfortunately, what you are doing is the best workaround as this currently isn't possible. It is a good idea to submit to the Ideas Exchange section of the Dojo and see if it could be included in a future release.

Domo is working on enhancing the export process. I believe there is a beta feature that you can ask your CSM if you can be a part of to see if it will help. Right now, it is a little bit of trial and error. One thing you can do that might help is to turn off some of the display options on each card in your dashboard. If…

Yes, you can do this. If your page is set to a standard page, you can choose the small size card size and will allow you to put 5 in a row. If you are using the dashboard page layout, edit the dashboard and choose options and display mode and choose auto width. This will give you more screen real estate to put more cards…

@Kellerry I totally agree with your suggestions. I would suggest submitting this in the ideas exchange section of the Dojo so it can be voted up by others in the community and the product team can review it and potentially include it in the product roadmap.

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.