-
Quarter by Quarter comparison
Hi All, I am trying to have analyzer display the percentage change from 3rd quarter of each year to 4th quarter of each year. Currently my graph looks like this but I am unsure how to get the graph to display it I have tried to format using a period over period chart but cannot figure out how to only show 3rd quarter to…
-
Can I filter just one column in a table without filtering the others?
Hi, I have a table like this I would like to create a table in Domo like this: Region | Sales HC | Engineering HC And then add filters like this Sales HC Stage: - Ramped - Un-ramped Engineering HC Stage: - Ramped - Un-ramped and when filtering for 'Sales HC Stage' ramped & un-ramped and 'Engineering HC Stage' ramped, it…
-
Is there a way to control the colors in a Lat/long map for a series of values?
I can see that there is a 'Series for Color' option available, but setting the Symbol Color only allows the specification of one colour, not one colour per series value. Am I missing something? I would like to be able to control the colour in order to maintain visual alignment with the colours used on other cards - i.e. I…
-
How to hide Pie Chart total and include % in the data label
Hi - see attached. HOw do I hide the "Total 890" to the right of the pie chart? And, ho do I include the % value in the label? Thanks Ben
-
Custom / Manual Sort Order
Is it possible to have a custom sort order on a chart when none of my attributes provides the sort order I want? Or alternatively, I know I could force the custom sort order I want with an alias in a beast mode, but then could I change the bar labels to what they were originally?
-
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…
-
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?