-
How do I create a filter to show only the UPPERCASE records in a spreadsheet?
I am importing a CSV file. It has both UPPERCASE and lowercase entries in a single column. I would like to filter out all the records that are not UPPERCASE. The end result would be that all mixed case and lowercase entries would NOT be displayed.
-
Sum of two beast mode calculated fields
Can someone please help me with the below scenario: Where A and B are calculated fields. I have to show the sum of A and B in the card.
-
Running Total Group Bar - keep running total but show only current month, possible?
Hey all I have an end user that is requesting for a running total graph to only show current month but still retain the running total. When I filter for current month, it does exactly that, filters only to current month so the running total from the previous 2 months is lost, as I expected. I'm wondering if its possible to…
-
row total is not correct
I am working to create a Pivot table, where Year_Budget column is the average amt and Actual Amt is the the aggregrate. There are two questions, the subtotal of Year_Budget is not correct, it should be 6195907.00, however is it displayed as 476608.23. Also when I try to create a difference in value in BeastMode, I get a…
-
How to use a user selected date parameter in a calculated field?
Hi, I would like to include a dynamic user selected date parameter in a calculated field. Where the user selects a Start (selected_start_date) and End (selected_end_date) from a date filter then depending on what date ranges are chosen run the following sample calculation: IF user_sign_up_date <= selected_end_date THEN…
-
Is there a way to prevent a card in a story page from using the page filters?
I have a page that shows info about a customer, and I would like to show info about that customer in relation to another group of customers. For example: Filters: Customer = Bob and Industry = Retail With those filters both active I would only see data about Customer Bob. I would like to have 1 card that shows the average…
-
Change Legend Order
Hi, I have a multi line chart in which I have source as a line series. Currently in the legend the source name is sorted in alphabetical order. However I want it sorted by sum(metric) descending order. Is this currently possible in Domo? Thanks
-
Is this Chart Possible
Trying to re-create a graph that I have in excel. Is it even possible to get a chart to look like this in Domo?
-
Is it possible to abbreviate currency field values in a table?
I've been asked to adjust the formatting of two currency fields in a table card to show by thousands, for example $17.2M rather than $17,200,000. Is this possible?
-
Could we show the last run "date and time" of dataset on Dashboard?
I want to show to my team members and other users when the dashboard is refreshed last time. Please suggest how I can do it?
-
Is there a way to filter a card based on a sub-string in a text field?
I have a text field that is delimited by '|'. I would like a user to be able to use a quick filter that allows users to find a sub-string of the text field. Regions Covered Row1: North|South|East Row2: East|West Row3: West Row4: East|South I would like to be able to filter if a row contains 'East'. (Yes, I know I could do…
-
How to have a world map that enables selection (and drill-down) by continent?
Hi, I'm trying to build a card with values related to several locations across the globe. The drill-down path would consist of 3 levels: - Global level: a world map that would let me choose a continent. Displays data aggregated by continent. - Continent level: a map of the selected continent, which would let me choose a…
-
I'd like to graph the percent of whole using a beast mode
I am graphing Consultation data and one field I have access to is "excuse". I'd like to graph the percent of consultations where the excuse is "no show". I thought the following would work: count(`id`) / sum(case when excuse = "no show" then 1 else 0 end) But the results don't make sense. It's telling me that 35/443 =…
-
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?