-
What's the best way to clean up dashboards?
I want to see how many times a card gets an interaction. My department is hoping to clean up how many cards were created, but I don't know who is using what card, is there a way to see how many times a card is viewed and how often?
-
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
-
Why is my beastmode to bring in Salesforce Profile Photos not working?
I'm using the html code referenced in this Domo Article: Our salesforce rep profile photos are being brought in as a url starting with "https" into a user dataset. I'm just not understanding what is wrong with the beastmode that it's not bring up the photo when I place the beastmode as a column on a table: CONCAT('<img…
-
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