-
Dropdown filter only seeing a few options
I have a dropdown filter card that is not showing all available options that should be showing up. Here is the filter card: As you can see I only have 2 options in the dropdown, but if you look at the filter for the same column: You can see that there are many more that this filter should be seeing in it's dropdown. Why…
-
Beast mode formula
if "event type" is not equals to "current physical due" but the the "enrollment date" is still within 90days from today then its consider as pending and here is my formula: CASE WHEN Event Type <> Current Physical Due AND ABS(DATEDIFF(NOW(), Enrolled Date)) < 90 THEN 'pending' ELSE'' END but it's not working, please help!
-
How to fix hover percentage on 100% stacked chart
I have a 100% stacked chart… and the percentages are correctly displayed on the bars by default. However, when I hover over a value in the legend, it will show what appears to the be value of the Y Axis (expressed as a percent). So for example, Email should be around 2-3% (as displayed in the first and second screenshots),…
-
Is there a way to organize the order of sub-dashboards by default for users?
I know how to adjust the order of your dashboards and sub-dashboards as you see them… Is there a way to adjust the order for other users who view your dashboard series with sub-dashboards? I'm fine with them adjusting later to their own preferences, but would like to have a prearranged order by default when they first view…
-
card design troubleshoot
I'm trying to recreate an excel graph in Domo. I have attached a screenshot of the excel graph I am trying to recreate. They are needing the week number on the x axis, and the distinction between the vertical bars represented with the blue and orange colors. The vertical bars represent net shipment (shipment less returns).…
-
Unabbreviating a number in a single value card
I can't believe I'm asking this question… but is there a way to unabbreviate a number in a Single Value card? I want it to say 1,253 - not "1K".
-
Scatter Chart
I would like to create a card that shows the revenue we make from each customer in a scatter chart where the size of the bubble depends on the profitability of each customer. i am very new to Domo so please bear with me
-
How to "Improve" the Histogram Chart
I have always struggled with the histogram barchart in Domo. I love the idea of the histogram, but I always end up with very odd bucket ranges. You also don't get an option of adding a series to that chart. Here is an example of a histogram I am talking about: My "improvement" is to use the scatter plot chart type. For my…
-
Multiple date filters on single Dashboard
Hi... I have created Dashboards with Multiple Date filters. Effectively the top half of the dashboard uses DataSet_1 and the bottom half of the dashboard DataSet_2 ------------------------------------------------ [ Date Filter ] for Cards A, B and C using DateField_1 from DataSet_1 [ Card A ] [ Card B ]. [ Card C ]…
-
Displaying effort per day
My Task Management data contains 1 row per User Story. Each row will contain start date, end date and estimated effort (which will likely be less than the story duration, e.g. Story starts on Monday, ends on Friday and will take 10 hours to complete). A row would look like: ¦ Program ID ¦ Story ID ¦ Start Date ¦ End Date ¦…
-
How to select which Metric should go on Line in a Line + Bar Graph?
I have a chart where one Metric is $ and rest all is Numbers. How do I graph it in a way where the $ shows as Line and other show on Bar graph. (Like how in Excel we do a secondary axis) In the picture below, its taking the 1st one(USB requests) as Line while I want to show the Red Bar as Line with $
-
Exporting Report to SFTP Server
There's a particular table-style report that we need to publish to an SFTP server on a weekly basis. Currently, we have to email the XLSX or CSV file and then manually upload it to the SFTP server. Is there any way to use Domo to schedule and submit files to an SFTP on a regular basis? I see that there is an SFTP writeback…
-
Charts/Graph by
I want to display a bar chart with X axis = location and Y axis = total hours for each location but I want be able to view the data by month, week and day. I do have a date column. what is the best way to do this, the graph by option is not working.
-
How to make bar or column chart colors dynamic when changing dates?
I have this chart where I have several categories on x-axis so I'm finding a way around for the least cost to be blue and the highest cost as red whenever it changes dates and the rest say gray
-
Formatting on cards
Is there any way to manually select where the numbers are displayed on a bar chart? I've got 11/12 months that dont conflict with display data but 1 month that is throwing the rest off. Is there a way to manually take care of this? I need all of the numbers to display from left to right - not top to bottom.
-
Filtering based on profile and Hierarchy
Hi Peers and experts. I'm working on a solution where we have to implement card content filtering based on the profile of the Domo user. We have PDP in place of content filtering but we are also looking to filter at drilled down level by default based on user profile and Hirerachy Suppose for a sales chart there are 4…
-
Is it possible to add both lines and symbols to a stacked bar chart?
I have a stacked bar chart with 6 lines, but I need it to be a stacked bar chart with 3 lines and 3 symbols. Specifically, I need the 3 black lines seen below to be symbols. Is this possible in DOMO?
-
Creating a Manager Span of Control Chart
How would we go about creating a table that shows manager counts from the top down. For example the CEO has 6 Chiefs that report to him. The CHRO below the CEO has 2 direct report managers, who each have people they manage. How could we design a report that could start out from the top showing the CEO with a headcount of 6…
-
Is there a way to map more than 2 lat/long points for a route?
current lat/long route map only allows for 2 points, is there a way to include additional lat/longs or another chart that would show multiple points along the route?
-
Period over Period Visual, YTD, 2 Day Delay with Current Date Data
Hi all, I'm leveraging the period over period charts and comparing the year to date progress with the progress from a year ago. Unfortunately, there's a two day delay in when the data comes in, and the historical period data isn't reacting to that. Is there a way to address that while still using the period over period…
-
Charting 2 Different Measures Fields
Hoping someone can help me. I'm working with a dataset that breaks out the Number of Questions asked (by users) as two different measures fields (in screen below) as: NoOfAudioQuestionsAsked NoOfTextQuestionsAsked I don't have access to the lineage to change this dataset and must work with it. Is there any way to bar chart…
-
How to compare last 28 days with prior 28 days?
Hello, I'm trying to compare the number of sessions in the last 28 days with the number of sessions in the 28 days prior to that. How do I accomplish this with a period-over-period multi-value chart? This seems fairly straightforward in google data studio But it seems like I'd have to create BM in Domo based on some of the…
-
Is it possible to use a value other than Category in the Outline view of a Gantt chart?
I want to display the rows per Program and Feature (i.e., the category), as in the outline view of a Gantt chart, but colour-code by pipeline status. Gannt automatically uses the category field to colour code, even when custom colours are specified. Is there a setting to override category colours with custom colours?
-
Multi value chart with % and number
I'd like to create a card that looks like this. Shows the percentage (of records with a certain value) along with those relative numbers over the total number of records. Is there a way to do this?
-
Help with a nested Bar chart
So I have a data set that I have the month and the total number of invoices and then breaking those out by type. When I to the nested, it is giving me the sum of each type plus adding in the total, giving false info. How can I fix this. See attached. The farthest left is my total, but the group total is adding that in…
-
Zoom Feature in Tables
Is there any way to make the Zoom feature (+-) move when viewing a table from full view in a dashboard? When you don't have a summary number it blocks part of the table. Here is an example from the Varibales dashboard in the Community Domo instance.
-
Pivot table field total and sub total options
I created a pivot table and I noticed that the fileds now have options to hide totals and sub totals. But when I check the options, it doesn't seem to do anything. I have columns "division", "category", and "subcategory". I have sub totals enabled and I want to add the item number and the item description. However, now I…
-
Is there a way to exclude dates from outside months in the MoM comparison?
The current month is March and I have a chart showing sales data graphed by day and when selecting the MoM comparison, dates for March are showing up under the comparison for last month since February had only 28 days which is making our sales for last month seem much higher than they actually are. Is there a way to…
-
DDX Column Order
why is it that the DDX re arranged the order of the columns example. i have a ddx and the column order is as decribed below but the resulting array anyone know how to maintain the order of the columns or is this another domo feature
-
Can you include video in an HTML table?
Hi there, I have created an HTML table card that displays images (not links to the images but the actual images themselves). I've used a case statement because the dashboard the HTML table card is on gets filtered by category. Here is the generalized beast mode I made to display the images: CASE WHEN 'Category' = 'C1' THEN…