Best Of
Re: Creating a separate column using magic ETL
I agree with everything @MichelleH said, it's likely the lack of % or difference between ` or ' are causing your syntax errors. I would add to keep in mind that CASE statements are evaluated sequentially when using the LIKE operator.
If your data includes values such as 'WBH - Wisconsin' and 'WBH - Wabash' evaluating like 'WBH%' then 'Wabash' before 'WBH - Wisc%' then 'Wisconsin' will result in both values being evaluated as 'Wabash'
Re: Remove answered questions from the list of unanswered questions
@ArborRose, thank you for your input. I really appreciate feedback that helps provide a better experience on the Community Forums. I am working with our support team to make this experience more intuitive. Thank you!
Re: Twitter connector returning unknown date format
Hi @eli_gripp1, are you using the normal connector or advanced? I use the Advanced Connector (just named 'Twitter' in the Appstore) and have not encountered any issues with configuring. I did notice that the ones named 'Twitter Connector' and 'Twitter Connector v2' have not been updated since 2020 and 2021 respectively. When you go to Settings -> Details of your dataset, does it give any more details to the error?
amehdad
Re: Remove answered questions from the list of unanswered questions
@ArborRose That's because this is an Ideas Exchange post. That option is only available on posts initated as a question, using the "Ask a Question" button on the Community Forums main page
Re: Remove answered questions from the list of unanswered questions
@ArborRose It would be under another person's post. You should see this under other people's posts:
The person who originally posted the question would then click 'Yes' for the answer that gave them the solution and then the post would get a check on the board.
Re: Change chart sort order based on variable value.
You can utilize your variable and select the different fields depending on the value of your variable:
CASE WHEN `variable` = 'Date Value' THEN `date field` ELSE `category field` END
Toss that beast mode into your sort and select sort descending.
Re: Buzz - Bulk Deleting Previous Content for Whole Organization
We would definitely love the opportunity to bulk delete as well. Or auto-delete posts that are a certain age. For us, Buzz is a tool for the users to communicate and share, but it is not utilized as our support communications tool, which can muddy up the instance when a user floods the buzz feed with usage and access questions. We have found that not having this functionality not only creates a messy environment, it also creates a certain degree of negative commentary around using Domo when we can't remove some of these things.
(Yes, we know we can delete individual messages, but it does still show “Message Deleted” which isn't ideal)
Re: Export Data Option - Exports WITH Selected Filters
@jdorsch2 You can do this by opening the dataset in Views Explorer. When you export a View, it will only include the rows and columns you choose. Also note that you don't have to save the View to download it, but you can if needed.
Re: Domo Variables Use Cases
This page appears to be a demo page for the purposes of the video. If a customer is seeking the information surrounding variables, the KB has the below article providing an in-depth explanation of Variables, so customers should not really need access to the Domo Variables Use Cases page.
https://domo-support.domo.com/s/article/7903767835031?language=en_US
BGomez