-
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…
-
Pivot Table switch values to show as columns or rows
Been working with Pivot tables for a while now, and one of the huge things I miss is the ability of selecting whether the values should be displayed as Columns vs Rows, something that you have in simple spreadsheet programs. This has proven useful when you want to show the same metric by different aggregations for example,…
-
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…
-
"Add All Columns" button for Mega Table Charts
When looking at data in a mega table chart, I find myself frequently going through the list of dimension and measure columns and adding each individual column, one-by-one. I suggest adding a "Add All Fields" button to bring in all Dimension and Measures Fields in the DataSet - See Picture Example 1. Alternatively, add…
-
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…
-
Allow Ability to Show Alternating Row Colors in Pivot Tables
Please add the Chart Property "Show Alternating Row Colors" in Pivot Tables. Currently, you can only use this option in the regular Mega Table and HTML Tables. It helps to make tables easier to read if you can show that definition between the rows.
-
Default to 0 decimal for numeric/currency
I change this default literally every time I add a field to a table and elsewhere in Domo. It's extra clicks each time (per field added to a table). Additionally, when other users create their own reports they rarely change the default behavior and it remains at two decimals, which reduces data comprehension. For example,…
-
How do I Compare Column A vs Column B in the same Value?
I have one value that goes back several years and id like to compare TY vs PY. How do i write the calculation in beast mode to subtract A vs B and finally show the % ∆? Thank you.
-
Best way to have months show as individual columns in a table
What I am wanting to do is list the months this year Jan, Feb, March, etc.. in a table. I assumed that the date filter for a table would allow me to graph 'This year, by month' in the same way it would for a bar/line chart but that doesn't seem to be the case. Is there an easy way to do this with tools in the analyzer or…
-
More options for color rules for cards
When establishing color rules on cards, you're limited to selecting a single column and the criteria which for text fields is only either IN or NOT IN. While this is useful for most cards, it's really limiting when you have Pivot table or cards that are grouped and stacked on different dimensions. In the case of Pivot…
-
Is there a better way to play with Table Totals/subtotals?
Hi domo community, question. I'm having hard time getting my totals to look the way I want to look on a table, the perfect collapsed view would be If add and extra column and hide totals/subtotals and suppress ingle items in subtotals looks ok on expanded view (Image 1.1), But if I collapse it looks like image 1.2 Let me…
-
Issue with Sales Data Tracking and Date Transformation
Hello, I'm encountering an issue with tracking sales data in from our CRM. The problem arises from the fact that the table card relies on the 'Date Created' column for capturing engagements. Although this successfully captures most sales data, it fails to include engagements that were created in the previous year but…
-
Column created with Beast mode with numeric and porcentage format
.Dear community, this month I have receipt separately two cases with the same concern: The users have shown to me functions created with beast mode, inside a pivot table card. The goal is set in the same column figure with number format and percentage, including the symbol “%”. I have attempted so many ways, but I don´t…
-
Pivot Table - Use of Beast mode in the rows
Sharing the feedback on behalf of the customer from Learn IT Systems, he suggests that the Pivot table card should allow the use the of Beast modes having Windows function/ Aggregation in the rows section of the card. Presently it does lead to errors in Subtotal/Total while using such beast modes.