-
How to compare Value Columns
Hi, Beginner to DOMO so excuse the question. I've created a Pivot table with 2022 sales vs 2023 preorder sales by account and would like to add in a % difference column at the end that shows whether an account is up or down for 2023. How do i go about adding that?
-
Table Cards - clicking and drilling on selected columns/rows gives wrong drill filter
Any time I use a Table Card in a drill layer (and even top level i spose) - the user can click on any of the data in the rows. For example, I may have a column that does a count Count of service requests. on a table chart that lists all properties and their respective service request counts When the user clicks on that…
-
PLEASE stop tables from auto-expanding when new items are added
It's messy, frustrating, and it makes us look like we're not maintaining these cards or pages properly. It's also difficult for end users to use when we have large tables, as they have to collapse every item (every time) they use it. If it's saved with certain columns collapsed, it really needs to stay that way. A…
-
Domo Governance - Chart Types
It would be helpful to see the Chart Type in our Governance Datasets. Right now I think we can just see if it is a Textbox or a Chart. It would be very valuable to be able to tag if it is a Table Card. I would like to add dynamic glossaries at the top of each dashboard to have hyperlinks to each table card on the page for…
-
"The Pivot Table is Only Showing Part of the Data" Error
In our KPI cards using pivot tables, I keep getting the following error. ”This pivot table is only showing part of the data. The visible rows and/or columns are incomplete.” There doesn't seem to be anything wrong with the DataSet, and I have not been able to identify the cause. Has anyone else had a similar error?
-
Issue in creating pivot table
-
How do I get my subtotal and total rows in Table card to show the avg of % rather than the sum of %?
For the column of my table that's using percentages, I'm getting these percentages through a beast mode: count(`Opportunity.CreatedDate`) / (case when `Team Months Active` <= 1 then 40 when `Team Months Active` = 2 then 80 when `Team Months Active` = 3 then 120 else 160 end) For some reason, the Total and Subtotal rows of…
-
Calculating percentage corresponding to blank cells
Hi all, I want to calculate percentage of the events count in my dataset like below Here, we can say for the month of August, there are 67 events with flag=true. Hence, we can see 100% displayed next to it. Similarly, for the month of September, there are 3 Outcome2 events with flag=true. And the percentage comes out to be…
-
Filling blank cells with 0
Hi Team, I've recently started domo to build reports and I'm trying to fill 0 in below blank cells in one of my reports. The thing is, in my dataset there's no data for August month for the highlighted rows. I believe that's why I see blank in Domo. Till here it's fine. Now, I'm trying to display 0 in these blank cells.…
-
Is there a way to create a static temp table in Beast Modes?
I'm the MajorDomo for a large retailer, and our Fiscal Calendar uses a 4-4-5 format. This means we have a Week 53 this year, and a large portion of our Domo reports are built off of a TY/LY comparison. I'm working on logic to reconfigure our reports always look 364 days or 52 weeks ago, rather than look at the same Fiscal…
-
Ignore Row Context / Power BI 'ALL()' Equivalent?
I mocked up a simple example to illustrate what I'm trying to accomplish. The question is: how to create a beast mode which will ignore any filters and/or table row context applied to a column, in this case `Store`. The goal is: calculate Average Order Value for the entire dataset (Total Company), so individual Stores can…
-
Attempting to create unique rows for each possible value in a chosen column
Our business model currently offers multiple product options. I'd like to create brand new rows for each customer, 1 for each product, whether they own that product or not. My thought is to use new columns and then use a dynamic unpivot. Need help creating the new columns first though.. Currently have this: Account Product…
-
Only show unique values of a column in table
Is there a way, in analyzer or ETL, where we can only display one row for each unique value of a column corresponding to a key column? For example, I would want this: ID Num 1 4 1 4 1 5 2 4 2 5 2 6 3 6 3 7 3 7 to become this: ID Num 1 4 1 5 2 4 2 5 2 6 3 6 3 7
-
Error filtering Data
Hi, I'm using a filter on a Dataset I which I need that a column A to be different to FALSE and another column, B, equals to FALSE, but it is not doing the filter correctly
-
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.