-
Trying to create visuals like PBI in DOMO
Hello, I am in the process of exploring Domo visuals and charting. I am familiar with other visualization tools but want to see how I can do the same on Domo. Can someone guide me in achieving the visual I have created earlier on other tool. Motto is to see, How I can achieve it. What are the major differences I benefit…
-
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…
-
Download Line chart forecast values as an excel or csv
Currently, when I create a line chart forecasting values into the future, I am able to see these values okay on a chart. However, when I try to export the chart in excel/ csv format, the future dates disappear and I can only see the actual values corresponding to historical dates. Will it be possible to download this as an…
-
Heat map totals to use AVERAGE instead of SUM
Hi folks. I have a heatmap with the values as averages of values within the data. I've asked domo to add a 'Total Row' and a 'Total Column' (red outline below) but rather than these also being averages - domo is totalling the rows/columns. I need them as averages. Any ideas? Thanks
-
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…
-
How to change color of bar charts (top 5)
Hello. Can someone help me if there's a way to use a different color to indicate the top 5 items in the bar chart dynamically?
-
Calculated line on Bar Chart not the same as Summary Average
I am trying to figure out why the calculated line for a bar chart I am creating is different the the Summary Average of the same metric. Is this a rounding issue or something else? Thanks in advance.
-
Can I show 2 values as a stacked bar and other values as single bars?
I've been asked to create a bar chart that shows 4 values: Prior Year, Actual, Forecasted, and Goal. The request is that the Actual and Forecasted amounts would stack on top of each other for easier comparison but I'm struggling to find a chart type that will support this. I looked into the Grouped & Stacked bar chart…
-
Show Column Description on Column Hover in Table Cards
As a way of shortcutting a data dictionary card - it would be very useful if you could hover over a column title and have the column description show as hover text. Or even have the ability to add custom hover text to each column via the card editor here.
-
Updating Color Rules on Symbol Line Chart
Hello, I am trying to do exactly as was asked in this forum question below. The only difference is that I have multiple lines and many timestamps on the x-axis. Given that this question was asked a bit more than 3 years ago, is there a better way of doing this?
-
Displaying up and down periods over time in a chart
We are tracking internet down time at our stores. Basically every 15 minutes we receive a list of all stores that are currently up. I then process that and for every store that was missing in the list I store a record in a dataset with the store and a timestamp. We need to show over a 24 hour time period what stores were…
-
Conditionally formatting colors of horizontal bar chart for over/under budget
I am trying to figure out how to conditionally format my "Actual" sales either green/red for over/under "Budget" by location. Is this possible? I know this may have to be done with a beast mode (unsuccessful so far) as it cannot be done in chart properties.
-
Table Total Row and Beast mode Aggregation
Hi experts, I'm tying to build a table of consumption by subtracting a total on different days. I'm using the lead to get the next value and subtracting the current one: When I able the total row option an error occurs: My first question is why is it happening? My second question is why doesn't the bar chart aggregate the…
-
Built in data table functionality & arrows
Hey guys. Weird ask here. Boss is wondering if I can make a visual that gets rid of the light blue bar (Revenue) but keep it in the data table below. Reason being is so I can have two scales for the values instead of the three, which is why the scale for the light grey bar is messed up. She is also asking for up and down…
-
is there a way to create a bar inside bar chart (similar to nested bar chart)?
Hello everyone, I'm new to Domo and currently exploring ways to create a nested bar chart, as illustrated in the example below. I've experimented with a few options, but haven't been successful so far. I would greatly appreciate your insights and comments on this matter. Thank you!
-
Why doesn't my line + bar chart show the "Show data label on" option?
I want to display data label only for the line but the option is off.
-
create a card to display a number ranking
can anyone point me in the right direction on how to create a card with a number ranking that will auto update? we give the sales people a score based on their activities. the one card will put them in order based off their activity score total. how do I create a separate card to just populate their Activity Score Rank?…
-
Bullet Chart - removing labels of Ranges
Hi all, I've been trying to find a way to show the RAG ranges of acceptability on a graphic I'm currently working on; the bullet chart has been an excellent find, however, I want to display the "actual value" as a data label, but I really want to avoid having the data labels of my Ranges present. Is there a way to do this…
-
How to recreate this visual in DOMO?
I have all the data needed to make something like this, I just haven't found a setting or chart type to make this. The problem is getting the table to be multi-tiered with column headers able to stack under like in the image. Just wondering if anyone has any idea or knows of a chart type, brick, etc to help me achieve this.
-
Broken line chart and want to connect the dots
Hi - I have this beast mode that I am using in a bar line chart. However since there aren't values for each time interval the line is showing as dots. How do I get the line to connect? Here is the beast mode and I can't seem to get things connected without breaking syntax: CASE WHEN 'id'='LIABILITY' THEN SUM('value') END
-
Group by N Weeks option to graphs
Hi all, Recently, we have been building a lot of graphics for Agile Sprint Planning. One thing that has been quite frustrating is the lack of customisation when grouping by date objects. It would be brilliant if the option to group by "N" weeks, instead of grouping by weeks or grouping by months as our Scrum Teams work in…
-
Specific Customisation options for 0 in Multi-Value Column
Hi all, On value cards that have a change value - it is difficult to control how the change value interprets the value when it is 0. It would be great to have specific colour/formatting options when a change value is 0 (including the ability to remove the directional indicator). Ref to post highlighting issue in more…
-
Unsync Scale for One Series in a Multi-Line Chart
Hi Domo, I would like to have one of my series plotted on an alternative Y- axis so that the variation can be seen alongside the values with higher magnitude.
-
Ability to color code the "Other" Category for Pie and Donut Charts
Somewhere in the settings for pie and donut charts it would be great to be able to hard-code a color for the "Other" category that gets created when there are many items in the series. We have a lot of color rules setup for various fields and it is annoying/hard to read pie charts when the "Other" category's color keeps…
-
Adding new brand colors in brand kit
I need to add brand colors but many client dashboards have already been crated using existing colors. If I add a new hex color that is already selected, will it have any impact on the colors of the existing cards?
-
How can I make a series of goals on a stacked chart?
Hello! I am trying to make a chart look like this: I have a data set that has goals and I want the series to be the goal milestones and the filled in line to be an operators total sales. I am unsure if there is a chart that can do this or I have a workaround because there are very many goals. My data set looks like this: I…
-
Need to have a feature to select week start day starting from Monday.
Hi, Can we have a features to select week start day starting from Monday in all types of charts specifically for Bar charts and Multi Value charts. We have this feature in Calender chart.
-
Reverse the inclusivity of 0 in Multi-Value Column for Value changes
Hi all, I might be being daft here, so I am raising a question before raising an idea in case anyone knows of a workaround to my problem. I'm looking to use a value change graphic to show the changes in the number of risks on projects. As a result of this, an increase is "bad", but a decrease or consistent value (0) is…
-
Add a condition on line plot to toggle between AVG and SUM conditions
Hi, I have a column in my data 'Volumes' and I am using that as Y-axis of line chart which is currently set to aggregate as SUM(Volumes). I have a problem with it where I want it to perform AVG(Volumes) when one condition is met and perform SUM rest of the times. I am trying to perform this logic using calculated field,…
-
Drill down options from line chart
The drill down option from a line chart with the X axis as a date field is to click in the dot correspondent to the date. Would be nice to be able to click on the entire line to activate the drilldown, with only one filter resulting from the selection.