Best Of
Re: Default Filter Selection
@DavidChurchman I should have went into the PDP issue… We were unable to get the filters to default to the first option due to PDP. In this use case, we have district managers over stores. The PDP restricts the managers to their stores. We want it to default to the first store in their list, which wouldn't the same store for everyone.
SherryR
Re: How set default values for variables in workflow?
That hasn’t been available, but is actually being released to you next week. As of now you cannot, but next week you will. I’ll be releasing a video highlighting the new functionality.
Re: Rolling 12 Months Calculation
It will still work, it just doesn't show up in the functions list - along with many other mysql functions.
Re: How do I escape single quotes/apostraphes in a Beast Mode?
Hi There
after 5 years this doesn't seem to be resolve. Even escaping:
CASE WHEN `Metric` = 'Don\'t Use' THEN ....
Re: I am trying to delete a row from dataset
Navigate to the dataset > Click "HISTORY" > Scroll to the update you want to revert to > Hover or the right side of that row > Click the wrench icon > Click "Revert to this point"
Re: To integrate a app into Domo interface
The error suggests the domo publish is failing due to an issue with how CLI is handling a file path. The path argument must be a string or an instance of Buffer or URL. The error indicates that somewhere in the process, a file path is either missing or improperly defined.
Update the Domo CLI
npm install -g ryuu
Or, depending on how you initially installed the Domo CLI, you might need to use:
brew update && brew upgrade domo
or
chocolatey install domo
It may also be due to an issue with your configuration file. Running the Domo CLI in debug mode can give you more insight into what might be going wrong.
domo publish --verbose
Re: Multiple dashboard filters
Yes! If they are from the same datasource this will happen automatically. You may need to adjust filter exceptions if they have been applied previously.
Re: Dashboard Filters breaking the card drill downs
First click "Edit Dashboard" and then use the wrench icon on the card once you are in dashboard editing mode.
Re: Dashboard Filters breaking the card drill downs
Do you mean that you can not drill down at all? Or that once you drill down the data is wrong? Check the card interactions and make sure Drill in place is selected. If you have not created a drill path for the card then the option to select "Drill in place" will be greyed out and you will not be able to select it until you create a drill path on the card.
Re: How to create dropdown filters within a card
What you've shown in your screenshot are "Filter Views" they are bit different. In my screenshot I added filter cards (cards whose only purpose is to filter other content) to the dashboard.
Here is a KB article explaining filter views:
To use filter cards, what I showed in my screenshot, you need to create a filter card in analyzer and then add those to the dashboard. While in analyzer view, go over to chart types and select "Filters"
Then select "Dropdown selector" as the chart type:
Then save the card and add it to your dashboard.