-
Card Drill
Hi guys! Do you know of a way to arrange the columns for the drill view? I know you can arrange the columns as a user and an admin within the drill view, but it does not save, so I am looking for a permanent solution. Thank you so much!
-
Dimension/metric selector for Cards
Hi, I wonder if there is a way to build a table card with an option to switch between dimensions/metrics to display. Let's say there are Revenue and Sold Items metrics, so I'd like to have a table card providing a break down by regions and an option for end users to choose which metric they want to see (I need just one).…
-
Original, historical dataset of recursive dataset still needed after 1st run?
Sometimes when we bring in a new data table into DOMO, we'll want, for example 5 year rolling history. And instead of pulling 5 years of data every day, we pull it once, feed it into an ETL output, then change the input of this ETL from the original 5 year dataset to the new output. then append a 1 day update. My question…
-
Can we use Partition by function with Case statement in beast mode?
Hi, I wanted to achieve the below screenshot data via beast mode. For each token id, whichever column (B,C,D) has non zero value, in the Merged column, I wanted to get that value. I tried case statement, say Case when A=0 and B=0 then C when A=0 and C=0 then B when B=0 and C=0 then A end This is not giving me the correct…
-
Heat map tables - Ranges per column
Hi, I have a table with multiple columns and different sets of numeric data and would like each column to have a heat map applied to identify the quintiles. I have tried a heat map table but it seems to apply a single range across all of the columns. Therefore the range spans the columns with the highest values down to the…
-
Colour Rules while comparing two columns.
Hi Team, Your support is highly appreciated in advance. Could you please advise/suggest how to apply colour rules based upon dynamic targets in 'Line Grouped Bar Chart'? Thanks Rabia
-
Is it possible to create a combo chart in the tiles?
I cannot create combo charts for the tiles (like you can in excel) where I can select the data for each axis, the data is automatically assigned (mostly to the wrong axis) or i cannot assign it at all. Is there a way round this? Can anyone help with this? Thanks
-
Scatter Chart - Drilling Down
Good morning, I've attached an image of a card a user has built using a scatter chart. The X Axis represents the day of the week, the Y Axis is the amount of hours it takes for blood products to go from collected to labeled, and the bubble size is the count of products that land in that hour time period. When we want to…
-
Can I nest a Select Distinct function in a beastmode?
Relatively new to all of this, but I'm working on a beastmode that calculates the average tenure of active employees within my company. The data I'm pulling from includes a lot of duplicate system id's (employee id's). I need to filter out these duplicates in order to get an accurate average. I've written the formula in a…
-
Create a card/text field that simply says the last month on a dashboard
I have a dashboard set up to review the last month. Is there a way to simply get a header or text box in the dashboard that identifies the last month? (each month, it will automatically change - so today, it should say February 2021 and on April 1, it will say March 2021).
-
Multiple Date Fields and Filters
I have one table with two date fields: date-1 and date-2. I would like to configure two filters such that filter-1 operates on date-1 and filter-2 operates on date-2. Is this possible? My experiments so far have yielded inconsistent results. I'm not sure how to control the mapping between dates and filters. Thanks!
-
Is there a way to show 0 values in line graphs?
Hello! I am looking for a way to continuously graph data, even when there are 0 values. When creating cards, I see breaks in line graphs when there is NULL data. Any ideas?? Thanks, Keirsten
-
Best option for YOY comparison showing where we are now to that same period last year?
I am trying to show a comparison for total revenue for where we are now compared to where we were end of February 2021. toying around with different graph options isn't allowing me to slice and dice the way I want. It either is a line graph YOY by month or a progress bar that is using all of Last year and comparing it to…
-
Remove weekend days from calculations
Hi, I'd like to remove weekend days from calculating on time data. For example - 2 day turnaround to be met. Issued on Mon but started on Friday so would meet target but at moment is looking like 3 days. Could anyone help me with a beastmode for doing this - I have an opened and closed date. Thanks, Katie
-
Summary Number - "show more options" drop down is not displaying
When I click the drop down of the summary number in the analyzer the "show more options" tab is not showing up under "No Summary Number" Does anyone know the problem or how to resolve? Thanks
-
Grouped Bar - Hiding bars at dashboard view
I have a Grouped Bar card. If you go into card view, you can click on the name of the bars in the legend to hide/show them. However, from the dashboard view, clicking a bar name in the legend doesn't do anything. From the dashboard view, is there anyway to hide specific columns? Could it be done through a filter card, or…
-
Adjusting a decimal to be used as a summary number
I have a column that calculates a %. in the dataset it reflects like 94.965, 97.245, etc. which works great in any card. Now that I am trying to use it as a summary number I am running in to this issue: I can't seem to be able to get it to reflect 94.39%. it just shows this big ugly number. This field is a calculated using…
-
How can thousand separators be built into a concat() statement in a beast mode for a custom summary?
I found Creating a Custom Summary Number in the Knowledge base on https://domohelp.domo.com/hc/en-us/articles/360043430093-Sample-Beast-Mode-Calculations-Card-Element-Transforms. I have built a custom summary number with the below beast mode that results in "75740929.28 Part Sales Net - February" Is there html code or…
-
How to ensure data for each month gets displayed in one row in this table chart instead of2rows
Beast mode used Approved Shifts = CASE WHEN `Approved` = 1 THEN SUM(`Total Charge`) ELSE 0 END Unapproved Shifts = CASE WHEN `Approved` = 0 THEN SUM(`Total Charge`) ELSE 0 END ST = SUM(`Total Charge`) Kindly advise what could be done to rectify it. Thanks
-
How to break up a page
Is there an easy way to break up a page when the content gets too long (which prevents me from exporting into powerpoint/pdf)?
-
Issues with cutoff characters at top of series for scatter chart
I've built a scatter chart and am having an odd issue with some weird noise at the top of my legend... This appears to be the result from putting a Tooltip value for data labels. And it makes the chart look very amateurish. Can anyone advise on this? See screenshots below. The first shows the issue I'm having... And this…
-
Adding comments in Beastmode calculations
This is a stupid question... but how do I write comments in Beast Mode calculations?
-
Survey - Count the answers.
If I have a survey and user can choose multiple answers and also have the choice to write. How can I count every option that the user has selected. Results should be like this. Red 3 Blue 2 Green 1 Orange 1 Pink 1 Yellow 1
-
How to remove Scale Marker
Hey Domo family, I added scales on my graph, but I couldn't remove it or reverse it back to the original one. Is there any way to get it off from my card? @GrantSmith @MarkSnodgrass
-
Maximum Number of Rows that Can Be Displayed on a Card
In a card, the data display is limited to 100,000 rows, but if the DataSet has 1,000,000 rows of data, does anyone know which of the following will happen? 1) If the data after filtering is within 100,000 rows, it can be displayed normally. 2)Regardless of the content of the filter, the error of over 100,000 rows will be…
-
Failed to load alert configuration?
Has anyone had this error before? I was able to set up the alert on the card. Now it's saying this when I was going to edit it. I have a summary number. I have changed chart types. (I thought domo called them cards btw?) But still not working. I deleted an alert with a similar problem. Created a new card. Set up this…
-
Include Data label for just bars, but not line
For a bar and line chart, is there a way to have data labels for just the bar - but not the line?
-
Changing color of line in line chart
Can someone please tell me how to adjust the color of a line on a line and bar chart? And also how to adjust the axis values (so the Y axis match their respective color - line or bar)?
-
MAX on dimensions on card build
Hey. I am building a card and I am aggregating data over time (ie last X days). I have this issue that I want to use MAX aggregation on dimension field, but only aggregation DOMO allows for this type fields is count. Is there a way to use MAX on these fields? Example Fields: Date, Id, name, spend Row1: 2022-01-01, 1,…
-
Color rules gone from Cards
Hi all, today I opened one of my dashboards and the Color Rules seem to be gone. I did not edit anything. Anyone else had same experiance? What could be the reason? The only thing that happened is that I run the data pull from Salesforce, but nothing on dashboards or the cards.... very strange. Thanks for any input.…