-
Trying to add percentages in a pivot table
Hi, Would anyone be able to help me with the following: I'd like to have my pivot also show percentages of these two columns, I managed to get it to look like the bottom part however when I add a new column in the pivot it says the processing has not worked. Not sure how to add in the percentage? Thank you!
-
Drill Path from same Dataset returns zero value
Hello Dojo! Basically, I have a page that shows the most viewed pages, what we want to see in the drill path is when we drill down, the most viewed cards on those most viewed page. when I do it from separate cards, I can show them fine, one card has the most viewed page the other the most viewed card. they are using the…
-
Possible To Update All Cards On A Dash At Once?
Hi - seeking recommendations on a faster/better way to update datasets and dimensions for all cards on a dashboard. Currently clicking through each card (80+ on one dash) to update to a new dataset, and also to remove a filter. Going to add a dash-level filter once all the card-level filters are removed, but wondering if…
-
Displaying a single row on a card
I'm in the process of building a drill down report. At the bottom I'm looking for a single page of Column names and text. Ex: Order #: 8675-309 Customer: Jenny Order Date: 2021-04-07 Any help would be appreciated.
-
How to add percentage in the pivot table?
Hi, I'm new to Domo. Is there any way how to add a percentage in the pivot table? So, besides the total, I would also like to know the percentage of each category. Thank you.
-
Birthday calendar
Looking for a way to put team member's birthdays and anniversaries onto a calendar card for the team to see. Thanks in advance
-
Aggregation by month with segmentation
Hi there. I am breaking my head about something that just feels so easy to get. Is there somebody who can help me out with this please? I want to show a bar chart grouped by month (please see example below). The bars then should be segmented into categories. The data is coming from the user activity in a tool. The idea is…
-
Progress Bar Gauge visuals
Is there any way to change the visuals of the Progress Bar Gauge? I want to display my data as a percentage but would like to use the visuals of the Filled Gauge rather than the Progress Bar Gauge. I attempted to create my card using the Filled Gauge option but it seems to only show whole numerical values rather than…
-
Period Over Period Nested Bar
Hey guys, I'm trying to create a week over week bar graph that shows the next 7 day production vs the last 7 day production. That is the easy part, I'm also trying to group the bars by our different locations. Below is an image of what I have so far. Is there an easy way to split up those total production amounts into our…
-
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…