Best Of
Re: Incremental refreshes using Domo Workbench
Hi @MarkSnodgrass, I'll try this and provide an update this week. Thank you!
Re: Domostats activity log not updating properly
I would double check the settings tab of the DomoStats Activity Log dataset to make sure that it is running daily and then check the history tab to see that it has run successful up to the most current date. You can also check the data tab and look at the Event Time column to make sure it is current.
If those all check out, I would go into Analyzer on the card and verify that Event Time is the field being used in the date range filter. I would also check to see what filters you have in place that might be causing it to show older dates. A good test is to remove all filters and see what date is the most recent.
Re: Filter Column Data By Value
I believe that @jessdoe is on the right track here. The only thing that I would add to her code is an "ELSE 0" before ending the case statement.
SUM(CASE WHENSource=LocationTHENValueFieldELSE 0 END)
Re: Newbie - DDX Bricks - How do I remove demo datasets?
that's interesting the page filters are interacting with them if your javascript code in the brick is only referring to dataset1. There is not a way to add/remove datasets, which is an unfortunate limitation of bricks. The easiest fix I would suggest for you is to make a domo webform or an excel file that has 3 columns and map the datasets to that.
Re: Newbie - DDX Bricks - How do I remove demo datasets?
I can't find a way to remove the extra DS as well but I have been using this work-around. Try using DDX "Unique List Sorted App" There is only DS in there. All you need to do is to replace the HS, HTML & CSS
michiko
Re: I am seeing the shield icon on my dashboard, how can I hide this?
You can keep them from showing by doing the following:
On the dashboard, click on the wrench and choose Filter Options
Then toggle off the Show Filter and PDP icons
Re: Smart Text - Show Actual Year Value, Rather Than Date Range
Thank you both for your help.
@jessdoe, your suggestion ended up as the one I implemented. I'm able to have a clean looking header in the report, which now includes the appropriate filtered date.
@ColemenWilson, I appreciate your suggestions and thank you for link to best practices. I removed the date related info out of all card titles as suggested. The single value card didn't really work for me, because I was forced to have a title on the card. Also, I don't see where I am supposed to select "yes", when my problem was solved.
Using Domo with an Integration Platform for Automated Action
I'm a big believer in BI being much more than simply connecting up all your data and creating read-only dashboards. More and more of our projects should be focused on process automation and integration. These types of projects have a meaningful impact on the business and can help quantify the value of a BI team.
Made a quick tutorial showing how you can leverage an integration platform in conjunction with Domo to easily automate different systems in your business 👇
ellibot
Re: Smart Text - Show Actual Year Value, Rather Than Date Range
Colemen's instructions should work. Try using the summary rather than smart text option:
jessdoe