Table

Pivot Table showing correct grand totals but not all records
I am counting story points from a jira import, and while all the records are in the base data, when I create a pivot, it shows correct grand totals but skips some records, and fails to do row totals correctly. Even when I remove filters.
Pivot Table summary values
Hi all, I'm very confused about what is going on with my pivot table. The row&column totals are correct but the underlying cell values within the table are only showing a value from one part of the sum instead of the entire sum? What's worse, when I drill down, it shows the correct sum Tried moving to a Mega Table and the…
How do I change the data from being horizontal to vertical using a calculated field?
My data is currently horizontal so each column has a different month with the totals below (example below). I would like the data to be vertical so that it is easier to display the data visually within domo. I have placed an example below. I am not sure how to make a calculated field to display the date and totals…
Maintaining header rows and columns when uploading dataset?
I have a table in excel which has both header columns and header rows. I want to build a dashboard so salespeople can pick which columns they want to display in the table to give to clients. When I upload the dataset to Domo, I select crosstab, but then all of my columns are lost and rows are duplicated for each column. Is…
Heat map tables - Ranges per column
Hi, I have a table with multiple columns and different sets of numeric data and would like each column to have a heat map applied to identify the quintiles. I have tried a heat map table but it seems to apply a single range across all of the columns. Therefore the range spans the columns with the highest values down to the…
Pivot tile returning results slightly less than expected
I have a dataflow with 2 outputs. I branched off some appended data to one dataset, and then I took the same appended data and applied a pivot tile (initially I was joining to achieve the values in columns, but that was coming out way off). The dataset that is taking just the appended data is coming out correct, but the…
Card Type - POP Table
Enable YOY (or other period-over-period calculations) as a table. Example below. This can be done in bar and line charts, for a table one must use a series of beast modes. This also then means you can't use the date filters buttons effectively. Example:
Mandatory Single Select Filter
I made a Pivot Table which needs 3 Single Select filters to be done by the user, otherwise it will be summing the values (which I don't want to happen because it will show the data incorrectly), so the only way to make it completely proof of human errors is making these mandatory, but I can't find this feature. I saw this…
How to Create a Dynamic Period over Period Beast Mode in a Table
I have a table chart that I am trying to show the percent change in sales period over period. An example would be sales grew by 5% in June 2021 vs sales in May 2021. With this, I want to be able to dynamically select a date range to view different periods of time like "previous year" or "last 12 months". Any…
Trying to add percentages in a pivot table
Hi, Would anyone be able to help me with the following: I'd like to have my pivot also show percentages of these two columns, I managed to get it to look like the bottom part however when I add a new column in the pivot it says the processing has not worked. Not sure how to add in the percentage? Thank you!
Seasonality Chart
Hello, I am trying to create a Card that will help with the forecasting. We receive cases (CasesID) by Regions all year, I need to create a Card that will show all the regions and then the month as columns, the values will be all the cases submitted in that month / the total cases submitted from that region. Where I am…
'Incorrect column name' doing a Dynamic Pivot
Hi there! I've been following this tutorial for dynamic pivot and so far it has worked: https://domohelp.domo.com/hc/en-us/articles/360042923454-Dynamic-Pivot. However, I get this error: I thought it was because the name was too long, but the character limit is 1024 and even performing a substring I got the same error. 😓…
CountIf function in Domo
Hello I have a data that contains all the cases submitted and their submission date and in another column it has the approval date which can be in another date/year. I am trying to get the conversion rate (approvals/submissions) for each month, because of the timing they might not happen in the same month. A pivot table…
How to add percentage in the pivot table?
Hi, I'm new to Domo. Is there any way how to add a percentage in the pivot table? So, besides the total, I would also like to know the percentage of each category. Thank you.
is there an easy way to not show zeroes??
I have a table that consists of inputs from 3 different sources. What I am running in to is more of an esthetics issue that I am hoping to clean up. I have areas where a zero appears, and other spots they don't appear. The data are all integers so i understand why there would be zeroes showing but confused why it shows up…
Is possible to use text values in a pivote table?
Hello! I am trying to create a table like this in which the values are a text field. I am using the pivote table that allows me to create the headers the way I want them but I think this type of chart only allows me to use numerical values. Is possible to use text values in a pivote table?
Align headers to bottom
Is there a way to have the column headers positioned at the bottom of their cells?
How to SUM working days correctly?
Hi everyone, I have a strange problem. Probably more of a SQL question than a Domo question, but here we go. I have a typical date column (yyyy-mm-dd) and a column called "total working days in month" where it returns a aggregate value of the # of working days for each month. Below is an example (just assume every date is…
Anything like Difference matrix, Difference between two pivots, difference within the value field?
I've searched around but haven't had any luck finding what I need, but I am not sure if I've searched the best way either so please refer me if this is a duplicate. I'll use dummy data to ask my question, but effectively I need the difference between two values across a couple of dimensions. The goal is different from our…
Beast mode difference shows blank even when using coalesce
@MarkSnodgrass and @GrantSmith, you both helped me with my last question and for the most part, it gets me in the right direction. The problem seems to be that a null value completely nulls the whole result (like in sql), even when using ifnull() or coalesce(), whereas excel does evaluate it correctly, albeit with its own…
Line breaks and special characters are being added to a webform
We use a webform for our Sales roster. We have had an intermittent issue with line breaks and special characters being added to the rep's names which causes quite a few issues. The very first sales rep on the roster is getting a line break added to her name. There's another sales rep getting multiple line breaks and…
How to use a calculated field in a SUM function? (Statistics)
Hello! Please someone help me with this error! 😥 I am creating a table (card) with the mean, variance and standar error of a data column named "Score". The mean is calculated like this and the value is 6.67: If I calculate the variance using the value of the mean it works: That's not the idea cause the mean can change, but…
Can you prevent the MySQL connector from locking its source table while syncing?
I have a large table that takes a while to sync over to Domo through the MySQL connector. I currently schedule the sync to occur overnight because a table lock prevents other users from reading the source table. I would like to sync the table on demand during working hours though. Is there a way to instruct the MySQL…
Dynamic Percentages of Total
Hello! I am trying to get a percentage total column to work within a beast mode calculation in a pivot table card. I'm using the OVER () function, but because I have dynamic date ranges in the table (ex: we're looking at last 30 days only) it seems to aggregate by the grand total instead, not considering date ranges. Is…
Why isn't there a red to green theme for heat maps?
I have a table that I'd like to apply a basic red to green color color theme to. We need to apply this to a column that measures monthly production for reps, sorted highest to lowest. Color rules wouldn't work because their production numbers would increase every day. When I check the heat map color themes all I see are…
Sorting on both Columns and Rows when using pivot tables
Hello, I'm encountering an issue when trying to sort on both columns and rows in a pivot table. I want my columns to be sorted in date order, left to right - oldest to newest. I want my rows to be sorted in alphabetical order, top to bottom - A to Z. It seems to only apply the first sort in the list and ignore the other.…
MySQL Connector to Read Only Some Tables in a Database rather than All Tables in a Database
We are using a MySQL connector to load data from our Google Cloud SQL servers into DOMO. From what I can tell, it is only possible to connect to a Database, and all the tables within that database become accessible via the connector. Any of the tables in our database can be chosen in this window (see the highlighted…
Is it possible to add multiple image tags in a single table cell?
I want both of these images to show AND be clickable in a single HTML Table cell <a href="https://www.walshportal.com/walshintegrated/images/logo-white.png" target="_blank" rel="noopener noreferrer"><img height="20px" src=https://www.walshportal.com/walshintegrated/images/logo-white.png></a> <a…
Pivot Table Summary Number is Blank on Dashboard
We're trying to use a pivot table card within a dashboard, just showing the Summary Number to guide users to expand the card to see all pivot table details. However the Summary Number does not display at all. This is the card value we're trying to show This is the end result within the dashboard, along with the Display…
Table Card - Total to be % calculation rather than SUM, rows by week
Hello, I've attached an excel workbook showing a sample bit in its raw form, what I want to get out of that, and what I am getting. I'm primarily having two issues: Getting everything on 1 row by fiscal week. I can accomplish this until I add a percentage beastmode, then the rows will no longer be condensed to 1 row per…

Upcoming Events

Connections Tour
Spend a half day with your peers, Domo enterprise customer speakers, and product leads to explore real-world use cases and new platform innovations. Whether you’re a power user or just starting to learn about Domo, don’t miss this opportunity to learn from like-minded professionals about how they use data to multiply their…
Connections Tour
Spend a half day with your peers, Domo enterprise customer speakers, and product leads to explore real-world use cases and new platform innovations. Whether you’re a power user or just starting to learn about Domo, don’t miss this opportunity to learn from like-minded professionals about how they use data to multiply their…
Connections Tour
Spend a half day with your peers, Domo enterprise customer speakers, and product leads to explore real-world use cases and new platform innovations. Whether you’re a power user or just starting to learn about Domo, don’t miss this opportunity to learn from like-minded professionals about how they use data to multiply their…
Connections Tour
Spend a half day with your peers, Domo enterprise customer speakers, and product leads to explore real-world use cases and new platform innovations. Whether you’re a power user or just starting to learn about Domo, don’t miss this opportunity to learn from like-minded professionals about how they use data to multiply their…
Connections Tour
Spend a half day with your peers, Domo enterprise customer speakers, and product leads to explore real-world use cases and new platform innovations. Whether you’re a power user or just starting to learn about Domo, don’t miss this opportunity to learn from like-minded professionals about how they use data to multiply their…

Table

Discussion List