-
Tracking Google Analytics for Coursebuilder
Hi all, I have followed the instructions in the knowledgebase on how to set up tracking for Coursebuilder using Google Analytics and I am seeing some data coming through - the problem I face is that I don't know what fields to bring back in order to understand Which course they have accessed What pages they have viewed…
-
Generate an Average ignoring duplicate rows
I am trying to generate an average value for a single value card, The data has duplicates of this value due to other data within the set. In the example below, I am looking for the average number of seconds per customer. I need to be able to dedupe Customer 1, then average the remaining rows. Can this be done with a Beast…
-
beastmode help. Nuanced conversion rate.
I have a conversion metric that I use a beastmode to calculate it it's pretty straight forward. Rentals/Inquiries as can be seen below in the calc. sum(case when `unit_rented_c` = 'true' then 1 end)/count(`id`) Now what I am trying to do is take these inquiries that haven't yet converted to a 'unit rented', but are in a…
-
Table Card - Total to be % calculation rather than SUM, rows by week
Hello, I've attached an excel workbook showing a sample bit in its raw form, what I want to get out of that, and what I am getting. I'm primarily having two issues: Getting everything on 1 row by fiscal week. I can accomplish this until I add a percentage beastmode, then the rows will no longer be condensed to 1 row per…
-
Count (Distinct) With Condition
Hello Domo Experts, I am having a hard time navigating around this one. My goal is to get a unique count of 'evaluation_id' where an error has occurred. I have created a column for when error occurred using beast mode, but when I try to count Distinct Eval Ids does not seem to give me what I want. Any help appreciated.…
-
Change line type to dashed in line graph
Can the line type be changed from a solid line to a dashed / dotted line in a line graph? There are old posts where it was determined this is not possible but I would hope this has become available now.
-
Combining outputs from 4 different cards and 4 datasets I don't want to join together
Hello, Hoping there's an easy answer to this. I have 4 different cards coming from 4 different datasets with no common fields. So I don't want to join them together. The 4 cards created are 1 number cards showing a dollar calculation (let's call it "profit"). Card #1: Profit from Sales ($100) Card #2: Profit from…
-
Moving Jupyter Notebook Graphs to Domo
Hello all, I was wanting to do some analysis on a data science model that I made where I was trying to gather inference or find out which variables in my model had the most influence in creating its predictions. In doing so, I used the SHAP package and created a visualization that I would like to transfer into a card. Is…
-
Creating a static column that doesn't interact with the date filter.
I am working with Google Ads Campaign data. I want my 'Campaign' column to display all the campaign names and not remove any names when the filter is adjusted. other metrics such as 'click through rate' I do want to be able to interact with the date filter. How can I take my 'Campaign' column and make it static, so it will…
-
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…