-
Solution: Beast Mode & Pivot Table Aggregation Error
Use Case: This chart uses a Beast Mode code for the Rows and Values in a pivot table chart. The results provide an error that is hard to understand without knowing what is causing the issue. Based on the results, we can also see the Cases is not calculating as expected. The dataset only has 5 rows of data. The Rows column…
-
Filter by Section of Dataset (Bonus point question!)
Hi Everyone, this is a bit tricky. There is a need to have an aggregate table that shows counts, sums, and averages for different sections of the same data set. But subsets of these sections are defined by matching filters on the dashboard. I know that doesn't make much sense, so here is an example of a simple table.…
-
Sankey & Sankey Path Data Structure
Hi all, I am building a sankey chart to show the flow of transactions. Ideally I would like to use the Sankey Path visualisation. My data is structured with column names: from, from_type, to, to_type, value There are 4 stages to the flow. I would like to be able to filter the visualisation to show the flow for certain…
-
Extra padding/Margin
Hello, I wonder if anyone knows how to remove the extra spaces (red ring) in the screenshot below. I am trying to combine my data table (yellow ring) with the header (green ring), but there are always extra spaces between them. Thank you. Best, Anna
-
STR_TO_DATE
Hi everyone, I am facing a problem of transforming Text to Date type. I have a column called Date. The format looks like this: I used the following formula to transfer it to Date formate" STR_TO_DATE('Date','%d-%b-%y') but the following error message popped up. Could you please tell me what's wrong with my formula? Thank…
-
Route Map Edge Case: Ability to remove lines between points while still retaining Point 1/Point 2
Hello! I have an edge case on a map I'm creating. The Lat/Long Route Map I saw seemed perfect for the customer I building this for, but then they provided feedback saying they want the symbols/dots but they do not want the lines going between the dots. I do not believe there is an ability to remove the lines/routes between…
-
Beast Mode calculation when data is in rows and then how to chart
Hi All I have a dataset (a sample is attached) where the 2 series I want to track are in the same column, identified by the Split Answer (i.e. male or female). I want to calculate the % split answer value by dividing the value by the sum of all values where the Split Detail is held constant (i.e. what is the % of female…
-
Bar chart projection feature
Hi everyone, I am using grouped bar chart to present actual and budget financial data and try to project the next 3 month's data. Please see the following chart as an example. I have the following question: Why it only projected Actual data but not budget data. The following is my multi-period projection properties if it…
-
Show the greatest value of a day for every week
Hey community . I need to show a graph(week by week) showing only the day with the greatest value of sold items for each week, I have been trying partitions, but it seems it's not getting the correct data
-
Choosing the right chart
Hi! I'm working on charting data and want to understand if there's a simple way to find the correct Chart object to meet the needs of the requestor. The requirement is to have 3 data points show up as lines and 3 show up as bars. I'm struggling to find the correct Chart type that will accommodate the request. Any…
-
Paging in a Table Card
Hi there, I was reading a closed forum question that suggested an answer that may no longer be true at this date. Original Question: I have a Mega Table with about 600 rows. I don't want to show all 600 at the Dashboard level, even with the scrolling aspect. I'm concerned that it will affect the Dashboard Performance. The…
-
Projected monthly total based on current progress in current month
Is there a way to project the month-end value based on the current month's progress in a bar chart? So if there are 10 days of data totaling 1M widgets during September (9/1-10), it will project 3M widgets for the current month (1M will be solid and 2M will be striped to signify striped). I see a whole bunch of options in…
-
Understanding Gantt Chart Dates, and Date Filters
I'm struggling with this more than I think I should be, but as always, I probably need an ELI5 version :) I have a Gantt chart where my Start/End Date is my Project Start/End Date. My first question is simple; how do I have my Gantt chart start at today, regardless of what the Start date is? I want today to the last end…
-
Issues with Hovering for Plots Once It is Embedded
Hello, I created a hovering feature for one of the plots with linebreaks via a beastmode. The hovering works fine within the Analyzer feature but once I try to embed the card, the linebreaks are removed and I see the '\n' that indicates where I placed the linebreaks. Is this a common embed problem and if so, how can I move…
-
Charting
I am new to Domo and busy learning Analyzer. I'd like to know how to convert a bar chart (with two variables) into a line chart with percentages, so if you have a column with 75 Male General Managers and 50 Female General Managers, another column with 100 Male Executives and 50 Female Executives, and a final column with 65…
-
ARR Between Two Date Columns (Sub Start and End Dates)
I have three columns… Subscription Start Date Subscription End Date Subscription ARR Subscriptions are typically one year but not always. I want to chart ARR by month which is defined as the sum of all of the ARR for subscriptions active for each month. X-Axis = Months ←- Not sure how to do this because if I pick Sub Start…
-
How do I get percent of total on pie chart?
How do I get the percent of total on a pie chart? I added pie name and pie value, then change the pie value format to a percent. Rather than giving me a percent of a total, it is giving me the percent. For example, one of my numbers is 799. When I change the format to a percent, I get 79,900%. What am I doing wrong?
-
Comparing YOY trend lines
I'm struggling with building a chart to show YOY trends. I was able to use a combination of the following beastmodes to create the following chart from a dataset containing a small amount of data. But when I attempt to do this with a large dataset, it doesn't work (I'm wondering if it just requires too much processing).…
-
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…