-
How to see Average calls per Minute over the last 30 days?
I am importing data using a Federated Snowflake dataset. The dataset contains the following columns that I will use: Call ID - the calls unique identifier Date/Time - What time the call came in (dd/mm/yyyy - hh:mm:ss) Call type - a category that states what the call was about I am trying to see our average calls per minute…
-
Year-Over-Year comparison by month
I have a dataset where each row contains a single office's monthly revenue and I want a table where each column is a different month where I can compare the year-over-year values as well as office by office. Here's the data: And I'd like to create a DOMO table that looks like this: It seems like it shouldn't be that…
-
Layer multiple filter views on dashboard?
I have defined a set of filter views based on geographic location, and another set based on channel. Currently, it is only possible to filter on one dimension or the other. Is there a good way to build a dashboard such that I can simultaneously filter the data on the cards across multiple dimensions?
-
Top 10 by Sales
I would like to create a bar chart with the top 10 customers ranked by sales. This question has been answered elsewhere but i do not know if the interface has been changed because in my view, there is nowhere to limit the rows to top 10 in the Data Table page. I have included a screenshot.
-
Scheduled reports are aggregated even if the card shows data on a daily basis?
Good afternoon, Is there a way to have scheduled reports to display data on a daily level? Cards that show monthly data at a daily granularity level can be exported to a .csv/.xlsx at that same level of granularity; however, when distributed via Scheduled Reports, the data comes through at a monthly aggregate level. Can…
-
Number of dashboard visits
Hi! I am facing an issue, and I wondered if there is a way to solve it. I manage many dashboards, and the client wants to see how many users visit them. I know there are five datasets belonging to DomoMetrics, but none deal with the dashboard visits, so the DomoStats cannot help me either. I am saying this because I…
-
Can you change ownership of an alert?
Hello, We have created an alert on the admin side and want to transfer ownership over to a user. Is there a way to change ownership of an alert? Thanks!
-
Override axis date for chart with 2 different date fields
Hi, I am trying to make a chart that shows how many orders were opened and how many were closed per month on the same chart. Orders that have been opened and closed should show twice on the chart. Once in the month they opened & once in the month they closed. The dataset looks like this, where the open and closed dates…
-
Percentage shifts when chart is filtered
Hi, I am trying to make a card that shows the percentage of a client's total business is sent to us ("Company A"). I am using a beast mode and it works well until I try to apply a quick filter to look at clients that are over a certain percentage or filter by one Client. In one instance the percentage goes from 2%…
-
Links to Pages and Cards
Hi, I have a Table Card listing Cards and Pages from various datasets. I created this card using one the DOMO Governance datasets. Is there a way I can set those values to links so users can navigate directly to the relevant card or page? Thanks John
-
YOY Running Total Line card
I have a card with a running total comparing this year to last year. This year, April quantity was zero but the line is stopped on March and did not add the YTD March to 0 to get the YTD April. How do I correct this?
-
DOMO PP plugin
I cannot figure out why my PowerPoint is not updating when using the Refresh cards using the domo plug in. I seems to work then stop working. Any reason it would cause a powerpoint to not update from the updated cards? It seems like a simple process? Thank you, Jill Bowers
-
Is the Drop Down selector a new filter option?
I never noticed this until recently... is this drop down selector a new feature?
-
Issues with Text boxes
I've noticed some serious issues with updated text boxes. I will make a bunch of updates... click out of the text box, so it appears saved. And then when I refresh or return to the page later, it undone my edits. This SO UNBELIEVABLY FRUSTRATING!!!!!!!!!!! What is the issue here with this?? Is there somethign I need to do…
-
Multiple Date Columns
So I have a data set that looks basically like this: And I want to produce a card that counts the number of chats, emails, web, and text tickets by date, but also the number of calls by date. Then I need to sum up all interaction types by date. So for the above example, I would want this as the output: Can anyone provide…
-
Beastmodes capture sales for each of last several months
I'd like to create a table where I show the progression of sales ordered each month per product.... I thought if I could create a beastmode to sum up all the sales for the last month, or 2 months ago, or 3 months ago, etc. I could then just place these in a table. So I created the following beastmode to capture the last…
-
How do I force a Filter to have a value?
I have a dataset that looks something like this: I want to build a card that shows the Q over Q difference and allow the user to filter by Region. But I also need to either have the filter always have a value, i.e., not allow the user to unselect all values, or show the difference between the 'Global' values when none of…
-
How to add a Toggle button to switch between different currencies at Dashboard Level.
Hey there!!! I have data flowing from 2 different regions (USA & Canada), with their respective local currency. Is there a possibility to add a button or something similar, with which I can show the data in a single dashboard but in multiple currencies?
-
Beastmodes getting turned to Text
Hi, So I have been having this problem lately, all of the inputs of my beastmode formula are numbers, but it keeps classifying the beastmode output as Text. All of my columns are classified as floating decimals, there is no text in it, all the nulls are classified as zeros, yet it still keeps it as text even though the…
-
In the data science module of DOMO, is their a means by which to perform a cluster analysis?
I have been requested to do a cluster analyses for the marketing and pricing departments at my company. I am familiar with DOMO, but do not have access to all of DOMO's features. Is their a feature in DOMO that allows for performing a cluster analysis in their data science tool pack? If so, I should be able to convince the…
-
Windowed Function Beastmode Will Not Update Dynamically
Hi I need help using a windowed function in Domo. Here is my formula making up the "Fall Out Rate Average Line" column: sum(sum(case when `CanceledDate` is not null then `Units` when `DeclinedDate` is not null then `Units` else 0 end)) over() / sum(sum(case when `ApplicationDate` is not null then `Units` else 0 end)) over…
-
Can Links to the Parent Page be Disabled?
If a page has sub-pages, clicking/touching the name of the parent page in the navigation will take you to the parent page. Does anyone know how to disable this link? This is not very usable, especially on mobile, as people often accidentally touch the parent page name on the left-hand side rather than the icon for…
-
Maintaining header rows and columns when uploading dataset?
I have a table in excel which has both header columns and header rows. I want to build a dashboard so salespeople can pick which columns they want to display in the table to give to clients. When I upload the dataset to Domo, I select crosstab, but then all of my columns are lost and rows are duplicated for each column. Is…
-
Take large text input as field for filtering?
I have a slicer card to filter zip codes for a large data set. There is a search bar field for finding zip codes to filter by, but say I had a large list/string of zip codes and I wanted to select all of them for filtering. Is there a way to paste this list into a search field to filter them all, instead of selecting each…
-
Is there a way to fix sub-page order for everyone
Is there a way to set the order for sub-pages for others you share it with? Or at least set the default order when they first access it? So for example, I'd like to have the following order in the screenshot... but I notice others see it differently (because I had them in a different order originally).
-
Drill Path Filter to show Specific Apt's without a Specific Procedure
Hey guys, I'm worried that the answer to my question is that it has to be done in ETL, but I'm hoping it can be done as a beast mode. So the data in question looks similar to what I have below: Doctor | Procedure | Date | Apt # | Patient Dr. B | D0330 | 4/1/22 | 80136 | I. M. Madeup Dr. B | D0126 | 4/1/22 | 80136 | I. M.…
-
Complex count distinct
I have a dataset with session IDs and pages... I want to know how many distinct session IDs include a specific page ('ABC'). The trick is one session ID could have multiple rows with page ABC... Session ID -- Page 123 -- ABC 123 -- ABC 123 -- DEF 456 -- DEF 456 -- ABC 789 -- GHI Hypothetically, how do I create a beastmode…
-
STRING formatting with a decimal
Hello -- I've created a dataset with a column definition as: "type" : "STRING", "name" : "SKU" However when I load the data, the "11465730" as "11465730.0". I see that the column is a text field. Why is Domo formatting it with ".0"? Here's a link to the dataset:…
-
Beast mode formula: Case When with distribution points
Hi, I have a question about my beast mode formula concerning a distribution calculation. Currently, I am calculating the distribution points based on the volume. If one product of brand x has been sold in period y, then one customer gets 1 distribution point. It is max 1 distribution point per customer per brand. I have…
-
How to reorder variable categories in legend and how to remove the total section in a pie chart?
I feel like I've tried everything... could really use some advice! How to reorder variable categories in legend? The sorting function is not really working and I would want to avoid renaming the variable categories (this issue is also prevent in other cards). Also, does anyone know how to remove the total section in a pie…