-
How can I sort the legend values in a Pie Chart
Is it possible to sort the order of the values in the legend in a Pie Chart? I'd like to sort this to read: * High Engagement * Medium Engagement * Low Engagement * Not Engaged But by default I am getting this:
-
Is it possible to set Quick Filters to default to appearing collapsed rather than expanded?
Really like the addition of Quick Filters as an option, but wonder if it is possible to have them default to being collapsed. We have a couple of cards where it will be beneficial to provde a couple of options for QF's. Having them initially appear collapsed would give us a cleaner look, yet still enable ready access to…
-
How to add Multiple Targets in one chart?
Is there a way to have multiple targets on one chart? For example, I have a stacked bar chart with multiple regions, and each region has a different target. I am able to set one goal line in the chart, but is there a way to set different targets for each region?
-
Color setting on lollipop graphs
Hi All Why is it that when i try to set color rules on my lollipop graph no matter what values i put in as the rule it still displays the one color? I set red for <= 80 and green for >=81. The value is a percentage based on a beast mode calculation. Any help appreciated! Cheers Paolo
-
Add field/dimension not yet available in a dataset
I hope this doesn't sound like a stupid question, because we understand WHY it's happening, but it's something we've struggled with for some time now when trying to keep filters updated and cards accurate - it's been a very painful, time-consuming manual process thus far. So, we add a dataset & card, and set filters for…
-
Table Subtotal Sorting
On the table card, once you've enabled "Show Subtotal Rows", has anyone else encountered issues with it forcing the first row to be the primary field? I've got a few cards where the first row is a formatted date (or some other non-numeric value) that looks like "January 2018" for several months. I love the ability to be…
-
radial chart max value
It's my first time to create a card using a radial chart type and I am having a hard time setting up the maximum value at 100%. It keeps on showing '10K%' as the max value. See attached file, I am trying to create card that will monitor our net promoter score so I created this beastmde: (SUM( (CASE WHEN `4. B` >= 9 THEN 1…
-
Why do some cards have different summary number rules?
Hi everyone. I'm sure I'm overlooking something easy here, but why are summary number fields/options/functionality different by the card? For example, if you use a Progress Bar card, and you use a Beast Mode calc that has HTML/Text/Numbers in it...and it shows up in your Dimensions section it does not show up as a summary…
-
Is there any way to display entire regions, rather than just individual countries?
So I'm trying to display metrics from our global subscription regions (the Americas, Europe/Middle East/Africa, Australia/the Pacific, etc.) as a whole rather than the specific countries that make them up. I tried using the lat/long map and plot point roughly in the middle of each one, but the dots were pretty small, even…
-
Data Labels on Charts
Hi, If you have a chart that is based on percentages (e.g. 100% stacked bar chart), is there also a way to also add the count or absolute number? For example, if a data point is 80%, can we also add the number that is based on, so it could look something like 80% (30)
-
Gradient Conditional Formatting
Is there a way to do conditional formatting with colors based ont the other values in the column? Excel has an easy way to do this with one click.
-
Stacking bars, but not as sum of series + sum of series (on top of one another)
Hey there. I've been researching to try and find a way to have the bars "stack up" to be "Parts of a whole (amount)", not sum of Series 1 PLUS (+) sum or Series 2. For example, please see screen shot "Example of what tryingt to achieve": In this example (taken from a PPT slide), you'll notice on the Legend that the…
-
Coloring fields in data chart table
Is there any way where i can do like if column A value matches column B value then make that column A value color red. Thanks in advance.
-
Inherited Color Rules
I have a problem with inherited color rules. I made a card with scale marker on $100k and set up colors for values over $100k to green and values under $100k to red. After that, I made a drill and tried to set up colors for bars in drill card, but those bars keep showing in red, because a values are less than $100k and I…
-
conditional formatting color based upon another field value
I have a Symbol + Grouped Bar chart that I would like to use conditional colors. X Axis is Customer Y Axis is (Max)Goal Series is (Avg) PercentOnTime I would like to do the following: If (Series) PercentOnTime >= (Y Axis) Goal = (Series) Green If (Series) PercentOnTime < (Y Axis) Goal = (Series) Red Any help would be…
-
Quick Filter to Change Value in a Chart
Does anyone know if its possible to have a Quick Filter change the value column of a chart? Example: If I have a card built showing sales dollars by region for the year, and the user wants to see margins instead, is there a quick filter type option that could change out the Y Values so we wouldn't have to change/create…
-
Missing City Names on United States map type
We have several maps using the United States map type that have drill downs that went US->State->Counties->Zip After this January update, we've encountered some issues. When drilling down into the states, previously several major cities in that state would show up, overlaying the counties. (ie, if I clicked on Texas, I…
-
Sort by Last Column in card (heatmap)
I feel like this one is an easy one but I just can't think for the moment. I have a heatmap that shows data over time. I want to sort so that the highest number for the current (or last month of data) is descending from the top. If I do a normal sort it puts the first month in descending order, I just want it to be for the…
-
table labels mixup
The table card seems to be mixing up my labels after I apply them and change order of the columns. To reproduce: create a table visualization, apply a label to each column and reorder the columns
-
Is there any way to add a large number of items to a Card Filter all at once?
I regularly need to filter a large dataset (7000+ rows) by selecting 50-100 of the specific items in the column I've selected. Unfortunately, it is cumbersome and time consuming to find them one by one from the full list, or to copy/paste each of them individually into the filter search box. Is there any way to dump a…
-
Variation on adding Multiple Targets in a chart?
Saw a great hack in How to add Multiple Targets in one chart? (https://dojo.domo.com/t5/Card-Building/How-to-add-Multiple-Targets-in-one-chart/td-p/2634); it was really quite helpful, already found use for it on a couple cards so thank you! That said, wasn't sure if I should open a new thread since my question was directly…
-
Is there a way to create a URL to a page adding a custom page filter
I would like to create a link to a Domo page (in a card) that would be filtered based on the value clicked. Much like the link from Salesforce data into SalesForce, I want to be able to click through the sales data down to a specific customer, then click that customer and have it take me to a page that is the customer…
-
Changing the font type
Hi, I am looking to change the font type from the default setting to Arial but cannot see any option to do this. Can someone tell me whether this functionality is available, and if so, where? Many thanks.
-
synchronize axis
Is there a way to synchronize both vertical axis on a Symbol & Stacked Bar Chart? This way it will allow the axis' to adjust when a fitler is applied and maintain the proper scale. Does anybody have a way of doing this?
-
Is there a way to change the labels in a legend?
Our different data sources don't always use identical column/field names. For example: AssemblyHour AssemblyHours On a chart type that displays a legend, like a bar chart, the label that appears is drawn from the measure's name. Is there a way to override this? Then we could, for example, make very instance of similar…
-
Displaying what controls bubble size on a bubble chart
I love bubble charts. People may need them explained once or twice, but then bubbles are just so great at packing interesting information into a big space. I've had a look, and I think I'm missing something obvious: How do you label what's controlling the bubble size? It's critical to know this when you're trying to…
-
Pie Chart Sorting?
I have a set of categories that I would like to display in a specific order in a pie chart, but no matter what I do the pie slices are always ordered by biggest slice to smallest slice. I have tried writing a variety of beast mode sort calculations to address this but nothing happens when I apply the sort. Am I missing…
-
Remove time stamp from date format
Hello, If I have a date format that includes month, day, year, hour, minute, second, as follows: 21-Apr-16 1:53:46 What is the Date_Format in Beast Mode to only get the "Mon, Day, Year"? Thank you.
-
Sort Table by Field Count
This one really has me stumped. Please look at the screen shots below. In one card I was somehow able to get the sort to read 'Count of [Field Name]' but in the other, it attempts to sort by the value of that field. I cannot figure out how I was able to get the highlighted aggregation option in my Text sort.
-
Word Cloud - Larger Name for smallest number
I have some data for a call center and I would like to display names in a world cloud for those who have the best handle time, the lower the handle time the better. Is there a way to reverse the standard, larger value = larger name?