-
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…
-
Formula/Beast Mode Help
Hello, I'm stuck with how to write a Beast Mode/Formula that looks at two different dates. Here's the example: Employee 1: First Date Field = 12/02/2020 And their Email Date Field = 12/06/2020 Employee 2: First Date Field = 12/02/2020 And their Email Date Field= 12/23/2020 I want the Beast Mode to return 'True' if the…
-
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…
-
Tooltip text in a card
hello all, im trying to include a "tooltip text" in a card, to be more specific in the header of a column in a table card, is this possible in DOMO cards?
-
Using an interaction as a filter on another story page?
I have a card on a page that gives high-level information about a set of customers in a table. When one of the customers is clicked in a table card, I would like Domo to open another story page and use the clicked customer as the value of the customer filter. When I change the interaction to open another story page, it…
-
Beast mode adding two columns with conditions
Hello Dojo, I'm having trouble adding two columns with in a conditional case. The following works fine: SUM(`paid_total`) + SUM(`booked_total`) But then when I try to add any sort of condition, it fails: "An issue has occurred during processing. We are unable to complete the request at this time." case when…
-
Beastmode to categorise product revenue by average monthly revenue
We have a daily metrics table (updated daily to Domo) which records revenue per product per date. What we'd like to do is to calculate a rolling monthly average revenue per product as a beastmode, which is dynamic according to the date range selected by the end user in the card. This could then be grouped into custom…
-
Why is my card missing rows?
I have a card that only has 11,517 rows but the dataset feeding into it has 12,999. So somewhere between the dataset and the card, it's filtering out 1,400 rows. I don't have any filters in place, all I'm doing is specifying the columns that need to be added, and all of the columns that I've specified include data for the…
-
When duplicating dashboards, is there an easy way to update the prefix of all duplicated cards?
When duplicating dashboards, is there an easy way to update the prefix of all duplicated cards? When I duplicate a dashboard, all the cards are duplicated as 'Duplicate of [card name]'...but I want it to be '[New Dashboard Name] - [Card Name]'.
-
Sum One Check Amount with multiple rows of the same data by using DISTINCT ?
I am looking to ONE "CHECK AMOUNT" per distinct "first name" AND "check date". the data source has multiple lines for the same check amount, but i only want to count one "check amount" per "first name" and "Check date" this data is in DOMO but i just downloaded it to understand the layout of the data better. Any Ideas ?
-
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:…
-
Trend Line on a Bar Chart?
Is there a way to add a trendline to a grouped bar chart? I know that there is a chart option gor Grouped Bar +Line, but I'm stuck on what to do next. Any help would be greatly appreciated!
-
Struggling to write Beastmode that reflects current MTD values
I have a column of marketing sources where I am trying to breakout individual sources to be their own individual columns, and have them only reflect current MTD amounts. I have multiple YOY and MOM % and net differences in columns that interact with that date setting portion, so changing the date setting is going to change…
-
Business days in Date_Add Interval
Hi, I have a Beast Mode that calculates the estimated finish date of a process, depending on its type (new or renewal) and if it was started before or after 3 PM. My Beast Mode does this for calendar days, but I need the interval to be business days. We have a separate date table that flags each day for the next 5 years…
-
How to create a card with data from the calendar month before last
Hi, does anyone have any thoughts on how to create a card that contains rolling data for a calendar month that was 2 months ago? Example 1, If today's date is June 15th, card should show data for the whole month of April Example 2, If today's date is November 30th, card should show data for the whole month of September…
-
How to override the filter set on cards and calculate sum on a specified period and condition
How to add hardcoded dates that the amount is summed for a period specified, even when the chard is filtered on for different dates. e.g. I will like to always get the sum of transactions Type 1 between the period of Jan-01-2020 and Dec-31-2021, even when the filter on the card is set for Jan-01-2021 and Feb-28-2021 As…
-
Can we add growth% in Hovering?
Can we show growth% in Hovering of below bar chart?
-
How to customize position of labels?
I use variance bar line chart with year-over-year variance as the line. I want to show data labels for the lines but the labels overlap with each other. I tried to change the position and adjust all options in the data label settings, but the labels are still clustered together. Is there a way to separate the labels more…
-
Summary number for non-distinct rows
Hi, We have 4 sales regions & each has a budget amount. I need to do a summary number that uses the sum of those 4 budgets. 2 regions have the same budget amount so COUNT(DISTINCT) won't work. Each row of the dataset details an expense for a labeled region and that row also contains that region's budget amount (I joined…
-
Average of tickets by hour question
I have a card Daily Ticket Flow that has Count of tickets by hour for the previous week. My users want to see an Average of tickets received for that hour instead of actuals. I saw something in the old Community platform about Beast Mode using buckets and then averaging the bucket. Any thoughts? Thanks in advance! Michael
-
Help graphing a calculated field that sums up two data columns
I have a dataset that has daily data spanning back to the beginning of 2019. Let's call column A "Sales Date" Let's call column B "Daily Sales" Let's call column C "Employee Name" I then am creating a beast mode calculation for "Month" and "Year". I want to be able to plot in a bar graph the calculation, by month/year, the…
-
Single value card displays blank if specific date is selected in date range with existing data
Howdy, I'm still pretty new to Domo so bear with me. I created a single value card to display a sum of completed tasks for a specific shift and office (2 filters) for a productivity dash. The issue I am having is that the card displays blank if a specific date (feb 15) is selected within a date range under my 2nd shift…
-
DOMO Rank System
I have this card that I'm trying to rank by each month. It seems like it's ranking the numbers with both months, but I want them ranked individually by month.I.E. between 9 and 10 #9 is under Jan but #10 is under Feb. This is the beastmode so far. Rank() Over(order by COUNT(`Certificate#`) desc) Also is there a way to…
-
bulk updates to cards
Hello, I would like to remove a filter that applied to multiple cards. Instead of going to each card and removing the filter, is it possible to do bulk updates to all cards? P.s the filter is based on an actual field in the dataset and not a beast mode filter. Any responses will be greatly appreciated.
-
How to show top 10 contributors in any dimension field?
How to show top 10 contributors in any dimension field?
-
User access levels for drill path layers
Please let me know if it is possible to set up different user access levels for drill paths layers. Scenario: A card on shared page consists of a bar graph with company-wide term count by location, and a single drill path layer has been set up with a table to display the employee names along with other pertinent fields.…
-
Beast Mode: Table Card Total Row Issues
I have a beast mode I'm trying to use that calculates individual performance goals. Using a table card, and including total and subtotal rows. The first version of the beast mode was: (when sales dollars grow $2500 or more a 1% bonus is paid) case when (SUM(case when YEAR(`Date`)=2019 then `Sales Dollars` else 0…
-
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…
-
Count Distinct - it's counting blanks
Hi - I'm using COUNT (DISTINCT to get a unique count of ID numbers and there are some records where the ID number is intentionally blank. I want these records to be excluded from the count entirely but this function seems to be counting 'blank' as its own unique value and is therefore adding 1 to the unique count which is…
-
Can we add notes in Domo Chart?
I want to add notes in chart . Can we do that?