-
CARDS/DASHBOARDS Q&A from Domopalooza
The product team enjoyed answering questions from the audience during the final session at Domopalooza. Below you will find the answers to all questions related to Cards and Dashboards (including those that weren't mentioned on stage). Q: Can we have card templates? I want to lock fonts, number formats, hover settings,…
-
how to change the type of existing DOMO data?
data has been uploaded into DOMO. the first column is in integer type like '45319' but actually it is DATE(Jan-28-2024), how can i change it to DATE in DOMO without changing the original spreadsheet data type? thanks
-
Filtering data with 2 columns with beast mode?
Now I have a dataset something as below; ID Cat Name Cond01 0001 1 A 3 0002 2 B 4 0002 1 A 3 0001 1 D 1 0003 2 B 7 0003 1 C 5 0004 1 A 9 … … … … Now I want to make two filter cards to select data by Name , conditioned with a Cat value, where one card is for filtering data by Name when Cat = 1, another one by Name when Cat…
-
Color rule based on category %
Hello, I am trying to find a way to add color rules based on category. This is an example - this is a pivot table showing all the orders based on category by week. Each category has a different range that needs a color rule say for category 1 - it should be less than 5% to show green else red but for category 2 - if its…
-
Refresh dataset
I am trying to refresh my dataset (google sheet), And i do not see a drag and drop file in the details section of settings. I am not sure how else to do it, and my data preview is not showing the new data I have in my sheet
-
How do I append data to a designed CARD every day automatically?
I set up a CARD to show warehouse storage location quantity, every morning the 3PL send daily storage location report, I'd like to append the daily data automatically to DOMO from google sheet because 3PL's report is in google sheet format. How can I set up it? Thanks a lot.
-
Updating data set
I am new to DOMO, I have uploaded my spreadsheet and can see my card and chart, how do I update the spreadsheet so the datat is up to date each week. Also I have it listed as weekly revenue but it shows as monthly?
-
How can I have the data (text type) distinct counted in Analyzer?
I want distinct count for Y axis rather than count, How can I do it ? Thanks in advance.
-
Full-Size Card Background Color and Filters Background Color
I have created DOMO dashboards with a color scheme that is in-line with my web application. The embedding of the dashboard is seamless. However, When I expand on a card, the background is the defualt white background. Additionally, when I click on the filter icon in my application, the filters bar is also the default color…
-
Connect Two Cards
Hello, I'm currently working on a Dashboard. In this dashboard I have three different cards: one is a slicer that allows you to select certain deal numbers, the other is a product description based on the deal number, the last one is product description by date. Now what I have not been able to figure out when I select a…
-
Looking for highest volume by a specific day as well as highest volume during a specific week
Hello, I am trying to take the data below and generate which day of the week has the average/max/min on volume. I would also like to know the average/max/min by day of the week and week of the month. How would I go about doing this inside DOMO? Essentially I would like to be able to answer the business question as follows:…
-
How to share a dashboard with interactions to external clients?
I want to share a specific dashboard with interactions to an external clients. I was able to export the dashboard with summary but not with interactions to select within it. What are the possible ways to achieve that in DOMO?
-
How to get filter selections to persist on mobile devices?
Our field users are frustrated that their filter selections don't persist on iPad when navigating in and out of the app (to check another system ie email, crm). Outside of creating & saving a preset filter, is there a way to keep filter selections in place until the app is closed? Their use case is typically creating "on…
-
Embedded Request Form - ClickUp
Hey all! I'm curious if anyone knows if this is possible? I am wanting to provide this request form as an embedded view where someone can fill this out within Domo then it will automatically go through the Click-Up platform we use. As of right now, we just have it as a link that takes you to the request form in a separate…
-
Conditional formatting based on multiple columns
I want to compare two columns and their values in a card. I have column A and B. I want to apply color rules on the lower value cell between the two cells. I know you can set the color rules based on individual columns. I know you can create a beast mode and set a flag for the conditions. I currently have the color rules…
-
Combining 2 cards? Trying to find out how to use advertised feature.
At the 1:15 mark of this ad, the user mentions combining two cards showing different but related data ending with an "overlay" of the 2 visuals at 1:50. But, it didn't go into the specifics of how it was done. Does anyone know what feature would allow this? As always, thank you in advance!
-
Remove Card Title From Dashboard Display
I am trying to remove the title from the cards on the right to match the cards on the left, so that the title isn't repeated. I prefer the look of the cards on the left. I didn't create the cards on the left and don't know how it was done. Thanks
-
Total row not calculating right
I have a card displays volumes for each of my customers. In some cases, there are duplicate volume numbers, but the total row only calculates one of them. For example, if customer A has a volume of 150 and customer B also has a volume of 150, the total row only calculates customer A. Any thoughts here?
-
Drill down from chart view
Is there a way to drill down from a bar chart view without only clicking one of the x axis chart values? For ex: I have an inbound vs outbound bar chart - If I click inbound or outbound bar graph the drill path will take me to a view of each (inbound or outbound) by account - But i am trying to see BOTH Inbound/outbound by…
-
HTML Table Styles
I don't generally work with html table chart type, but I have a dashboard that needs borders and subheadings if possible. I am only interested in what I can control in html tables, I don't want to use bricks. I can't find any web examples with fancy tables showing borders and headings such as the following. Can this be…
-
Incorrect subtotals on the cards
Hi There, I have this table on a card in Domo where the Average Wage = Labor Cost / Labor Hrs. The Avg wage is being calculated correctly in all the top 8 rows but in the subtotal row (highlighted in green at bottom) Avg Wage is being calculated as sum of all row's average wage, instead I would like to view it as…
-
DOMO card color rule set but not working
I made 2x pie chart cards both with a simple set of rules for when one beastmode column "status3" (number column type) is =3, the pie chart slice would turn red, =2 it would turn orange and so on. The issue is that that when I checked on it the color rules were not being enforced correctly. The slice of the pie that was =2…
-
Count of Active Employees Month by Month
I have a card to build which should show running graph of how many candidates had an active authorization at a particular office locations during a given month. It should be able to show historical running totals of employees that an office has and are they growing or shrinking. So, I have dataset which has columns like…
-
How to calculate a percentage based on another beastmode
Hi I am trying to calculate a percentage of customers who repeated, out of all customers. Basically count(distinct repeat customers) / count(distinct all customers). This has to be done in beastmode so users can select a date and the repeat customer % will be dynamic. This is the raw data, Cumulative sessions is used to…
-
Did the "Save as" to Overview option move?
With the latest release updates, it seems like the option to "Save as" a card to your Overview section has disappeared. You can Save as to the Card's original dashboard, then Move to your Overview, but this adds an extra step. Can we find this option somewhere else now?
-
Grand Total Beast Mode not calculating correctly
The beast mode below is not calculating correctly in the Grand Total Column. CASE WHEN SUM(IFNULL(`Billed Amount`,0)) = 0 THEN 0 ELSE (((SUM(IFNULL(ABS(`Billed Amount`),0))) - (SUM(IFNULL(`Actual Material Cost`,0)) + (SUM(IFNULL(`Actual Labor Cost`,0)))))) / SUM(IFNULL(`Billed Amount`,0)) END
-
How to do percent of totals for different totals
I have totals , value, dimension, three columns which i want to show as percent of totals vertical graph, However, my totals is a different column and is distinct to each dimension . I want to display botton 10 rows for dimension that has the totals with the value in ( percent of total graph) How do I achieve this. I tried…
-
Date Type capabilities
I'm trying to do something again, but I forgot how I did it. Coming from a PowerBI background when you choose the Date type it allows you for some dynamic presentation. Below I did it once, now it doesn't work any more where my columns are showing it by date. Compared to this How do I get it in the format to show…
-
Replace personal identifiable information with avatar
Has anyone ever replaced a user's information with a non-identifiable avatar in a table on a dashboard? Here is the use case: We want to show a snapshot of what was recently watched on our video streaming platform. Our model is that a group buys a subscription, and then all its members can use the platform and watch…
-
Is it possible to pull image into the tables?
-
Configuring Card for Last Time Federated Dataset Refreshed Based on Browser Time Zone
Hello, I am trying to visualize in a card when the last time a federated dataset has been refreshed based on the timezone that a person's browser is set to. For example, if I see that this dataset last updated at 2 PM and I am in the Eastern Timezone, I would want that a person in LA time see that the dataset last updated…