-
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…
-
Fixed Beast Mode for Percent of Category
We're trying to get a percent of the total for each series category on this chart by using a fixed function beast mode: We're displaying the number of unqualified leads on the y axis and using the fixed beast mode as a tooltip field used in the data label settings. On the 27th the % should be around 23% as the total leads…
-
Stack-Bar Line Graphs
Hello, I'm trying to create a Stacked Bar Line Graph where I am able to have a the below bar graph broken out by month with an additional line graph, that graph consists of revenue numbers split by whether they fall under one of two catagories. The line graph I am trying to add would be a count of all the opportunities…
-
Can you do a running total in a pivot table?
I have some data that I'm trying to run in a pivot table. I've got it laid out the way I need it, but I would like to see a running total. This is what I have currently, If you look at the 0ME unit, it should read 96.77% | 96.77%| 97.23% | 97.23% | 100.00% This is easy to do in a graph with a running total, but I can't…
-
Is there a way in Domo to show/hide columns in a table type of card ?
so I have a table card which has 10 total columns (i.e. column 1-10). I want to give an option on my end application (where I would embed my dashboard) to user to see only selected columns dynamically in this table. So a user can select that I don't want to see column 5 and column 8, so this table should hide those 2…
-
Image Hosting
End Goal: I want to display a sales rep's headshot next to their stats on some "Top 5 Producers" style cards. I'm familiar with the HTML code to do this, and I know I can put these pictures on a free online image hosting service to do it. But my IT department would probably "expel a kitten" over this because they treat…
-
Is there a way to annotate tables?
The user wants to be able to annotate values in a table (such as below). Is there a way to do this? Basically, she wants to provide some note on particular cells.
-
Facebook Business Manager Connection Issues
I working for a marketing agency and all of our clients accounts are connected to our Facebook Business Manager as to which I am an admin for. When I login to facebook to my account I only see 1 page show up and that is the agency I work for. Any thoughts or ideas on how to get this figured out?
-
Put date in order
I was using group by in my data then the date just mess up :( How can I put them in order? Thanks everyone
-
Comparing year on year figures
Hi, I'm looking to compare yearly figures from ‘Contractor Completion’ from 2019-2023. We'd like to know the percentage change for YoY and comparison by month too. The flex table or line chart looks like a good way to show this. What would be the best way to do this?
-
Top Sales Week by Closer
The objective is to get the closer's best week of sales without creating an ETL as we want this to be dynamic with the date range selected on the card. We have a list of sales (each have a unique opportunity Id) with project sale dates and closer names. I had thought this formula may work but I'm having issues: RANK() over…
-
Schedule Report - Weekly data report every Friday
I am trying to schedule a weekly report that would be sent out every Friday morning for data between the previous Friday and Thursday of the current week (7 days/1 week). For example, data range is 3/3/2023-3/9/2023 for this week's report, whereas next week's report would be data range 3/10/2023-3/16/2023. Is there a way…
-
Magic ETL Joins - include table name as prefix
Hi All, When joining tables in the MAGIC ETL, how do I include the table name as a prefix for the columns? Sometimes the 'Select Columns' transformation offers a rename suggestion in the format, 'TableName.ColumnName' but it is not always suggested and requires using the 'Select Columns' transformation before each join.…
-
Writing a Case Statement select another field value if primary field value is blank
So I am trying to write a Case statement to select a different field to pull a value when the primary field has a blank value… Something like: CASE Parent Carrier ID WHEN 'null' THEN Carrier Name ELSE Parent Carrier Name END I don't know what to enter as a valid term for ‘null’ to represent looking for empty values?
-
Cards - BeastModes Need to Know the Dates that are selected by the user (card/dashboard level)
I am always trying to find a way to detect what the user has either selected for a date on the card or the dashboard when building my BeastModes. Can Domo not find a way to pass this in as say a Macro or something. And I am saying Macros for both the card and dashboard level date selections
-
Export to PDF error - images
I have a dashboard that displays information with a field containing a person's id. On one of the cards, I display an image of the person. The card uses an html table to display the person by calling an image url. When I try to export the dashboard to PDF, the export fails. If there any way to tell Domo to ignore a card…
-
How to hide columns in table report which are not having any values
Hello Team, I have a requirement in the table chart where columns are months like Jan, Feb,Mar,.. , Nov, Dec. I need to hide column months which are not having any values inside it