Best Of
Re: How can I change a cell that has not data to say "none?"
case when `Credit Type 2` is null then 'none' else `Credit Type 2` end
enter this formula into a formula tile in magic etl. this can also be done in a beastmode.
nmizzell
Re: Filters not displaying all data present in the dataset used.
Sure thing. I am available today 11-12 MT or tomorrow 1-3:30 MT. Would either of those work for you?
Re: Removing Duplicates and making sure only the one with the most recent move in stays
If you use a Rank & Window tile in your ETL you can apply the DENSE RANK function to rank on MoveDate descending and partition by the Unit Id. This should give you a Rank of 1 for the most recent date and then you can add a filter to filter for Rank = 1
Variables with Python Forecasting
Is there a way to use variables with a Python forecast model like ARIMA or Random Forest?
I have a linear regression working, and I'm able to extract the coefficients, create variables, and use a Beast Mode calculation to generate a forecast. However, I'm unsure if this can be done with models that aren’t linear.
Ideally, I'd like the user to input their exogenous/explanatory variables and see a forecast at the dashboard level. Has anyone done something similar?
Re: Is there a way to remove cards en masse from my "Shared" page?
In Domo, if you're the owner of a card, it will automatically appear on your "Shared" page because ownership implies that it's part of your content management. Unfortunately, there's no built-in option to retain ownership of a card while removing it from your "Shared" page - this page is designed to display content that you own or have shared access to.
Unless you transfer (in bulk) the ownership to another or different group.
Re: Inline editor taking focus on dashboard
I'd recommend logging a ticket with support to have them assist with this as it's an issue dealing with the underlying architecture.
Re: How to pull data from a report within a website report
USDA appears to have documentation on their API online:
https://www.ers.usda.gov/developer/data-apis/
It looks like you just register for a key (credentials). You then use a Domo connector to interface with the USDA data. I'm not aware whether there is a USDA specific connector, but you can probably use the generic JSON No Code oAuth connector. Just search AppStore for either USDA or JSN.
Re: Is there a way to remove cards en masse from my "Shared" page?
You could use "Cards" in the admin section, filter for Page = "Shared" and then remove your access to the cards. Otherwise no there is not a way. You have to unshare it from yourself as @ArborRose pointed out.
Re: Is there a way to remove cards en masse from my "Shared" page?
You can remove cards from the "Shared" page in Domo by adjusting the sharing settings. Open the card, and click on the three dots (menu) in the top-right corner of the card. In the sharing settings, you’ll see a list of people or groups who have access to the card.
Re: Filter Formula - Current Date + 3 days
In order to add 3 days to the current date you would want to write it like this:
DATE_ADD(CURRENT_DATE(), interval 3 day)
