-
Allow customization of column width without manually entering the width percentage
Currently we can only add a customization to the column width by entering into number as percentages, and use comma to separate out the numbers. However, this doesn't work if I have many column (e.g. 40). It takes too much time to manually enter numbers and commas, and there is no way to check if I have enter the right…
-
Table Total Row and Beast mode Aggregation
Hi experts, I'm tying to build a table of consumption by subtracting a total on different days. I'm using the lead to get the next value and subtracting the current one: When I able the total row option an error occurs: My first question is why is it happening? My second question is why doesn't the bar chart aggregate the…
-
How can I display amounts for different months in a table in Domo?
I want each row to contain the amount for the previous month as well as the amount for each of the 5 months prior to that. What is the best way to do this in Domo with a Table chart type?
-
Is there a way to use DropDown Cards to display text or tables?
Hello! I am trying to allow users to select a dropdown for a data dictionary. The idea is to allow users to select the terms they want to understand, and for a description to populate below. For Example: When the user selects 'Cost per Session' from the dropdown, I want the card to display the definition directly below…
-
Tool Tip Functionality for Table Viz
We pull our data from SFDC and have opportunity pipeline tables we review weekly. We have long string fields (Next Steps, etc) that I'd like to be able to provide functionality to view but not make part of the table itself since the visual formatting gets messy. If we had tool tips for tables I could add the long text…
-
How to Create WTD, MTD, QTD, YTD on one Chart
I received a request to create a chart to show KPI with WTD … YTD on a single chart. Image below is the example: The Closest I've gotten is; I created a dimeson that flags the 'WTD' dates as a Y/N, then created a beast mode doing a case statement for when the Date flags are 'Y.' I've done the same for the other KPI, but it…
-
PDF output large data
exporting to pdf is limited to 800 records. need to be able to export a large table to pdf.
-
Adding Images to Table Card Using Beast Mode
Can someone help me with the formula to add a different image for each row in a table? I've been using the attached article. I've been able to get an image added, but the same image is in each row. I can't figure out how to get different images to populate in each row, like the sales rep image example in this article.
-
Why is my beastmode to bring in Salesforce Profile Photos not working?
I'm using the html code referenced in this Domo Article: Our salesforce rep profile photos are being brought in as a url starting with "https" into a user dataset. I'm just not understanding what is wrong with the beastmode that it's not bring up the photo when I place the beastmode as a column on a table: CONCAT('<img…
-
Is it possible to get customized totals on a pivot table?
I would like to use a pivot table to show some summary information. A key requirement is that the end-user needs to be able to drill down to view the raw data. Here is an example of what I'm trying to do. Below is a screenshot from Excel. To the left is the raw data. The top pivot table is similar to what I am able to set…
-
Adjust Image size in Pivot Table
Hi everyone, I am facing a problem with adjusting image size by using HTML code in the Pivot table. What I want to achieve is: add an arrow indicator (arrow image, Domo API ) column at the end column of pivot table to indicate the direction of changes. However, when I adjust the size of my arrow image, the HTML code…
-
Table Export Option: Limit which Columns Export
I recently saw we added an Excel Export option to Table Cards to change the # of rows we allow to export. I think it would also be valuable to be able to enter which columns should be exported. Use Case: We may have a table that provides additional context columns, but is also part of a workstream to export and paste into…
-
Table card subtotals - allow blank labels
I often use subtotals in mega tables/pivot tables to group child rows together, regardless if I'm aggregating totals or not. I've found that being able to suppress the subtotal label text (e.g., "TOTAL") would make the tables look much cleaner. I don't see a way to complete omit the label so I usually put some small…
-
Add Table Design Param to Allow Setting of Table Borders Color/Weight
I get a number of requests for sprucing up our tables/visualizations so that they align with our company style guide/colors; including questions on whether Table borders can customized a bit [or removed in some edge cases—to me that woiuld just mean, set them to #FFFFFF if I had that as an option]. Effectively what this…
-
Flex Table Improved Customisation
Hi all, I've recently used a Flex Table and was shocked by the few available customisation options. Something as simple as changing my line's colour is seemingly impossible. Improvements that feel essential: Change Header Colour Series Grouping/subtotals Change Line Colour Remove the Area under the line Change…
-
Making variable values the same as another column
Hi, I have a table full of hundreds of advertiser names. I would like to select an advertiser name in a dropdown control, and in the pivot table below, censor all the advertiser names to 'xx' and only show the advertiser name that's selected. I have created a beast mode that does this but I have 2 issues: How can I make…
-
Paging in a Table Card
Hi there, I was reading a closed forum question that suggested an answer that may no longer be true at this date. Original Question: I have a Mega Table with about 600 rows. I don't want to show all 600 at the Dashboard level, even with the scrolling aspect. I'm concerned that it will affect the Dashboard Performance. The…
-
Sorting Beast mode
Hello! I'm trying to sort my beast mode where I'm normalizing my data to trend performance by the first month it's published and trending for a year since all my rows of data will have different dates in which they are published. The issue I'm running into is I can't sort the beast mode in order of Month 1, Month 2, etc.…
-
Pivot Table Issues - Needs Work
Hi there, I've been using pivot tables for a while, and I just noticed a weird way in which Pivot Table cards specifically sort their data. I have the retail sales of a bunch of different brands, and then I sort them by month using a pivot table. When I go to sort them or filter by retail sales, it sorts or filters based…
-
How to get an avg in the grand total of a column with a BM with sum?
Hi, Im trying to use this BM CASE WHEN MONTH(Cycle)='10' THEN (sum($ New Annual Salary(in USD))/ sum($ Annual Salary(in USD)))-1 ELSE sum($ New Annual Salary(custom)(in USD))/ sum($ Annual Salary(in USD))-1 end and its sucessful but in the Grand Total I requiered an average not a sum, and usually I can use the agregation…
-
Subtotals in PivotTables
I am currently working on bringing some pivot tables to my customer however they find these subtotals duplicates not really esthetics and confusing. Is there a way to get rid of them? I tried "Hite Subtotals" option but with no effect.
-
Display table card in multiple "columns"
Hi, I have a table card with lots of rows. I'd like to be able to display ALL of the data in the table neatly when exported to Powerpoint. Is there any way to get a single table card to display in multiple "columns" like below? Slide 1: Slide 2, 3…N would be the same format, displaying the rest of the data. Is this…
-
Drill down into table
Hi, I have a table and I'd like the ability to click on a field and open a new view that shows a more granular table. My table looks like this: Account | Dollars If a user clicks on an account in the table, it will drill down into a new table: Account | Media Outlet | Dollars How can I achieve this? Thank you.
-
Is it possible to calculate ROAS and WoW change in the same beast mode formula?
I'm working on a pivot table and I want to show the % change of ROAS from last week vs. two weeks ago. My dataset does not contain a 'ROAS' column so I'm trying to calculate it within the WoW beast mode formula. If I breakout the formula below into two parts (LW ROAS vs. 2WA ROAS), the first part will correctly give me…
-
Pivot Table Week over Week % Change
I want to show the WoW % change for my data but not really sure how to go about it. My raw data is daily and I grouped it into weeks in the pivot table. I want to add a column to my table where it will show the % change of sales from the previous week.
-
Using Drill Paths for individual cells in table views
Hi, Essentially we have categorized our content data into 4 unique classifications (V.Good, Good, Bad, V.Bad) and have visualised the % of content that falls into each in a table and then broken that down by content type. We therefore have several rows of %s for each content type and each classification. What I would like…
-
How to add gross profit row into profit and loss pivot table
I am using pivot table to create a profit and loss statement. Please see the following picture: I want to add a row which is called Gross profit below TOTAL COST OF SALES. Gross profit is calculated by subtracting TOTAL COST OF SALES from TOTAL TRADING INCOME. Also, I don't want to create a Gross Profit account and join it…
-
How to add clickable hyperlink to scheduled report when URL is coming from a column in dataset?
hi! i'm trying to add a clickable URL link to my scheduled reports, but it only seems to be clickable in Domo and is not working through the scheduled reports. I'm thinking the issue might be related to the fact that my URL is coming in as a column in the dataset. this is the SQL I have right now: CONCAT('<a…
-
How to show Actual Grand Total rather than "Grand Total"
Hello, I have a card built that only has two columns, and both columns have numerical values that I need to see a total of. However, when I activate the Grand Total option for the card, instead of showing an actual total it has the "Grand Total" text since it is the first column on the card, and I cannot add any other…