-
To show entire label on bar chart
Hi Dojo family, Is there any way to show the entire label when it has long text like in this picture? When text is too long, it doesn't show the whole text :/ @MarkSnodgrass @GrantSmith
-
Beast Mode Help
Help, my brain is stuck. I am trying to come up with a BM that will filter my data. I have an orders dataset and for some reason someone chose Wednesday as their reporting day. I want to show that if the day is Wednesday then we will show orders from the current Wednesday to the past Wednesday. But if we have not reached…
-
Beast Mode
Hello Dojo! Does anyone know what I am doing wrong here. Thank you!!! case when `Union_Class` = 'A1' then case when `Class` IN ('A1','A2','A3','A4','A5','A6','EO','TB','TA','J','SF','F','SGF','GF') then 'Normal' else 'Error' end else case when `Union_Class` = 'A2' then case when`Class` IN…
-
Share Of Market
Hi, People!! Here i am with more problems... In order to show S.O.M. to my client and knowing that DOMO loses the reference of entire base when the user filter globally, we create lines of totals ($ sold for month, category, etc) that will be used as denominator for % KPI. My problem is: thats a way to select more than one…
-
Line chart in relation to zero values
I just noticed a line chart I have has the lines connected directly to the next available date with data... which is misleading because it makes it seem as if there is data on the dates in between. In the screenshot below, the value for 1/31 is 4 and 2/13 is 2.... however 2/1-2/12 is 0, but if you're looking at the line…
-
Beast Mode to add two values from the same column
I have a column that is showing different periods. the column breaks them out in 0-10,11-30, 31-60. Then there is a column called 'values' with the correlating value for those periods. What I am wanting to do is just add together the 0-10 and 11-30 periods together using a beast mode.
-
Beastmode Formula - Not calculating / populating
Hi - I created several beast mode formulas (TQ, LQ, QoQ %). When I add TQ and LQ to a pivot table chart, there are no issues populating the results. When I subtract TQ from LQ, Domo seems to not want to perform that calculation. I can add TQ to TQ or LQ to LQ and that works. Is it a Domo performance issue? Eventually I…
-
Drill from global view to country view
I have data with countries and state/city and trying to create drill on map chart from global view with data by country, to country view with data by state. However, I could only drill with one country. For example, I could only select US in country view, but can't drill to Australia map. Can you please help?
-
How do I filter on two dates?
Long time lurker, first time poster here. I need to create a metric within either the ETL stage or directly in the dashboard (I suspect it will need to be don at dashboard level) for meetings attended. It is calculated as: Count of Marked as done date within date range AND Due date within data range So for example if the…
-
How to hide gridlines on table card
I have a Mega table card with 10 columns. Is there a way in Domo to hide both horizontal and vertical gridlines from the table and just keep it on header ?
-
Adding a MOM or YOY value in top of card
Is there a way to incorporate MOM or YOY comparisons within cards? Similar to the visual below (which is in Power BI)?
-
Is there a way in Domo to show/hide columns in a table type of card ?
so I have a table card which has 10 total columns (i.e. column 1-10). I want to give an option on my end application (where I would embed my dashboard) to user to see only selected columns dynamically in this table. So a user can select that I don't want to see column 5 and column 8, so this table should hide those 2…
-
Fill In Missing Dates option in Grouped Bar Chart
Hi the option Fill in missing dates is available on the X scale in the non grouped bar chart , but i cannot find it in grouped bar chart . its generating a scale that i do not want in the grouped bar chart option. can some one tell me where to find this option in the grouped Bar chart. i am assuming the attributes for all…
-
Calculating percent of total with values that count in multiple categories
I'm trying to develop a card for diverse business participation reporting. A single business may have multiple diversity classifications, and can be counted towards each. However, when we are looking at the total, we are looking at the total of distinct businesses. Example data: I want the card to have flexibility to…
-
Increase width in ComboBox component
Hi everyone! There is a way to increase width of ComboBox component to fill all extension of component? We use to show a description field where the length of text is much higher of the width of component
-
Can you combine 3 different columns in a pie chart?
Hi, I'd like to display the percentage of hard, medium and easy clients per PM in a pie chart. Is it possible to write a beast mode which can be used to combine the data? Thanks, Katie
-
Count how many Providers submit a range of cases
Hello, I am trying to segment our Providers by how many cases they submit. I have the formula below but I have something wrong. Ideally it will tell me how many Providers submit between 1 and 10 cases and 11 to 20 cases labeled them as Provider 1-10. This count will change throughout the year as they continue to submit…
-
Is it possible to set 12 complete months rolling date range?
I need to show completed months data only in a rolling 12 month cycle. Is this possible using date range filters? "Previous 12 months" includes current month which is incomplete and not required. I'm using between dates at the moment but this means I have to remember and change them the beginning of every month.
-
Period over Period (MOM/YOY) option in Multi-Value card for 2 months prior
I am building a dashboard that only shows completed months' worth of data. A few of the datasets I have though provide lagging data.... so for their specific cards, I just want to show data up until the prior month. I have created multi-value cards to show the MOM and YOY trends... they work when I have a completed dataset…
-
trends ratio for last 4 months
Hi, I created this card last year and it was working fine but as the year has changed and I'm working with 4 months data so 2 are now in last year Nov & Dec and 2 Jan & Feb this year. I tried working with Rank & Window function but running into problem with ASC and DESC My second pic in Yellow is how I want the results.
-
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).