-
Default Date Filter on an Embedded Dashboard
(NOT USING DATA RANGE) I am wanting to filter data by Week ( 1, 2, 3, 4, 5, 6, etc..), but I am having trouble finding a solution that will allow me to 1. have a default filter that will open up the dashboard to the current week and then 2. being able to filter by other weeks. Here's what I have tried: Using the Beast mode…
-
How to see which account has the greatest increase in activity
I have a card that looks at how many hours our operators spends on each customers account. The X axis has the account name/number and the y axis shows how many total hours we have spent over the time period (which for the card is year to date). The columns that we are using from the data set include: account name/number,…
-
OR statements in card filtering
Hi folks - We have a dataset where users can have datapointA and datapointB. We want to build a card where an end user can have a filter that asks for any user has datapointA = 'green' OR 'databpointB = 'circle'. When we put those two datasets in a dataflow/card and add the datapoints as Quick Filters, it automatically…
-
Help with dynamic text for information block instead of KPIs
Can anyone help explain how to set up dynamic copy? Objective : I want to create copy that looks like the example (or some variation) where copy in the parenthesis [] is dynamically pulled values from the record selected in the filter) Example: [Campaign name] is [description] and start date is on [start date] and has a…
-
Dynamic date range (last two quarters data)
HI All, I am looking to create a dynamic date filter on my card. The objective is to get last two financial year quarters data. I am aware that there is an option in DOMO to get last two quarters data but this gives me incorrect results i.e if we are in May then this gives me nov - april data but what I need is oct 1st -…
-
How to hide gridlines on table card
I have a Mega table card with 10 columns. Is there a way in Domo to hide both horizontal and vertical gridlines from the table and just keep it on header ?
-
Can anyone help me understand how to create dynamic text?
Sorry I am newer to domo and can't figure this out. Objective: I want an informational block that pulls specific values from a record based on the chosen filter. So a campaign ID or name is chosen and based on that the values in specific columns are shown (status, date, etc) For example (and the text in [parenthesis] are…
-
Waterfall Chart
does waterfall chart have the ability to use as filter interaction on a dashboard? I looked at Edit Dashboard/Edit Content/Change Interaction, Standard Interaction type was chosen, and filter interaction on all cards was unable. But when I clicked on certain part of the waterfall chart, other cards are not filtered. is…
-
No Code JSON Connector - help
Hi DOMO Gods, I've recently set up a NO code JSON connector to pull an endpoint from a CRM that we use. I worked with a DOMO consult to configure the pagination and parsing, so that we were able to get the data we wanted and it worked well for a few days, however I'm getting the following error message now for the last few…
-
Filter data on a dashboard using two separate date filters (from and to)
Hi There, I have a single date column and multiple cards on a dashboard that I have built. Can I create two separate filters on the dashboard to select the from date and the to date within the dashboard that I have. For example. Select Feb 2022 and it will show all data greater than Feb 2022. The select May 2022 and it…
-
Interactive table function
Is there a function/card that would allow you to add in columns that can contain text and be updated and saved? For example, we have a Sales Funnel and this shows all prospects across the globe, with start dates, values etc (this information is taken from a CRM platform to DOMO), we would like to review these prospects on…
-
Tornado chart
Has anyone figured out how to present a tornado chart in Domo? There isn't a specific card for this but was trying to figure out if I could trick another chart type into doing what I needed. It requires a horizontal bar but with the ability for the bar to reflect a range which does not start at zero, and the ability to…
-
I am replacing power BI DAX formula into Beast Mode
CALCULATE(DIVIDE([SumOfTimeToClosed],[ResolvedCountForMeter]), FILTER(JiraBugsTable, YEAR(JiraBugsTable[ResolvedDate]) = [CurrentYear])) Sumoftimetoclosed and ResolvedcountforMeter details below SumOfTimeToClosed = CALCULATE(SUM(JiraBugsTable[DaysToResolution]),FILTER(JiraBugsTable, YEAR(JiraBugsTable[ResolvedDate]) =…
-
Dynamic series line bar
It's a regular frustration for me that I can't create a line bar graph which stacks dynamically based on a dimension without using multiple beastmodes. For example I want to include a target value as a line, and then actuals stacked by type over time. This has been raised before here:…
-
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…