-
Filter top x per id
Hi All, I will just draw this as it will be easier to understand. I have alist of account with revenue atatched per country bu I only want to show the top x countries in revenue (top 2 in the example below). My tab is already sorted by Account and Revenue: Here is what it looks like now:…
-
URL action from Domo to SharePoint to auto-populate data
Hello Team, We’re presenting tomorrow morning and need some help ASAP please. See below for details and attached for snap shots. I’m trying to create an action with Domo like how I do in Tableau. In Tableau I create a URL Action with a dashboard that auto populates a report in SharePoint. Is this possible within Domo? See…
-
Map learning
I'm trying to use map for the first time and it seems that I have the basics, but wondering if there are few things that would like to do and maybe Domo can do it as well. 1. I have my table where I have full address, city, zipcode and location. GOAL: would like to have zipcode location colored by their location, but can't…
-
placing a photo or JPEG in a card
Anyone know of a way to embed a photo or Jpeg in a card, like the background?
-
Page filters vs. card filters giving different values in charts
Hello, I have built a dashboard with several cards on it. I want to apply a filter to it, call it Filter A. When I add Filter A as a filter to the dashboard and choose "select all" (so that nothing should be removed from the dataset), the values in my charts for # of Widget A and Widget B decrease. If I remove this filter,…
-
Ungroup "Other" Category
I want to remove the "other" grouping and show the names of the salespeople (there are 4 grouped in the "other" category) - is there a way to do this?
-
Domo Stats: how to filter out inactive licenses
I'm looking for a way to no longer count inactive licenses in some cards. Is there a way to do this? There's no value to me for including people who no longer work at our company in cards such as "User Inactivity" or "Most Active Users".
-
Calendar Showing System Down Times
Good morning, I am currently working on a card for our IS department that shows any System outages/downtimes using a calender card. As of now, I am calculating the total numbers of days down and reflecting that on the calendar dates (day will be appear more red if the system that went down that day was out for a long…
-
Add a vertical line to a line graph
My data returns the amount expensed per month for the past months. The current month and remaining months for the year show the projected remaining budget. Is it possible to do either of the following? - Add a vertical line on the current month to show that the line is now showing projected budget, not actual amount…
-
Only using data from latest append
The dataset I'm using is appeneded to once a day (but at somewhat irregular times), domo has created the columns _BATCH_LAST_RUN_ and _BATCH_ID_ to show this. I want to create a card using this dataset, but I only want to use data from the latest batch. What is the best way to do this? Thanks.
-
Time series plot with Primary and Secondary axis
Hi, I have below data; DateCategoryValue02-08-2019Cat11002-08-2019Cat22002-08-2019Cat33003-08-2019Cat111003-08-2019Cat2-22003-08-2019Cat323004-08-2019Cat13004-08-2019Cat24004-08-2019Cat340 With this data I want to create a time-series plot with below properties : * Cat1 and Cat3 will be plotted with the Primary axis and…
-
Maintenance Indicator Cards - Bad Data Loads, etc.
I am curently tasked with creating a new dashboard in which we can monitor wether or not our data is updated and reliable or if we had an issue with loading the data into Domo. Currently I can only think of joining data with a calander to create a graph and see if any of the days are blank. I was wondering if anyone else…
-
"Other" bar for averages
I'm building a card that displays the average value of a field in single bar graph. I'd like to limit the number of bars that are shown by using the "Maximum Bars" option in the chart properties and use the "Other" bar to show the average of all the remaining values. However, the "Other" bar appears to add up the averages…
-
Adding background image to embedded cards
Hey all, I'm having a bit of trouble trying to figure out how to add a background image to a card that is powered primarily by beast mode calcuations. I've endlessly searched the forums and have not yet been able to come up with a solution. What I have is a matrix with 4 quadrants that need to be color-coded and labeled.…
-
displaying a zero value on a bar chart
If I have a bar chart where I'm graphing the volume of something monthly and one of the months doesn't have any data so the bar displays, Jan 2016, Feb 2016, Mar 2016, Apr 2016, then May is missing..... Can I zero value be shown in any way? thanks for any help provided
-
Problem with grouped and stacked chart. Need Help
I am pretty new to Domo and could not find a way to do what I am looking for. I would want to group the data by country (grouped age field) and then stack the survey results. Here is an example of what my data looks like.
-
iam sharing a page but my saved filter is not shared
iam sharing a page but my saved selected page level filter is not being shared can anyone tell me why and is there anyway i can share my saved page level filter along with my page. thanks in advance. any suggestions are much appriciated.
-
How to insert Line + Grouped Bar ?
How to insert Line + Grouped Bar ? Please Suggest me steps
-
Filter link to a new page but did not pass to another dataset
Hello, I am using page Analyzer Links to bring to a new page based on a camapign name. However, in the new page, I have a few cards built from another data set. The filter did not pass to these cards although the second dataset has the same column name as the filter used. I allowed to interactive with all cards in the…
-
Export to Excel
This question is similar to Table Card export in that it is about exporting to Excel. I am trying to export a dataset / column as a hyperlink. In Excel, that could be a formula: =HYPERLINK(... The issue I'm having is that the export ALWAYS seems to prepend an apostrophe onto the formula, just before the equal sign. Any…
-
Exclude Categories that total 0
Hello, I am looking to exclude categories on a pie chart when the total for that category=0. I tried creating a couple different beast modes using sum(`revenue`) over (partition by `department`) but they either do not work as a filter or break the card. I would like this value calculated on the fly because the date grain…
-
Card Drill Path with Different Data Set
I've got CardA using Dataset1 and CardB usind Dataset2. I'd like the drillpath for CardA to show CardB. When I try to accomplish this, I get an error about CardB having a different dataset than CardA. CardA is a list of all employees and their total expenses YTD. CardB is an individual employee and their YTD expenses…
-
Can data be grouped in a (non-Sumo) card?
I have a specific example of a general concept that I'm hoping the community can help me with. I am using Domo-provided sample data to build a funnel chart. The data is sample Salesforce data at the stage name/account name/opportunity line item level. I would like to build a funnel chart that shows the count of acount…
-
To create Pivot table based detail Report in DOMO
How can i create reports based on Pivot Tables bsed Detail Report same as used in Excel Sheets or SSRS Reports?
-
Pivot Table
Is there a way to do conditional formating based on another column directly in pivot table? Example: color in green if value in column A > then in column B Thanks
-
Bar chart- return top 10 rows by year
Hello, I have a dataset in excel with "year", "viewers", and "market" columns. Is there a way to have the top 10 markets (based on # of viewers) return by year for 3 years. For instance, in the "year" column, we have 2017, 2018, and 2019. Each year has its own bar column. I want the top ten "Markets" based on "viewers" for…
-
cumulative sum
Is it possible to have a cumulative sum for values in one column to show in another so that the final today would be in the last row? ex. in the attached screenshot If I wanted to have Total Revenue cumulatively sum and show each new value in a column next to it so the in the first row of 'Cumulative Sum' would be 19075…
-
Waterfall Graph Colours
Hi everyone, Is there any way to change the colours on a Waterfall Chart? I need to reverse the standard Red and Green as a negitive number is good and positve number is bad. Thank you for any help you can give me
-
normalized data multi line chart
I have several variables ( impression, cost, return on investment ratio) and I would like to normalize them to range from 1 and -1. Is there any way I can do it? Thanks
-
Interactive Filters on Stories
I have gone through various threads of interactive filter troubleshooting but haven't been able to find the answer I am seeking. If I am doing the interactive filter as a custom chart (SVG icons), does the dataset need to be the same for every card on the dashboard I am hoping to filter? Or is there a way to have one…