-
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!
-
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…
-
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…
-
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…