-
How to display inventory total value over the past 5 days
I'm looking to show how the total value of our inventory has changed over the past 5 days. Ideally it would be a bar graph showing the rise and fall of inventory value depending on what's been sold/purchased over the past week. I believe I have all the data I need in Domo, I just need to figure out how to create the card.
-
Heatmap Hover Character Limit
Have a customer that is working with heatmaps and noticed that when he increased the characters in the hover the information disappeared. They wanted to know if there is a character limit that is inplace for the hover picture and if there is a path forward they should take to include more information. Thanks!
-
In App Editable Data and Real-Time Visualizations
Hi Everyone, If users wanted to be able to edit the data that goes into a visualization, and then see how that edit impacted a visualization (and all of it's great metrics), what would be the idea way to do this in Domo? I was thinking that you could use a Domo Webform to let users plug in new data/edit data, and then use…
-
Trimming Pivot Table to Only Display Items with Top Totals
Hey there forum community. Using the Pivot Table in domo and trying to trim the rows to only display the top "X" of them to cut out a lot of the noise of low value items. Wasn't able to find anything online. In excel pivot would be a simple filter. Andy
-
IncreasingTooltip Fields Number
I was wondering if there was a way to show more hovering options in a heatmap than the below Replacement Macros. I am trying to show more field values when I am hovering and I ran out based on the options available. In essence, I am trying to find a way to increase the number of Tooltip Fields available so that I can…
-
Select all/none with a filter card
I am building a domo embed/everywhere page and want to have the ability to filter by country/countries across all cards. I have tried using the differnet Filter cards and teh most suitable seems to be the 'Checkbox Selector' however this does not appear to have a select all/none option whic make the filter extremely…
-
Charts with multiple columns on X axis
I want to create a chart in DOMO with multiple columns on X axis in the below way? How can this be done? I tried to add multiple columns on the X axis but it doesn't take.
-
Scatter Plot with a dynamic x-axis scale marker?
Hi, I am using this nice feature that allows me to mark the average (median, etc) value on the y-axis, that would also adjust dynamically. However, it doesn't seem it is possible to do so for the x axis. you can set one manually using quadrant lines, but that would require manual adjustment every other day. Any ideas?
-
Creating a Word Cloud chart from columns with phrases
Hi, I'm new to DOMO so would appreciate some advice on the following issue. I'm trying to create a Word Cloud chart from columns with phrases. I followed instructions from Word Cloud Chart – Domo but when i get to step 7: Copy and paste the content from the following SQL file into the new transform: call transform_2.sql I…
-
Visualizing Linear Regression Confidence Intervals in Domo
Is there a way to visualize confidence intervals from Domo's built in predictive models. Do I need to create a new formula for each one and use a multi-line chart?
-
Multiple Values in a Pie Chart
How can I get two columns to display in a pie chart value? My assumption is Beast Mode but I am unsure of how that would be done. For example, if I have a Maintenance Column and a Disruption Column how would I combine those into one function so it can be displayed?
-
Power Point Plug in
I am using the new Powerpoint plug in. I can import cards, click refresh and select a filter and the filter will work. I can even create a second filter and then toggle back and forth. As long as I have not save the powerpoint this all works. As soon as I save the powerpoint, the powerpoint will say there is no DOMO…
-
Legend in Pie Charts
Hi, It seems that something recently changed so my pie charts are displaying the total on the side and in the summary number as well. The graph on the left is how I am trying to get it to look but I cannot figure out why the graphs on the right are showing the total in the chart. Was this a recent change? Any suggestions…
-
filter issues
I'm having some odd issue with one of my filters and how a table somehow gets unsorted by it. I have a table which I want sorted by "preferred URL" and then sum of "monthly page views". Without any filters applied on my dashboard, this table is properly sorted. Then when I apply a filter (CMS), it suddenly turns my sorting…
-
Supress Zero Value rows in Pivot table
Hi, Do we have an option to suppress complete zero value rows from pivot table. Thanks
-
Can I make a grouped bar chart with 2 series/categories?
Hello! I am currently trying to make a grouped bar chart that is also stacked. In this scenario I want to compare our power and core members and within those groups how many of each are a website client with us. If they are a website client, I want that bar to be stacked to show what type of website that member has. This…
-
how to build a line and stacked bar chart
I want to build a Line + Stacked bar chart, but am struggling with this. I've got the bars (clicks) and the line (CTR) created. But I want to break up the bars into a stacked bar based on a field (site). I would normally put the site field in the series option - but I have to place the clicks there in order for it to…
-
Is it possible to implement a secondary progress bar to show a comparison of values?
I'm currently setting up a pacing progress bar showing % of the performance compared to our goal for the year. I received a request to add a secondary bar or point on the bar to see where we should be on that date if we want to reach our goal. Is this something that is possible to implement? The red would increase each day…
-
drop down selector chart
Hi, I am using the dropdown selector in a card. I added a filter, searched for a name, and hit apply. However, the name is not showing up under the dropdown menu. Can someone please advise why this is happening? Thanks.
-
Julian Date
Hi Experts, I have connected to one database and I am getting date in Julian format. How can I convert them into normal date? Thanks, Ajeet Mahajan
-
Domo Charts - 2 Xs (secondary) with Data Values
Does DOMO have a chart feature to make a similar chart as attached picture? Looking to have a Month with Quarter divider and below Quarter have the data values with bar chart above.
-
Name of Previous Month instead of Previous Month in Card Title Smart Text
Is there a way to have the Title dynamically say "July" (or whatever the previous Calendar month was) instead of "Previous Month"
-
Null Date Values in Card Filters
Hi! I know this question has been asked a few times in the forums over the years (see "Best Practice for Date fields" and "How do you Filter on Date that is Null") so apologies for the redundancy. I'm asking the question again because these posts seem to miss an element that is crucial to my use case: calculations and…
-
Can I omit certain values on line graph from being calculated in avg line?
I have an interesting case here, I have a cost per lead value being graphed by week for the past 9 weeks. Only problem is that when there are no leads the value is blank and the line breaks. I can fix the problem by using a beast mode to say when there are no leads to just zero out the Cost per Lead value. When I do that,…
-
dynamic rank/ordering for Beastmode
Is there a way to create a dynamic column via Beastmode that will rank the rows (1, 2, 3, etc...) based on the filtering and sorting for a table card? So however you filter and sort your table, there will be a rank column that adjusts so you can see the ranked order?
-
Display active filters in excel/csv export
Hi, when you apply filters to a dashboard and export as PDF/PPT, the selected filters will be displayed on the export. Is there any way to do this for exporting as excel/csv? For example I have a table that I filter by date using a calendar filter card. When I export the table I'd like a cell, header, or tab name to…
-
Calculating Percent Change in a Pivot Table
My goal is to have the variance shown as a percent change from Last Year's Revenue in the pivot table. Is there a way to do this?
-
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.
-
Question on breakeven formula
I am trying to think of a way to structure a formula to calculate days to breakeven when the initial item fixed cost has multiple sales tied it. I made a quick excel chart to demonstrate what l I am trying to accomplish where the initial item cost of $1000 took 6 days to breakeven.
-
Is there a way to count all views of a card, including dashboard views?
I noticed that the Domo activity log counts card views only as direct interactions on the card. It does not include views through dashboards (pages). I figured out a way of joining activity log data and Data governance data to get the complete count I want, but is there a more straightforward way? Perhaps a category in the…