-
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…
-
What is wrong with my Pivot - Uncollapse Columns? Showing Null
Hey I'm trying to pivot a column, but the new columns are all null Here is the original data This is how I've set up the pivot info This is the output I get: Originally not every Customer_ID had ever Level(1/2/3) I thought this was the cause of the nulls but I've fixed it so every Customer_ID has all levels and still the…
-
ETL
I have a column with multiple categories values, I want to convert this categories values to column labels. How do I do this. In the screenshot attached below I want to convert values of column '123 1' to column labels.
-
Help graphing a calculated field that sums up two data columns
I have a dataset that has daily data spanning back to the beginning of 2019. Let's call column A "Sales Date" Let's call column B "Daily Sales" Let's call column C "Employee Name" I then am creating a beast mode calculation for "Month" and "Year". I want to be able to plot in a bar graph the calculation, by month/year, the…
-
Creating custom images in tables with text
Hi, We are now able to add different custom images in a table with a text at the right, do you know a way we could center this text just at the middle right? We want to have the left icon more aligned to the right text. The code we are using is: CONCAT('<div align=center><img src="',`Picture`,'"height = "130" ><div…
-
Beast Mode to compare Values in 1 Column against 2 time periods
Afternoon, I have access to a dataset at my organization that pulls in competitor data. The question I want to answer with my card is: * Who is/are the new competitor(s) that showed up last week (fully completed week) compared to competitors from last 12 weeks (exluding the prior completed week) I have built out a dash…
-
Is it possible to add a hyperlink to an image in an HTML table?
Hi there, I'm trying to build an HTML card that has images with clickable links. I know that it's possible to add a clickable hyperlink to text in an HTML table, but is it possible to do so with an image as well? I tried: CONCAT( '<div><a href="CLICKABLE LINK"','"target="_blank">', '<img align="center" src="IMAGE ADDRESS"…
-
Creating a Pivot Table Card where the default view is COLLAPSED
Hi Everyone... First post here. Just finished my professional cert level 1 to give you an idea of knowledge level. I created a pivot table chart and by default I have a QTD date range broken out by weeks. My column hierarchy goes -> Week (based on our fiscal calendar) -> Campaigns -> dimensions/metrics. We might be running…
-
Pivot Table to show values on a row as opposed to a columns
Hi With regards to pivot tables. In Excel you can pivot the value to show this as a row or a column. But the option on a Domo Pivot Table card forces the user to create all of the measures as columns. Here is my scenario, I have targets as a beast mode for each region. I want to pivot a table by region as columns and…
-
Pivot Table Average Summaries instead of Totals
Hi all, With the new pivot table card designs we can add Totals and Sub Totals which is great and sums values into collapsable groups. I can't seem to see a way to set a similar summary using a different aggregation like average, count, min and max. For example, I have data showing a number of staff working hours which are…
-
Show data of last 10 weeks
Hi, I have a dataset that shows data year to date. And I am using an HTML card to get a table view. Is there a filter or setting that can be set, to always show the last 10 weeks of data as time goes by? I have week column and to not overload the table, I always only want the last 10 weeks data.
-
HELP PLEASE - Add Subtotals into Mega Tables Domo
Hi All, I have the following data: OwnerAccountAmountRandalA10 A10 A2 A Subtotal22 B3 B7 B9 B Subtotal19 C5 C10 C10 C Subtotal25Randal Total 66 I need to be able to show subtotal at both Owner & Account level all within 1 visualization. I'm able to show the subtotal at the Owner but I can't find a way to show using…
-
Color Formatting Pivot table
I have a pivot table that shows the sales by location for each month. I need to highlight the maximum sales month for each location. I have used Html conditioning formatting on a single column, but since this is a row-level comparison I am not sure how it can be done. Here's what I have Here's the desired output I am…
-
Pivot Table Card Collapse/Expand
The documentation on the Pivot Table card shows the ability to collapse/expand rows and columns as functionatlity but I cannot figure out how to do it. Can someone point me in the right direction? Here's the documentation I'm referencing:…
-
Create a card with variance
Hi Dojo Team, I'm new in domo and started to explore it. I need your help while creating a crosstab chart or Table chart like below image. I have three column which inlcude Date, Additions, Depreciation. From all these three column, I want to calcualate variance between two months like below table.…