-
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…
-
Stacked Grouped bar chart
Hello! I have 5 columns in my dataset for 'province', 'city', 'A', 'B', and 'C'. I need a stacked-grouped bar chart such that the x-axis shows the province, for each province we have a category of 3 grouped bars for columns A, B, C and in each bar we have the cities by different colors. Could you please guide me with that?…
-
Goal Met Percent
Hello all! I am trying to create a beast mode that shows a % for those that have met the goal. The goal does change month to month. There is a separate beast mode set up for those that have not met the goal/goal has been met. Thank you
-
Tool Tips
Hi, I am trying to use tooltips for the first time so that I can add it to the data label on my bar chart. I know when you use a pivot table you have options to do % of subtotal for certain columns. Is there a way to do that in the tool tip field?
-
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.
-
How can I center all text in a DOMO table, regardless of whether it is a string or number?
Hi! I am having trouble centering the text in DOMO table, and can only do a center alignment for header rows. Is it possible to center the text as well? Thanks! Patrick
-
Exporting as .xlsx is exporting a 0 KB file when it worked for this card before?
We've got a card that is essentially a transposed Excel table. Employees have been able to export this card as .xlsx before with no issue. However, now Domo is exporting a 0 KB .xlsx file that when attempting to open, Excel says it is corrupted or an invalid file format. I can export the dataset powering the card just…
-
How to Create WTD, MTD, QTD, YTD on one Chart
I received a request to create a chart to show KPI with WTD … YTD on a single chart. Image below is the example: The Closest I've gotten is; I created a dimeson that flags the 'WTD' dates as a Y/N, then created a beast mode doing a case statement for when the Date flags are 'Y.' I've done the same for the other KPI, but it…
-
Report for Dataset using Big Query
Good Morning, not sure if this is possible, but I want to pull a report for all datasets that use a specific data source, in this case Big Query, is that passible?
-
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…
-
Bucket Ordering
Hi, I am working with pricing buckets of home loans. I have created two case statements. One that puts each loan id into a piricing bucket based on the loan amount. the second is to order those buckets in what would be numerical order. I am getting a graph that, when the bucket order is being applied, doesnt want to bucket…
-
Beast Mode to null out values
Why is this SQL code throwing an error associated with the NULL? CASE WHEN `hire_year` = ‘2022’ THEN `percent_value` WHEN `hire_year` != ‘2022’ THEN NULL END
-
Text Labels
How do I make value labels appear on a single line on a multiple line, line graph?
-
Load Domo Bricks Form with values from Existing Dataset
Hello, I'd like to load a domo bricks form with data from an existing domo data set. I see I can use the domo.get method: domo .get('data/v1/sales') I expected the string value to be a domo data set id, but from reading it seems I need to set up a manifest.json file to map each dataset to a convenient name. Where do I set…
-
Creating a visual with the Map
Hi, I have the lat, long of both the shipper and the destination city however, when I go to the map visualization I only see the option to put state name and state value. Am I using the wrong map? I ideally want t Thank you in Advance.
-
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.
-
Drill Path - ignoring of certain filters
Hi All i have a card which shows by employee actual % vs Target and the variance YTD (see below) i have added a quick filter to the card so a user can filter on employees who have a variance over a certain % so they can focus on the main drivers i then wanted a drill path to show the trend by (actual vs target) by month…
-
multi value gauge
I am trying to create a YoY summary, here is my data When I select compare to 1 year ago I get an error. What do I need to change ?
-
Aggregating Numeric Column in a Line Graph over time based on a Different String Column
Hello, this is a continuation of I was wondering how I can show in a line graph for the MAX,MIN, and AVG of a column that is fixed on a different column. More specifically, I want to find the MAX, MIN, and AVG of a 'Completion Percentage' column based on a 'Group_1' column; meaning that I want to show the maximum of the…
-
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
-
Pivot Table - Blank Column To Segment Data
Hi All i currently have a pivot on my dashboard with quite a lot of columns, to help users visually i wanted to segment slightly my thinking was to create a blank beast mode and add to where i wanted a break however it counts the rows does anyone know of a workaround? or another possible solution See below example (yellow…
-
Chart issue with line bar chart: line is showing up as dots
Hi - I am trying display a line bar chart combo but the line is displaying as dots and I want it to show up as a line. The dates for the line are at a lower frequency / longer duration (yearly) than the bar (monthly). Thanks for all the assistance.
-
Displaying Zero Hires by Month for Different Segments in Line Charts
I want to display the total number of hires (on the y-axis) over time, organized by months (on the x-axis), and Segments X,Y,Z (In series)using a line chart. However, there are months when no hires occurred for a specific segment, and in those cases, I want to show zero on the chart instead of having it remain empty. How…
-
Is there a way to create cross-dataset filters on a page?
I'm using three datasets to drive the content of different cards on a page. Although I've implemented global filters on the page, it appears that these filters are dataset-specific. As a result, I'm required to switch datasets each time to filter the cards associated with it. Notably, the fields I'm filtering on are…
-
Text box is not populated by Beast Mode
So, I have a beast mode that generates a text block with some basic information about a helpdesk ticket dataset. Its purpose is just to let the user know how recent the data they're seeing is. In short, it tells (1) when the ETL was last run, and (2) the most recent ticket ID and date. Simple enough, I'd think. If I add…
-
How can I embed a website into my DOMO Dashboard? Not a hiperlink to open a new tab.
I would love to add additional resources right into my DOMO Dashboard by embedding a website into it. Any thoughts on how to do that? Would it be possible to write a custom app to allow for that?
-
Dynamic Y axis
Hi, I am just wondering if its possible to create a chart where the y axis is dynamic. For example If I have a min of 200 and a max of 300 for one product and then another product has a min of 700 and a max of 1000 is it possible to get the y axis to be 80% of the min and 120% of the max of these two? Hopefully that makes…
-
Why is my beastmode to bring in Salesforce Profile Photos not working?
I'm using the html code referenced in this Domo Article: Our salesforce rep profile photos are being brought in as a url starting with "https" into a user dataset. I'm just not understanding what is wrong with the beastmode that it's not bring up the photo when I place the beastmode as a column on a table: CONCAT('<img…
-
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.
-
Draw a Line Through Scatterplot
I would like to draw a line through the scatterplot visual. Ideally, I would be able to specify the Y intercept and slope of the line.
-
Rating Card
Anyone have any idea or work around to show ratings besides just table or bar chart? I have a survey where people rated items 1-5 stars. I would like to show that in a format like this based on responses.