-
Removing number abbreviation in line chart?
Hi All, I have a line chart where I'd like to display the Y-scale and amounts in the thousands, without the K or M abbreviation. Is this possible? For instance, $50,000,000 would display as $50,000K, and I can't find any way to remove that 'K'. Is a beast mode my only option here? Thank you!
-
Card setup
Hi, I am not sure if this is possible. In my attached image, the bars in the Y axis are a beastmode calculation for a percentage Below, in the highlighted section, a user is wondering if, instead of the %, it could instead show the denominator of the percentage It does not seem so as the "data table" section in chart…
-
How do I show a delta value for specific bars in a stacked bar chart?
I need a waterfall chart that supports stacked bars. Since DOMO's waterfall chart currently doesn't support stacked waterfalls I'm creating a waterfall effect using a stacked bar chart. For example: This requires me to duplicate the data from the first bar to the second bar and then visually hide it. However, I don't want…
-
New addition to Webform not flowing through all dataflows
I have a webform that houses in different columns site level details like store name, Region, and Site ID's across multiple sources. I use this to join with datasets so it makes it easy to filter for things like Region and Site's. I recently added a new site, and all the other details to this webform. if has flowed through…
-
Change the value when hovering over a bar?
Good afternoon, Is there a way to change what's being displayed as the bar values in the image below? Ideally, I'd like there to be the current hover over Percentage of Category (94%, in the example below) to display above the hovered bar instead of the 8,105,205 value. Is that possible? Thanks, Joe
-
Adding a line on bar-chart
Hello, I have the following bar chart, it has some metrics and a target line that was defined under the "Scale Marker" section. I would like to add another point of data in the form of a line but I am not sure how to. Ideally, the card will include this other point as below: (sorry about the ghetto and bad drawing) The…
-
Comparative gauge and filters?
I am trying to build a gauge that shows a % for the currently selected company value in comparison to the % for the community as a whole. The problem i run into is that as soon as I filter the card to the current company, I no longer have the entire community's data to compare against? I don't see any way to just filter…
-
Important: Lifecycle of a domo created contents
Hello All, I am new to Domo. We have only one instance. I wanted to ask you how you have managed overall lifecycle of the created contents in Domo. Example : I developed one dataset/view in domo and 5 cards and I shared those cards to Biz team via story. Now enhancement requests come in which require dataset/view change…
-
Color rules - logic based on other columns
Often times with color rules, we want to base the color on the value of another column. Few examples: 1) There is a Value Column and a Goal Column: -When the value is greater than or equal to the goal, color Green -When the value is less than the goal red 2) Color the Value column by a calculation: -When the value is under…
-
Comparative Gage - What's wrong with my query?
Using the Comparative Gauge, I wanted to display our performance by whether the number of impressions have increased or decreased. Only, when I use the following window functions, I get a blank card with a downward arrow. Current Month: sum(case when MONTH(`Created Time`) = MONTH(CURRENT_DATE()) then…
-
Finding the Max Average
Can someone help me build a beastmode to locate the max average? I am trying to return the average day with that, on average, shares the highest value of the week. By taking the max average of days, with the max average of days with the highest values, is it possible to discover the day that returns the highest avg? I…
-
How do I preserve color in custom chart?
Since cell color options are lacking for pivot tables, I decided to use a custom chart. But when I upload my svg, all color information gets wiped. Is there a way to preserve it like the example that you have in your custom charts site for college campus map?…
-
Values showing as Number with K -how to remove/change?
Hi, I have a list of pressure values in psig and I am trying to show a histogram of the range and number of jobs we have done at these different pressure values. The issue is that the column is a number and when i create the chart, DOMO is picking up with psig value as a number and adding a K to it. How can I change this…
-
How do I calculate a row total?
My columns also have text and numbers. I want to sum the numbers, ignore the "N/As"
-
Generate an Average ignoring duplicate rows
I am trying to generate an average value for a single value card, The data has duplicates of this value due to other data within the set. In the example below, I am looking for the average number of seconds per customer. I need to be able to dedupe Customer 1, then average the remaining rows. Can this be done with a Beast…
-
beastmode help. Nuanced conversion rate.
I have a conversion metric that I use a beastmode to calculate it it's pretty straight forward. Rentals/Inquiries as can be seen below in the calc. sum(case when `unit_rented_c` = 'true' then 1 end)/count(`id`) Now what I am trying to do is take these inquiries that haven't yet converted to a 'unit rented', but are in a…
-
Table Card - Total to be % calculation rather than SUM, rows by week
Hello, I've attached an excel workbook showing a sample bit in its raw form, what I want to get out of that, and what I am getting. I'm primarily having two issues: Getting everything on 1 row by fiscal week. I can accomplish this until I add a percentage beastmode, then the rows will no longer be condensed to 1 row per…
-
Creating a static column that doesn't interact with the date filter.
I am working with Google Ads Campaign data. I want my 'Campaign' column to display all the campaign names and not remove any names when the filter is adjusted. other metrics such as 'click through rate' I do want to be able to interact with the date filter. How can I take my 'Campaign' column and make it static, so it will…
-
Is there a way to filter a card based on a sub-string in a text field?
I have a text field that is delimited by '|'. I would like a user to be able to use a quick filter that allows users to find a sub-string of the text field. Regions Covered Row1: North|South|East Row2: East|West Row3: West Row4: East|South I would like to be able to filter if a row contains 'East'. (Yes, I know I could do…
-
How to have a world map that enables selection (and drill-down) by continent?
Hi, I'm trying to build a card with values related to several locations across the globe. The drill-down path would consist of 3 levels: - Global level: a world map that would let me choose a continent. Displays data aggregated by continent. - Continent level: a map of the selected continent, which would let me choose a…
-
In a table card can I use a value to color code a cell?
Here is the example: I have a list of customers with 10 columns of data about the customer in a table. One of the columns is a boolean value (T/F). Instead of using a column to display that data, which takes a lot of horizontal space, I would like to have the customer name column change colors (ie: green background for…
-
How to set Maximum Items on a bar chart for the series data?
I have a vertical stacked bar chart with date (month/day) on the x-axis and the number of API calls per individual user as the series. Because I have a large number of users with very few API calls and a few users with a large number for each of them, I want the stack bar segments to just reflect the top 10 individual…
-
is it possible to add a constant in front of values in a column by using a beastmode calc?
I have an 'id' column in a dataset these id's are long and ugly. There is a constant URL that I want to be able to put in front of each value and have the column display this URL constant, followed by the id's. So it is as follows: Constant: https://xxxxxxxxxx.sugarondemand.com/#Calls/ Plus ID:…
-
104 Weeks as option in Multi-Value card
With so many industries moving to a 2-year CAGR in addition to their regular YoY comparison numbers, it would be great if the Multi-Value card allowed for a 104-week option as a quick way to build the change value.
-
2 Different Date Data Sets
I have a problem where I need to match up 2 different data sets to show funnel. Create Date & Demo Date. I need to show this data by week number. A demo date can be weeks after the create date. Here is my example: Data set 1 Week Create Count 1 10 2 20 Data Set 2 Week Demo Count 1 3 2 8 How can I merge these data sets do I…
-
SUM with multiple conditions
Hello everyone, I am having trouble with a DOMO Beast mode sum Calculation. Below you will find my existing calculation. I am looking to add the value of all records that have a date to Customer in column A and exclude those records in column B that have a payment date. Essentially I am looking to calculate the value of…
-
Exporting live cards to ppt.
I want to export a live card/ card table that is long and keeps updating as the dataset updates. The problem I am facing is whenever I am trying to export this card it only exports the snapshot of the card and not the whole card also since it is only the snapshot, it does not updates as the card in my domo instance…
-
How do I build a card?
Hello, I'm new to Domo. Wondering what best practices are for building cards?
-
How to add a Target line
Hi, I am looking at how much time consultants spent on the phone and the traget is about 20%. How can I manually add a horizontal line that shows 20%?
-
Beast mode to calculate month over month user count changes
One of the metrics we calculate as a business is our user change month over month. Our main data set we work off of is an activity log dataset which contains the date of the activity, the user id, and details about the activity. For active users we calculate the distinct number of users for that time period such as the…