-
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.
-
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…
-
Color Coding or conditional formatting in DOMO?
I am trying to make a scorecard for budget…etc… Let's say our budget in Jan was $14,418,053 and are actuals were below that. How could I turn that budget red? and vice versa if actuals were above budget it would be green? Is this possible in DOMO yet or are there work arounds. Thanks, Garrett
-
Have a row displayed with 0/NULL when filtering by date when there's no data
Tried my best to summarize in the question... I have a data set of Google Adwords Data. I'm putting the data into a Pivot table and have campaigns as a Row. I'd like to have every campaign show in the table even when it has no data to report for the selected time frame. It essentially would the the row for the campaign and…
-
How do we hide/merge duplicate cells in a column in HTML table
Hi Domo team and users, I am using an HTML table for my card, because I need to implement some cell specific conditional formatting (not shown in this screenshot) and only HTML Card works out for this. But while using this visual, there is no option to consolidate the repeating vales in a column. Any insights on this is…
-
Allow users to collapse/hide columns in table cards
Our clients often ask if they can hide columns displayed on a pivot table. It would be good if there was a collapse button on the column header and if the state was remembered via a cookie or local storage so it remains hidden/shown when they visit the dashboard next time.
-
Table Subtotaling
Having an issue when trying to subtotal the time columns. I want to be able to see the total off all the times rather than the count of each row? etg. 00:00:20 + 00:11:57+ 00:05:07… I moved my beast mode into ETL formula to try and get the field to work, but I cant get anything besides 'text' field to work.
-
Download Line chart forecast values as an excel or csv
Currently, when I create a line chart forecasting values into the future, I am able to see these values okay on a chart. However, when I try to export the chart in excel/ csv format, the future dates disappear and I can only see the actual values corresponding to historical dates. Will it be possible to download this as an…
-
Identify percent of people attending current event
I am currently trying to gauge how many consistent event attendees are attending our upcoming show. For context, we have 2 events every year and every registration for an event is on a separate record which I have categorized by year between 2021-2024. I am trying to roll this up into a table that gives us a percentage of…
-
Creating a Beast Mode to calculate field sums for remainder of year
Hi - I am trying to write a beast mode calculation that sums a field from an as of date until the end of the year. The variable is indexed across the year and want to count how many are left depending on what date is entered. For instance if 1/22/24 was the date it would count all the values indexed for the variable until…
-
Column borders
The suggestion has already been made, but I want to mock-up how easy it would be to add border styles via the Domo interface. This could be on mega tables, html tables, or simple table. We need some way to darken and thicken borders. Telling us to use bricks or something is like suggesting we go to some other application.…
-
Displaying up and down periods over time in a chart
We are tracking internet down time at our stores. Basically every 15 minutes we receive a list of all stores that are currently up. I then process that and for every store that was missing in the list I store a record in a dataset with the store and a timestamp. We need to show over a 24 hour time period what stores were…
-
Option to select which fields will be shown as subtotals in pivot table
When building a pivot table, it is not possible to choose which fields will be summarized as subtotals and which will not, and for each field that is dragged to the rows, a subtotal row is added and this field divided the table's data to segments.
-
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.