Best Of
Display a Card's Quick Filters on Stories (+ Quick Filter Sorting)
I would love to enable a card’s Quick Filters to show up along with the card when designing stories. I often design filters at the story level to replicate the quick filters the user would see if they open a card in full screen, which seems like potentially unnecessary extra work - and in the case that they are based on Beast Modes, may not be available at all (I try to avoid this...but it happens).
Quick filters can collapse and be scrolled through -- so if the layout area isn’t large enough to show the full set of criteria, I’d expect them to collapse down and/or display an up/down scroll bar.
One con to Quick Filters is that you can’t currently force a sort order. For example if my quick filter is showing the words January, February, March, they would display A>Z, or February, January, March in a quick filter, but I can fix that in a filter card by using an additional column, maybe a date or sort order. I’d love to have a setting in Quick Filter configuration that says “Sort By:” and lets me pick A>Z, Z>A, or by another column on the dataset (including Beast Modes, please).
So - in my perfect world, please allow a) sorting of quick filters and b) “show quick filters” when setting up card display settings on stories.
Add Count Distinct to Column Aggregation options
For string values, the Aggregation options are currently No Aggregation and Count. Adding an option for 'Count Distinct' would be very helpful. Instead of having to write Beast Mode calculations.
mberkeley
Re: Show all dates between start and end date columns on calendar card
You can accomplish this by using a SQL transform to combine your "time off" data with the Domo Calendar dataset (Domo Dimensions > calendar.csv). The code below should give you a good starting point to edit to fit your needs.
----------
SELECT
Off.*,
Cal.dt
FROM tbl_TimeOff AS Off
INNER JOIN tbl_DomoCalendar AS Cal
ON Cal.dt >= Off.`start date`
AND Cal.dt <= Off.`end date`
----------
This essentially "creates" an individual record for all dates between your start and end dates. Should give you the data you're looking for. Hope this helps!
Unknown