-
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…
-
Is there a way to create a chart that displays the percentage of null values across all datasets?
I want to know the percentage of null values across all datasets that we have, I am not interested in one particular dataset, I want to know the overall percentage.
-
Help with Bar Chart formatting
Hi, Quick question. Im having an issue where every time I remove the 'Series' part of my chart, it adds multiple values on the X axis that are the same. When I add the 'Series' it has two bar charts (Which is what I want) but it doesn't look visually appealing. I want the two normal Bar charts with the total Value (658,739…
-
Is there a way to have pivot tables collapsed by default?
How do I set up a pivot table, so by default the rows are collapsed?
-
What is the best way to present data that has categories and subcategories
Suppose I need to come up with a reporting table, and I have a structure where the main categories are "Mangoes," "Oranges," "Bananas," and "Apples," representing different types of fruits. Within each fruit category, I have subcategories or attributes, which are organized in pairs of columns. These pairs of columns…
-
chart axis issue
Hi I am very new to domo and trying to create a chart where say the data are uploaded to domo with field names on the columns (so "C-3", "C-2", etc are column names) due to general file structure which needs to be like this but then I am facing the issue that then I cannot create a chart like the below in excel where the…
-
Variable connected to a Filter Card
Part 1: I created a variable that allows me to select a different field. I then use this variable in a control on the dashboard. Part 2: I am trying to use the control I created in part 1 to change one filter card that is connected to this variable. The goal is to have one filter card that changes based on the variable…
-
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…
-
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…