-
New Update Column Justification logic
Hey, There's been an update on how sort shows on table headers. When an item is centre-justified, the sort buttons offset the justification to the left, which makes it look absolutely rubbish. Has anyone got a workaround for this thats isn't removing sorting from the whole table? Best, Sam
-
Workaround to Pivot tables pushing non-valued categories to the bottom.
Hi, I'm currently trying to build out a pivot table with custom sorts on both the row and column values. As has been mentioned before on the dojo; pivot tables will always override the sort so that non-values will display last even with a custom sort including the column/row headers. Has anyone found a workaround to this…
-
Beast mode for help Sorting column
I need a beast mode so i can sort a column. I need to take the number out of this Engine column so then can sort in order. I have values like this Engine 1 Engine 2 Plant Engine 1 Engine 3 Plant Engine 2 Engine 4 Engine 5 I figure if i can just do a formula to take out the number then i can sort them together based on…
-
Adding Sort to Custom Values
Hi, I have a card that identifies days since last activity date: Days Since Last Activity Date: DATEDIFF(CURDATE(),Enrollment Initiative: Last Activity Date) And I made a bar chart with a custom range using this beast mode: CASE WHEN Days Since Last Activity<7 then '<7' WHEN Days Since Last Activity<30 THEN '7-30' WHEN…
-
Change chart sort order based on variable value.
Hi, I have created a variable that I am using on the y-axis of a bar chart. With the toggle letting switch between categorical and date values. I would like to be able to alternate how the y-axis is sorted based on which variable value is currently on the chart: Date values: The date values are calculated by year and I…
-
How to Sort by ASCII (caps first)
I have a user complaining that their pivot table column sort changed recently. It used to sort capital letters first. For example, it used to sort DOMO before David, but now it sorts David before DOMO. Now it ignores upper/lower case when sorting. I prefer ignoring case when sorting, in general, but is there a way to sort…
-
Sorting Heatmap by Month-Year Concat on y-axis and Day of Month on x-axis
Hello, I have a heatmap that on the x-axis has the Day of the Month and on the y-axis has the month and year concatenated, i.e. January 2022. My question is how can I order the axes in such a fashion that I get the most recent month and year concatenation at the top of the y-axis and have the rest of the month and year…
-
Sorting Beast mode
Hello! I'm trying to sort my beast mode where I'm normalizing my data to trend performance by the first month it's published and trending for a year since all my rows of data will have different dates in which they are published. The issue I'm running into is I can't sort the beast mode in order of Month 1, Month 2, etc.…
-
Limit Quick-Sort options
For example, a particular card may only want the quick-sort options to be Value-based, vs. category based. If alpha-numeric category sorting isn't relevant to a card, users may (are) be getting confused, but it'd be nice to save the 2-3 clicks to go "back" to the other value-sort they were looking at.
-
Way to sort by hidden field
Is there a way to sort a table by a field that isn't in the table columns? I'm trying to sort time information chronologically like this: 1:00 AM 2:00 AM … 12:00 PM 1:00 PM But Domo sorts it like this: 1:00 AM 1:00 PM 2:00 AM 2:00 PM etc. I can have the time displayed as 24-hour but I'd rather not if possible.
-
Barchart behaviour when the sorting criteria doesn't match the fields shown
Barchart has an umpredictable behaviour when the sorting criteria doesn't match with the fields shown in the card
-
Pivot Table Order of Columns
By default when you add a field to a pivot table as a column, it'll do all your Values calculations under each series before proceeding to calculate them for the next. Ex: But sometimes you want each calculation together and then broken down by each series, so the one at the top would look like something like: Since we…
-
Pivot Table to allow Sorting by Column vs. Grouping
We need a setting to switch whether columns should group the values (current behavior) or sort them when using pivot tables. By default, pivot tables will group all your Values by the columns you select which is useful when you want to see how a specific group is performing on a linear succession, like: But often you want…
-
Numerical Dimensions/Attributes
Add a column property to allow numbers to be defined as dimensions/attributes rather than forcing them to be measures. Common examples are ID, Order Number, Employee Number, etc. Sort, display, justify them as numbers, but do not aggregate them to a meaningless value. In other tools I have seen this as a simple checkbox.…
-
Sort by Top 20
Hi, I am currently looking at a healthcare practice's insurance list, which is hundreds long. I would like to create a chart with only the top 20 most commonly used insurances. Is there a way to do so in beastmode? I've tried chart properties → general → maximum rows (20) but it didn't work. Thanks!
-
Get Top 5 category values for each date from category
I have a column "category" which has more than 10 categories for each date. I would want to see only the Top 5 category for each date. Can I get a beast mode or a work around for the same. I have attached an image for reference.
-
Governance: Control order of subpages for users (outside of company pages)
I often build subpages that have a set of prefiltered reports -- usually for specific cities where we do business. I build the pages in the order the data shows up. So if Salt Lake City data comes in before Atlanta, the Salt Lake subpage is set up and shared first. This can cause the pages to appear for my users in the…
-
Problem with column sorting
Hi All, I am sorting a dataset in the visualizer...I am sorting by the dealer name and whether the item got shipped or not and then by the order date all in the ascending order... The beast mode that I am using for the shipped or not beast mode is the following: CASE WHEN TRIM(`order_status`) = 'order shipped' then '1'…
-
Removing sort symbol from graph
Is there any way to remove the sort symbol from view? It can be obstructive when looking at the axis numbers. I can't find anything in 'Chart Properties' to disable it.
-
TOP5
Hey Everyone! I'm here again to use your brains! 😁 Our team is trying to visualize a simple TOP5 of interprise partners considering the total sales of each and we need to see that by month for the past 2 years. We already did this: Beast mode code for ranking: The ranking beast mode is working properly when we use a table…
-
Odd sorting issue when filtering
I have a card that displays the average leads per day of the week. To sort the days of the week in a chronological order I used dayofweek(`date_entered`) beast mode calculation to get the days of the week detail. Unfiltered everything looks good gives the average for each day of the week, Sunday - Monday. Once you filter,…
-
Sorting on both Columns and Rows when using pivot tables
Hello, I'm encountering an issue when trying to sort on both columns and rows in a pivot table. I want my columns to be sorted in date order, left to right - oldest to newest. I want my rows to be sorted in alphabetical order, top to bottom - A to Z. It seems to only apply the first sort in the list and ignore the other.…
-
Ranking x axis by year then month with a series sort by alpha
I am trying to get an x axis to display in date order over multiple years while also sorting by a series. It is not working. I have tried beast mode following several suggestions on dojo, but nothing works.
-
Default is reverse legend on a bar chart
I think it seems a bit odd that the default on a bar chart shows the legend upside down. I realize there is an option to reverse the legend order, but I don't know why the default is to have the legend upside down? My idea is for the legend to follow the same order as the bar chart and you can select to reverse them as…