-
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.…
-
Rename Columns on Sumo Card
i feel it would be of great benefit if we were able to rename columns on a sumo card while editing the card. Currently, I have a table card that I transformed over to a sumo card so it could have the pivot table feel/freezing the first column. However, most of the columns are beast modes. I know I can go through and change…
-
Add List-Items to a single table card cell
I have an Asana API pulling in project status field. The incoming values are unordered lists <UL><LI>. Is there anything that I can do from a beast mode perspective to maintain this formating versus (adding line breaks & bullet points, etc.). Ive seen suggestions on Dojo that included a REPLACE() but that still formats…
-
Text in Table Shows as Linked
The text in my table seems to show as linked, even when it's not. I've narrowed it down to some connection with the size of the card. When I did tests, small cards weren't showing the text in the table as linked, but when the card was larger, the text in the table changed to show like it was linked, even though it isn't.…
-
Sumo cards display rows offset when dimensions are grouped, is this intentional?
When creating Sumo cards, when grouping all the dimensions that are displayed, the row number labels offset, and this persists after saving. I had another user test and they had the same results. If this is intentional, it seems awkward as it makes it difficult to line the row number up with the dimension value. To…
-
Pivoting multiple columns to one, while keeping correlating data
Ok pretty sure I need to creat a pivot table of some kind, to move data that extends in rows across an unknown number of columns, and bring it all into one uniform column. The problem I have is keeping the associated row data when you move the data into one column. See below ---> What I have: What I need: How do I do this?