Best Of
Re: What function will help me determine a variable part of text?
You can use a CASE statement with a LIKE operator to determine if the word Delivery is in your string:
CASE WHEN `field` LIKE '%Delivery%' THEN 'True' ELSE 'False' END
If you want to have it case insensitive you can use ILIKE instead of LIKE
Re: Global vs Card-Specific Filter Differentiation
While hovering over the filter indicator for the card will tell you which filters are being applied to it and hovering on the filter name tells you which DataSets are affected by it, most users are unlikely to know which of the cards in the story are from one of the listed datasets, so this visual aid would be awesome!
Re: Filter Request from Custom Domo App
Have you looked at the domo.filterContainer() method?
Re: I want to create a column that contains the total sum of another column.
@kav_100 you can also try to use fixed functions in a beast mode, its like doing a group by but in a card so you keep all your granularity.
Ashleigh
Re: I want to create a column that contains the total sum of another column.
@kav_100 I'd suggest using a Group by Tile to find the totals, then joining that back to your detail data
Re: Date format question
Use a Magic ETL with a formula tile to make the value null if it's -3:
case when `field` <> -3 then `field` end
You can then feed that into an alter column tile to change the type
Re: Allow sorting of dashboards in menu
I about fell out of my chair when I realized that you can't set an order of dashboards for users. This is a critical functionality of any sane layout and an absolute must have.
Re: Moving a card in the heirarchy into a subpage
That's weird, perhaps a new layout being rolled out, as I still get the check boxes there but there are many differences between your view and mine (we both have the same role). A silly question, but just in case as sometimes pages might render differently if you're working on a mobile device and some options might not be available unless you open it on a computer browser (a blind guess there).
Also make sure your address bar is taking you to https://[yourcompany].domo.com/admin/pages as if it's a new layout, hopefully it is using a new URL that defaults only to some. If all this fails open a ticket with support to help figure this out.
Re: Aggregate counts over time that keep a running total
Yeah, it should be a date field to return the proper year. If Org Creation is already the year then you can just remove the YEAR() function in the beast mode
Re: HTML image
You'll need to host your image elsewhere, outside of Domo. There are several free image hosting sites out there you can check and perhaps use depending on how sensitive your data is. If your company has a website and FTP access, you might want to talk with the department that manages it to see if they can create a directory inside your company website structure to host the images publicly and retrieve them from there.