-
Flex Table with only one column
How do I make a flex table with only one column? I don't want more than one columns, but it seems that the flex table input needs at least two columns to work. Could anyone help? If not, then I was thinking of using a Comparitive Guage as an alternative. However, I cannot make the beast mode calculation as per my needs to…
-
Tiered Date Chart Properties
Has anyone had any luck successfully using the Tiered Dates in the Chart Properties? I haven't been able to figure out how it's supposed to work, and the only documentation I can find on it is the original release notes when it was first announced and one other article that it links to, neither of which go into much…
-
Show Google Sheets text/cell colors in Table
Good day everyone I am just wondering if there is a way to pull the cell or text color from Google Sheets into a Domo Table? We have a google sheet that is updated manually with scheduling information. If an appointment is scheduled then the date is input with red text color, once the appointment has been completed the…
-
Comparing year over year data- by same week day
Hi All, I want to compare the sales volume for 2020 against that of 2019 on a by day basis. For example: 1st Feb, 2019 was a Friday and 1st Feb 2020 was a Saturday. Instead of comparing Feb 1, 2020 against Feb 1, 2019, I want compare Feb 1, 2020 against the nearest Saturday in Feb 2019. Has anyone faced this scenario…
-
Weird Sorting Issue - Total Sales
Hi, Experts, I created a domo card in table view for some top-level KPIs. I am running into an issue when I sort by Total Sales (calculated field/beast mode) by ascending you get the column sorted by 0 to the bottom. When you sort by descending it sorts by blanks. Thoughts or help would be greatly appreciated.
-
Merging two cards
Hi there, Please excuse me if this is a silly question, I am new to Domo. I have created two separate cards where a line graph shows the data (for example) 'users who have booked 1 time' and 'users who have made 3+ bookings with the date range as the X axis. I wanted to know if it is possible to merge these cards or the…
-
Changing a day week start to Friday
I want to change the start of week days to Friday only for 3 cards on my dashboard. Can anyone tell me how to do that? I know I can change this in company settings, but I only want to apply this rule to 3 cards and not the entire company I know that I can change the start week day in a date filter card, but that does not…
-
Hide columns/rows from pivot table based on condition
Hi, I was working on pivot table and was wondering that, is there anyway that we can hide columns/rows based on condition or data selection from other card on the same dashboard? Suppose, I have value column in my table for all countries. I want to see for a particular brand display only those rows/coulmns where the value…
-
Subtotal (subtraction) Rows instead of subtotal (addition) Rows in Pivot Table
Right now there is an option to include subtotals in pivot tables. Can we include subtration of rows instead of subtotals? I have two rows: Current Week and Previous Week. I want to add a subtration field in the rows. Can anyone help
-
Map Card Auto-Sums values and this is not what I want
I am using one of the standard maps, and I have phase information associated with each territory. Sometimes a location will appears in multiple phases, because events will be done twice in that territory. So for example Territory | Phase New York | 1 California | 2 ... New York | 3 No matter what I seem to do, the data for…
-
PowerPoint Plugin - How Can Non-Admin Download It?
Hi, The Domo PowerPoint Plugin instructions state that "This plugin can be used by Admin-, Privileged-, Editor-, and Participant-level users." However, the instructions clearly illustrate that you must have Admin privildges to download the plugin. My question is: Is there a way for non-Admin users to download the plugin on…
-
How to make a chart which shows weekly values along with percentage change?
I want to make a chart which shows the weekly value of my sales, along with the % change every week. This % change can be in the form of a bar, a long, or a symbol (along with % value). Anyone knows how to do this? and whats the best way to do this?
-
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:…
-
Reverse running total
Does anyone know how to do a reverse running total? Basically I want it to start at thge total and decrease rather than increase to the total.
-
Remove columns with a sum of 0 in Grouped bar graph
I'm making a grouped bar, and I want to exclude columns which have '0' as a value/sum. I'm not able to filter because these columns are beast mode calculations and Domo gives an error (or crashes) if I use these columns in the filter (only greater than 0). Can anyone tell how do I remove the columns with a sum of 0?
-
Date Format Conversion
I have a spreadsheet coming from an outside source that I do not create, but I am creating Domo cards with it. Right now the dates are formatted in a way where I can't sort them. I just need to drop the day of the week at the beginning and the time at the end of each date row. Current Format: Mon, 1/12/2020 - 12:00 Format…
-
Beast Mode for Summary on Card Needed
I am not strong with case statements (working on it). How do I build a beast mode for the Summary Section of a card that will display the date range and total dollars. Below is a beast mode we created for our report (card) to display results, I just cant get the date range and figures to show in the Summary. CASE WHEN…
-
Counting values across 2 date fields in 1 chart
I have a data set and I'm trying to count by date (YY-MM) the number of tickets opened and the number of tickets closed. If I look at 3 fields: Ticket# OpenDate ClosedDate Charting # of tickets by open date works okay. If I add in ClosedDate (whether by a second line or if I use a pivot table), the # of tickets by…
-
Date Preset
Does anyone have a problem using Date Presets as an interactive filter? My case is that I have a slide filter, using a date field. It works fine and the cards on the page show the filter when one is applied. When I change the slide filter to a date selector using presets, the filter doesn't apply to all of the other cards…
-
Annotation by Filter
I think I know the answer to this but want to double check. When using a date annotation. If you ONLY wanted to annotate a date BECAUSE of a filter. Say just for one account or something was filter, then you'd want to annotate a date. But with any other filter applied you don't care. Is there a way to sync the date…
-
Data Selector Filter: Default Value
Hi, currently there is no way set a default value. For example, my date selector card is part of a dashboard were I want it's value to be "Yesterday" or "Last Week". Is there a timeline, if any, of when this feature will be provided?
-
Saving a card as a Favorite not working.
Hello, First time poster...long lime lurker When I view a card and navigate to "card Options" > "Add to Favorites" the card does not show up in my Favorites Dashboard (Page). Is this a known issue latey? I have one card in favorites that I added 6 months ago so I did it correctly once. I do have Admin status. Thanks for…
-
Buyer LTV Path
We have a sales funnel with multiple products within it. Product A (with three price points), B, C, D and they get progressively more expensive. The dataset I have being pulled in includes all of the relevant information. It records every single transaction, and includes: DateTime, email, product purchased, purchase amount…
-
Card filter - Contains
I have a card where I would like to use multiple contains statements. Is this possible? For instance, Product contains both Sunshine and mountain.
-
Scroll on a Table - Dashboard/Story
I am currently working with a moderatley sized table card that I would like to display on a story dashboard; however, not all the columns are visible and there is no way to scroll within the card to see the additional rows. Does anyone have a good solution as to how I can either display everything in the table or be able…
-
Bold text in Textbox
Hello, I was wondering if there was a way to bold text and possible change color to blue in the Textbox Chart Type. I have the following formula and would like to bold the number that comes from the formula "ROUND(SUM(`Purchased`)/1000)". I tried to use dynamic text box but does not seem to have a sum or specific formula…
-
how to hide results in dashboard when user number are small
I have a dashboard that contains some user information such as # of users, user activity(downloads, views etc), I have different filters set up to allow stakeholders to filter on user region, user group etc. However, due to the data privacy, I could not report on some info when # of user <20. here is what I hope to do:…
-
Filtering a dashboard across multiple datasets
I am trying to use a page filter to filter my dashboard which consists of multiple cards and about 5 different data sets. All the datasets have the column that I want to filter, but yet when I try to apply the filter it doesn't apply to all options. For example: Say the filter is 'name' and I want to filter everything with…
-
Formatting data of different datatypes in a single table column
Hi All, I have a requirement where I need to show a pivot view of data of different datatypes (such as - Currency, Percentage and Numbers) in a single column to show various metrics in a single consolidated view. Any idea on how to achieve this? Thanks.
-
default page filter
I wanted to only show all KPIs from external users, I have a field to idetify this. I know I can do this setup in each card, however, is there a way I can set up a default setup in page fitler so that all cards are set up by defualt only for external uers. Yet users should not see and change this field. Thank you. Olivia