-
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…
-
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…
-
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…
-
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…
-
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…
-
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:…
-
104 Weeks as option in Multi-Value card
With so many industries moving to a 2-year CAGR in addition to their regular YoY comparison numbers, it would be great if the Multi-Value card allowed for a 104-week option as a quick way to build the change value.
-
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…
-
SUM with multiple conditions
Hello everyone, I am having trouble with a DOMO Beast mode sum Calculation. Below you will find my existing calculation. I am looking to add the value of all records that have a date to Customer in column A and exclude those records in column B that have a payment date. Essentially I am looking to calculate the value of…
-
Exporting live cards to ppt.
I want to export a live card/ card table that is long and keeps updating as the dataset updates. The problem I am facing is whenever I am trying to export this card it only exports the snapshot of the card and not the whole card also since it is only the snapshot, it does not updates as the card in my domo instance…
-
How do I build a card?
Hello, I'm new to Domo. Wondering what best practices are for building cards?
-
How to add a Target line
Hi, I am looking at how much time consultants spent on the phone and the traget is about 20%. How can I manually add a horizontal line that shows 20%?
-
Beast mode to calculate month over month user count changes
One of the metrics we calculate as a business is our user change month over month. Our main data set we work off of is an activity log dataset which contains the date of the activity, the user id, and details about the activity. For active users we calculate the distinct number of users for that time period such as the…
-
Table Card not showing all columns
Hello everyone, I am building a simple (at least I thought) table card for my dashboard. The table only contains four columns, but when I save it, the card on the dashboard only shows three of them. I have played with editing the column width and the font size, but nothing helps. The card keeps showing only three columns.…
-
View last 2 weeks of data
Hello. I know there is an option to view Previous Week data. But how can I manage to display a week before the Previous, JUST AND ONLY the week prior. Example This week is 16 of the year Previous week was 15 Pior to that, it was 14 I want a chart to display only data for week 14, and ANOTHER chart to display only Previous…
-
Card showing selected and not selected
Our marketing department is wanting to create a card that shows which coverages we offer and have it be one color if the customer selected is purchasing that coverage from us and another color if they don't purchase it from us. They currently have a manual process that results in something like this. They like the look,…
-
Filter card with 'search' bar
It would be great if there was a filter card with a search bar available. For example, when you use a card which shows the overal sales for a company with a link to the sales per customer. With a search function, users could easily find the customer they want to analyze without having to open the card in a new page to find…
-
Quick Filter in Dashboard
Hello, I am working on a dashboard which requires a minimum number of actions to use. One card contains total sales with a link to sales per customer, I have added a quick filter to look for specific customers easily. But to see the filter, you first have to click on the card. It is possible to add the filter on the…
-
Week over Week Metrics - Multiple Stores to Show
Hello, Experts, I have a use case where I am looking to build a card for week over week showing in table format a list of stores in one column and total sales in another column for the given X # of weeks. Based on my reading, it looks like I will have to build a new transform to be able to accomplish this. Can you confirm…
-
Grouped and Stacked Card with 4 Data Fields
Hi all, I'm trying to build a group and stacked graph with 4 different data fields and was hoping someone could help me figure out if it's possible. I have a dataset that looks like the following: I want to show, by date, the Survey Count by Name in one column next to the Tour Count by name in another column. Below, I drew…
-
Cannot Change "Hint" Values on Cards
I am trying to edit the value that shows up when I hover over an item in the legend of a card (first screenshot below). The value that shows when I hover over the Series Name in the Legend is defaulted to "[X-Axis Value] : [Y-Axis Value]". It appears that this is being driven by the "Hints" option under Chart…
-
Can you create a Youtube video card?
Is there any way to create a card that only displays a Youtube video in a dashboard? If not, then how would I show a card that simply contains the link to the video?
-
Altering how a card/chart is displayed in a Group/Collection
Hi. I'm new to Domo and I was wondering, is any way to alter the graph that is displayed on the card when I view the group/collection? For instance, the attached graph is so scrunched and tiny that you can't get any value at a glance for a dashboard type of experience. So I was hoping that I could alter the "thumbnail" in…
-
How can I re-order my X axis so that the numbers are in order (1-12)?
I'm wanting the numbers on the X axis to be in order from 1-12. I can't figure out where to do this in the Chart Properties.