MarkSnodgrass Coach

That is strange. I am an admin and I just made myself a co-owner without issue. What type of dataset is it? Maybe if it is a federated set. Try with other types of datasets and see if it is consistent.

Yes. when you are in the data center and the datasets page, you can hover over the top left corner of a dataset and it will expose a checkmark. You can then select multiple dataset and then click the person with the plus sign in the top right and it will allow you to set the co-owners.

It would be nice if there was a switch you could toggle to show all the datasources used on the page, but there is not. The easiest way I have found is to start to add a page filter and then click on a field that has an arrow next to it. This will show you the datasets on the page that exist. If you have a common field…

Yes, you can have co-owners. In the data center, if you click on the dataset and then click on the 3 dots in the top right and choose Share Data. You can add people and choose co-owner as an option.

I would suggest keeping your data in your original format and then building out your unassigned dates by using the rank and window tile and a formula tile. I did it by doing the following: Connect your original dataset to a rank and window tile and then create a column called Last End Date and choose the Lag function using…

As @GrantSmith said, the surest way to have all calendar dates in your dataset is to join it to the Domo Dimensions calendar dataset. Alternatively, if you have an ActionADate and an ActionBDate, you can create a beast mode called date and use this function to ensure it pulls a date: IFNULL(ActionADate,ActionBDate) Then…

This is a long article, but definitely worth a read to understand the Domo architecture. Data Fundamentals: Understanding Relational Data, Domo Architecture, and Data Pipeline Optimization – Domo I would start with the view itself and trim things there. Beyond the number of columns, I would look at the types of joins and…

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…