pivot
Discussion List
-
How to Include Subtotal Percent in Pivot Table?When in the analyzer, I selected a pivot table Next, Chart Properties --> Subtotals --> check…
-
3Increasing m x n dimension of a pivot tableI was trying to build a pivot table where columns would be month names, but DOMO can't handle pivot…
-
How to compare Value ColumnsHi, Beginner to DOMO so excuse the question. I've created a Pivot table with 2022 sales vs 2023 p…
-
"The Pivot Table is Only Showing Part of the Data" ErrorIn our KPI cards using pivot tables, I keep getting the following error. ”This pivot table is only …
-
Calculating percentage corresponding to blank cellsHi all, I want to calculate percentage of the events count in my dataset like below Here, we can sa…
-
Filling blank cells with 0Hi Team, I've recently started domo to build reports and I'm trying to fill 0 in below blank cells …
-
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 …
-
Attempting to create unique rows for each possible value in a chosen columnOur business model currently offers multiple product options. I'd like to create brand new rows for…Answered ✓ n____l____ 116 views 2 comments 0 points Most recent by jaeW_at_Onyx Data Platform & Data Science
-
Pivot Table showing correct grand totals but not all recordsI am counting story points from a jira import, and while all the records are in the base data, when…
-
Pivot Table summary valuesHi all, I'm very confused about what is going on with my pivot table. The row&column totals ar…
-
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…
-
Pivot tile returning results slightly less than expectedI have a dataflow with 2 outputs. I branched off some appended data to one dataset, and then I took…
-
Mandatory Single Select FilterI made a Pivot Table which needs 3 Single Select filters to be done by the user, otherwise it will …
-
Trying to add percentages in a pivot tableHi, Would anyone be able to help me with the following: I'd like to have my pivot also show percent…
-
Seasonality ChartHello, I am trying to create a Card that will help with the forecasting. We receive cases (CasesID)…
-
'Incorrect column name' doing a Dynamic PivotHi there! I've been following this tutorial for dynamic pivot and so far it has worked: https://do…
-
CountIf function in DomoHello I have a data that contains all the cases submitted and their submission date and in another …Answered ✓ dylang91 764 views 4 comments 0 points Most recent by dylang91 Data Platform & Data Science
-
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 t…
-
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 th…
-
How to SUM working days correctly?Hi everyone, I have a strange problem. Probably more of a SQL question than a Domo question, but he…
-
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 search…Answered ✓ MattLynn 134 views 5 comments 0 points Most recent by MattLynn Data Platform & Data Science
-
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…Answered MattLynn 334 views 6 comments 0 points Most recent by MattLynn Data Platform & Data Science
-
Dynamic Percentages of TotalHello! I am trying to get a percentage total column to work within a beast mode calculation in a pi…
-
Sorting on both Columns and Rows when using pivot tablesHello, I'm encountering an issue when trying to sort on both columns and rows in a pivot table. I w…
-
Pivot Table Summary Number is Blank on DashboardWe're trying to use a pivot table card within a dashboard, just showing the Summary Number to guide…
-
What is wrong with my Pivot - Uncollapse Columns? Showing NullHey I'm trying to pivot a column, but the new columns are all null Here is the original data This i…
-
ETLI have a column with multiple categories values, I want to convert this categories values to column…Answered AnasAhmed 51 views 1 comment 0 points Most recent by GrantSmith Data Platform & Data Science
-
Help graphing a calculated field that sums up two data columnsI have a dataset that has daily data spanning back to the beginning of 2019. Let's call column A &q…
-
Beast Mode to compare Values in 1 Column against 2 time periodsAfternoon, I have access to a dataset at my organization that pulls in competitor data. The…
-
Creating a Pivot Table Card where the default view is COLLAPSEDHi Everyone... First post here. Just finished my professional cert level 1 to give you an idea …