-
Beast Mode Calculation used to view data in Table
My question is related to showing Comments/ Verbatim in a Table using a Beast Mode to Apply Business Rule. In Org Survey, we want to make sure that if we have less than 5 unique comments then don't show the comments. If the Business Rule of >= 5 comment is met, only then show the comments/verbatim. Below is an example…
-
Filtering Question
I have a mega table report that is displaying customer invoice data. One of my filters is for the Aging Range. I have been asked to modify the filter to include all invoices for a customer if any of their invoices are in the filtered range. Meaning that in the below dataset if they selected to filter 151-180 all invoices…
-
Adjust Column Widths in Pivot Tables
Currently, you can set column widths under "General" properties of a regular table, but not a pivot table. This doesn't allow us to maximize space on the page.
-
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,…
-
Conditional Formatting - table MoM
Hello, I'm trying to set color rules/conditional formatting in a table card. What I'd like to do is set rules that if that months sales figure is higher than the previous it'll be green, if that months sales figures is lower than the previous it'll be red. (ex. If July sold 10, but Aug sold 8 August's value would show as…
-
Mega Table SubTotals in Brick
I am lost in how subtotals are integrated into a mega table in a brick. I started with the ten data source DDX brick, and I was comfortable with configuring the options and the two data queries; however, the subtotal has me stumped. Is the subtotal a third query or somehow handled with the data from the original query? I…
-
Pivot Table Coloring
I have a very simple question that is proving very tricky to work through. Given the following Pivot Table, I am just trying to highlight the "Actual" based on whether or not they hit their "Goal". Basic Color rules have not been working since you can't color a column based on another column. "Apply to Full Row" does not…
-
Beast Mode row highlight
Is it possible to highlight the entire row for a category in a pivot table in DOMO? In the above table I want the category 'c' and 'f' rows to be highlighted as they are the categories with the highest value in each type
-
Filtered Period Comparison reflect in tables
Hi I want to create a table where user can select the date comparisons between two periods. Just want them to pick the date comparison and the data reflect in the tables accordingly. And how to create another dimension with %chg based on two periods. For ex. User wants to see total GMV between Sept 1st to Sept 5th for 2024…
-
Pivot table enhancements
I would like for the ability to choose whether Pivot Tables expand/retract vertically rather than horizontally. Right now, each level is stored in it's own column. This often takes up a ton of unnecessary screen real estate. I'm envisioning something more like this… VS how pivot tables currently function
-
New Update Column Justification logic
Hey, There's been an update on how sort shows on table headers. When an item is centre-justified, the sort buttons offset the justification to the left, which makes it look absolutely rubbish. Has anyone got a workaround for this thats isn't removing sorting from the whole table? Best, Sam
-
Allow for "Other" category in mega-tables
I would like for there to be the option to define the max number of rows in a mega-table before grouping all others into an "Other" group. This functionality exists on bar charts, just looking for the same thing in tables. The idea originated because a lot of the time I want to be able to show to top N rows in a table, and…
-
Customize Color Theme / Reverse Order
I recently built a heatmap table where I want the lowest numbers up top. These start around -25 and end at -10 currently, but the numbers will change each time the chart is updated. I also only want to show 10 rows of data, so the table has been limited to the 10 top results. I want the heatmap to display negative numbers…
-
Workaround to Pivot tables pushing non-valued categories to the bottom.
Hi, I'm currently trying to build out a pivot table with custom sorts on both the row and column values. As has been mentioned before on the dojo; pivot tables will always override the sort so that non-values will display last even with a custom sort including the column/row headers. Has anyone found a workaround to this…
-
Not showing 'data' in Table View
Hello. I'd like to ask why my drill down card is not showing any data in my Table view. but when I checked the "Data Table", it should be showing something. When I tried removing either 'PO' or "LabelSerialNumber' columns, card data appears. But when both columns are present, no data is showing. I need both 'PO' and…
-
Image size doesn't reflect settings (table)
I am trying to set an icon in a table column that links to an outside site/page. The Beast Mode works as expected, but the table is not reflecting the style/height setting. The current version of the code is here: concat('<div><a href="https://xxxxxxxx.app.netsuite.com/app/common/entity/custjob.nl?id=',Customer Internal…
-
Drilldown tables on cards displaying info from multiple dates
I have a card that uses variables to display info from different date ranges - some columns show metrics for a custom date range (defined by the variables) and other columns show metrics for the current month. When I add drilldown tables the date filters seem to get confused - it keeps picking the current day, even though…
-
Median Value in Total Column
Hey all I'm creating a heatmap visual that compares our engineers' ticket cycle time against projects and uses the median value. When I add a total column to the graphic, the column sums the values above instead of calculating the median across all projects. Can the visual be adjusted to calculate an overall "Median"? ref:…
-
Displaying 1 to many records in a table
I have created a custom app for my users to be able to add notes to Invoices that are in collections. The relationship is 1 Invoice to many notes. Initially, my plan was to display the Invoice details in a table card ( Customer, Invoice #, Contact, Invoice Date, Invoiced Amount, Total Due, etc.) and the note data would…
-
Branching/Hierarchy in Pivot Table, Mega Table
Hello, Is there a more elegant solution to create Branching/Hierarchy in a Pivot Table (or any other table)? Something to look similar to this: This was created using the Formula Editor in ETL, but I don't like the solution and was hoping for something more elegant and flexible:
-
Total Rows not Calculating
We have a drill path that ends with a table card. The table card has a total row but it doesn't display totals except for counts.
-
"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…
-
Adding custom font colors for a transposed row in a table
I want to label the positive numbers in green and negatives in red but only for the second row. How can this be achieved? Current chart settings is as shown below
-
Percentage of values in a column
Hello I have a data set with a column name Sale_Type. I want to create a beast mode to use in a table chart that shows the percentage of each sale type in the column. Example of what I am looking for below.
-
Date Beast mode
Hi everyone, I have a pivot table which contains plan data. The key point is we need to allow one month post plan completion to allow for data collection and input. Country Plan Name Start Date End Date Status Delivered data available Austria Plan 1 1st Jan 2024 1st March 2024 COMPLETED YES Malta Plan 2 1st Jan 2024 1st…
-
Is it possible to create a tooltip for one column in a table/card?
Say I have a column "Masked PhoneNo" that shows ***7890. Is it possible to hover over this text (usually a column in a table) and display the full PhoneNo (123-456-7890) which is a different column in my dataset?
-
Pivot table: Change Subtotal to Average
Hi everyone, I am facing a problem of presenting averages as the 'Subtotal' instead of the sum as subtotal in pivot table. The following picture is the context of this issue: The columns are working days and the rows are monthly data for shop 1,2,3…. The source data is daily data. However, for this table, each cell is…
-
Pivot Table Collapsing
Hi all, I used to have this card setup so the pivot table was expanded out one level and it worked fine up until a month ago. When I view the card all levels are collapsed in the dashboard view. If i go into the card to expand it out and click save, it keeps defaulting back to a fully collapsed view. This didn't happen…
-
Dynamic Column Names in Tables
The introduction of variables allows you to create much more dynamic table cards where the user can pick and choose which columns he/she wants to see inside the Table/Pivot Card. However, Variables only changes the data that shows up inside the table, it currently can not affect the Column Name so i have to end up naming…
-
Different time zone
Hi! I'm trying to configure the time zone in ETL but my query is resulting in different times when the function calculates the difference, for the same column. ETL time zone function: Imported table from SQL Server: Result after time zone changes: The date range of the table is from Feb 24 to Mar 12. From Feb 24 to Mar 8…