-
How to Create Monthly Averages for Headcount?
Hi All, I'm in the process of building an attrition model in Domo in the form: Total Terms / Average headcount Terms is easy, that's just a count of everyone with a term status for that time period. Headcount is where I'm getting stuck. My headcount numbers are currently aggregated based on headcount at the end of each…
-
Reconnecting Disconnected Output DataSets and Cards
We are developing under several accounts (e.g. Dev1 and Dev2). In order to organize the ownership, I have changed the ownership of some pages and cards to one account (Dev2 > Dev1). Then the connection between the DataSet and the card got disconnected and the card is no longer visible. For the card with a direct connection…
-
Is it possible to create a graph with categorical levels?
Hello! ☺️ I have this card in which every number (1-2-3-4) represents 4 possible levels of a scale (1-> Insufficient, 2-> Regular, 3->Sufficient, 4->Outstanding). Is it possible to create this card but with categorical levels so the card doesn't show 1, 2, 3 and 4 but the categoribal words?
-
Recommendation for best way to create this visualization
I have 2 columns 'years old when moved in' and 'Length of stay in Days' What I am looking to do is create a card (histogram?) that will take the ages and put them in buckets then show an average length of stay in days for each of those buckets. I already used the histogram to show the distribution of ages as a count, and…
-
Where can I find the logic for custom built dimensions?
Hello, I'm having an issue tracking down where, exactly, I can find the logic for these custom-built Dimension Segments. Any tips for where I might find it? Thanks!
-
How to use a calculated field in a SUM function? (Statistics)
Hello! Please someone help me with this error! 😥 I am creating a table (card) with the mean, variance and standar error of a data column named "Score". The mean is calculated like this and the value is 6.67: If I calculate the variance using the value of the mean it works: That's not the idea cause the mean can change, but…
-
Custom Month Filter for building cards
Hello! I am currently building simple gauge cards that show sales for today, week, and month vs our goal for each of those. (see screenshot) Is there a way for the 'This Month' card to have a custom date range each month and have that automated so I don't have to change all the cards each month to a new date range? I work…
-
How to aggregate CASE Statement values?
In my dataset, I have three different tests that aggregate the field Forecast differently. Here's a beast mode I made that works pretty well, except when I'm trying to add them all together: CASE WHEN Test = 1 THEN SUM (Forecast) WHEN Test = 2 THEN SUM (DISTINCT Forecast) WHEN Test = 3 THEN SUM (DISTINCT Forecast) END when…
-
Help with Beast Mode field please!
Hello Community, I have a beast mode field that is working great when I am using a single number chart looking at the total for the current quarter we are in. The problem I need help with is, what can I update or what am I missing from the below Beast Mode field that will not allow me to show each month in the current…
-
Please I need help with setting up a retention chart
Hi Domo gurus. I'm trying to create a "line + grouped bar chart" similar to the ones attached below. My goal is to create a chart that shows monthly cohorts of users who have made '100 api calls" and showing x% who returned to make other 100 api calls at the interval: 31 - 60 days, 61 - 90days, 91 - 120days, 121 - 150days.…
-
Can you Insert multiple X-Axis?
I'm attempting to build a new chart where there are multiple columns with a single value for an individual. I know this isn't an optimal data set, and I've reworked it for another dashboard, but I would like to keep it in this format if possible. I believe other data visualization tools allow you to add multiple x/y-axis…
-
Data label on Variance graph
Hello, Is it possible to change data labels on a variance bar line? Can't seem to find any option to do so. Thanks!
-
Does anyone know how to build this card in the covid dashboard?
Does anyone know how to build this card?
-
Separate metrics on Multi-line Card?
Am I crazy, or did we lose the ability to put a second metric in the "Series" section and have it display as a second line rather than the second metric being used as a true series? I'm trying to move an old card to a new dataset, and I've now lost the ability to have multiple metrics on a multi-line card? What am I…
-
domo.onFiltersUpdate() does not exist in domo.js. domo.FilterContainer() gives error. Any solutions?
Thank you for your time viewing this post. I have 2 issues ongoing in one of my projects. The description of these issues are given below along with their errors. If anyone helps me in resolving them, ill be grateful. domo.onFiltersUpdate(console.log); This function is rendering me this error: code.js:60 Uncaught…
-
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…