-
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.…
-
Any way to highlight current date on a line chart?
Ideally, I'd like to have a vertical line to highlight the current date on a line chart that includes past and future dates. Alternatively, a symbol/arrow/circle on the line highlighting the current date would work. I've tried Trellis Categories with no luck. I also don't seem to have the Properties > General > Current…
-
Adding Variance to a card
Hello! I am struggling to find a solution for an issue I am having. Basically we are creating a table that shows a list of metrics with their Actual Value and Budgeted Value, and I want to add the variance. I have the data formatted in two different ways. The screenshot below shows what the data looks like. If I use the…
-
Organize values on X-Axis
Hi All, I am trying to sort my x-axis values on roles (see screenshot attached) not on the default sort options available in Analyzer. I read a previous note from 2017 that told me to use CASE to sort, so I did: CASE split_detail WHEN 'CEO'THEN 1 WHEN 'Head of Business' THEN 2 WHEN 'key management personnel(KMP)' THEN 3…
-
Creating Card filters on values currently absent from a dataset
Hello. I am trying to display a card that shows rows where are particular date column is absent of values. Since null dates cannot be filtered on within cards, I have a Beast Mode formula that does the following: IFNULL(STR_TO_DATE(Target Go-Live Date, '%d/%m/%Y'), 'Blank') I am building out a card (for a Bar Chart, if it…
-
Period over Period question on multiple estimates (budget)
Hi community So I am trying to build a chart where I do have Actual Production by site from 2019-2022 and severall Forecasts for 2023 Full Year One Forecast done in 2022year end) - called 2023B One Forecast done in 2023Mar - Called 2023MYR One Forecast done in 2023Jun - Called 2023LE I wanted to create a chart that…
-
Date Slicer - Years Only
I'm looking to add a Date Filter Chart to my dashboard. I want to use the Slicer, and have one button per year, 2022, 2023, etc. I'm basing this on my record CreatedOn date, but in doing this, it shows me every date that a record was ever created. I've seen the Date Selector Chart Type, but this seems to be a full calendar…
-
Table Chart Average Row
Is it possible to have the last row of a table be the average of all values in the respective column? I see options for Totals & Subtotals, but am not seeing a way to make these an Average instead of a Total. Thanks!
-
How to format regression line label text
By Default, when the slope of a linear regression line is displayed, it is displayed as a number with several decimal places. Is there a way to change the format of this number on the chart? For example, could the number be changed from 10000.00 to 10k?
-
Is there a way to change the text in a legend?
The default text for some period over period charts is misleading. Is there a way to change the text while maintaining the same chart layout?
-
Pie chart in html table
Is it possible to add a pie chart in a column of a HTML 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…