Best Of
Re: Slider Filter Card - Min & Max beast mode
You shouldn't need to pre-aggregate, but I did a quick test and see what you likely need to do to make the card work for you. Using this sample data:
Grouping by Sales Rep, we would want a minimum of 1,100 and a maximum of 3,300 to show in the range selector. To do that, we drop in the Amount field into the minimum and maximum value and choose the aggregation type of Sum. Additionally, you need to drag the SalesRep into the Sorting section and choose No Aggregation.
Without the SalesRep in the sorting section, it will just sum up all the values and display 6,600 for the min and max in my example.
Hope this helps you.
Re: Onedrive connector to import CSV file inside the zip folder
Hi @Ab_Israni because you have a csv inside of a zip there are potentially multiple points of failure, can you try unzipping your csv and loading it directly? That may help to determine if the issue is the zip or the csv.
If it loads then that would point to an issue with the zip file, but if it does not then that would indicate an issue with the csv configuration
One Click Domo Scripting with Bookmarklets (Favelets)
Ever wish you could easily delete a Beast Mode from the Beast Mode Manager? Or click a button to delete all cards on a page before deleting the page? Well now you can with bookmarklets! If you aren't familiar with bookmarklets (sometimes called favelets), they are browser bookmarks that run JavaScript code when clicked. I recently made the discovery that they also support fetch API calls, which unlocked a world of possibilities for Domo-centered scripts. I wanted to share this discovery with the community and hope you will take it to new heights with your own scripts. But, I've developed a few and added them to GitHub to get everyone started:
Best part is, they don't need to be modified before use as they inherit authentication from your browser session and are built to dynamically adjust to the Domo instance you are viewing. In the repository, they are stored as beautified JavaScript. But the repository includes instructions to sync them all to your favorites bar and convert them to bookmarklets (which are minified and URL encoded). Alternatively, you can use something like the Bookmarkletify VS Code extension or an online service to convert them and add them to your bookmarks manually. If you don't have the skills to build your own, comment here or open a discussion on the GitHub repository for scripts you'd like to see and I'll build them. And if you build some cool ones yourself, I hope you'll share them by submitting a pull request to the repository.
brycec
Re: Showing value '0' as blank/null in mega table?
CASE
WHEN Metrics = 'QTY'
THEN CASE WHEN SUM(QTY) != 0 THEN SUM(QTY) END
WHEN Metrics = 'Sales $'
THEN CASE WHEN ROUND(SUM(Sales $), 0) != 0 THEN CONCAT('$', ROUND(SUM(Sales $), 0)) END
END
Just apply the same logic inside your case statement so you have a nested case statement.
Re: Filter Section
I am still sooooo tired.
@verytiredgirl upvoted! In the meantime, I have a few suggestions about how best to use filters in app studio. Hope this is helpful!
ellibot
Re: Add collapsible sections to "new" dashboard pages like the "old" standard pages
New update on this. Coming soon is a collapsible drag and drop sections component in app studio to help with this.
Re: Filter Section
Yeah, having collapsible sections would be great. Khushboo said they were coming soon on this post a few days ago, so that's hopeful:
Another implementation would be to give us more control of what users see in the Control Filters. There are a lot of votes for that here, and they say it's in the backlog (but that was a year ago). I would advocate upvoting that one, too:
Re: Quickkest way to select some columns for a View?
@verytiredgirl I normally will just select all to delete every column, then choose the 25 I want to add back:
ellibot
Re: Domostats dataset for Card Owner
That's interesting that those are now deprecated. It looks like you will need to use the DomoStats Card Permissions dataset and filter the AccessLevel to Owner and then join that with the People dataset based on the Entity Id in the permissions dataset and the User Id in the People dataset.
Is there a way to include a series in a period over period chart type?
I'm trying to include a series (basically different locations) of sales during this current quarter and graph compared to the same quarter one year ago. Using a period over period chart, I don't see any charts that allow for a series to include that 3rd metric broken down by location. Basically I want to include 3 columns. X Axis being the 'Date', Y Axis being the 'Sales' and Series being the 'Location'