-
Can we add notes in Domo Chart?
I want to add notes in chart . Can we do that?
-
General question on data from different datasets on the same card.
I have a card that is on a finished page. There is another metric that I want to add to a specific card that already has data displayed from a single dataset. This new metric is in a completely different different dataset that isn't attached to this page at all. Is there a way to pull in this metric to this card without…
-
Extra Spacing from Exporting to Excel
Hello, I have this issue where when I export to Excel, there is about 6 extra spaces at the end of each result.. When I export a card into Excel and click on a cell in the FirstName column, it'll show for example, "Max__", where _ = spaces. Is there any way to get rid of this?
-
Beast mode to count a variable with an if that reference other variable
Hi all, I am trying to create a trend line of the total number of customers we have that have reached an X revenue threshold by month. I wonder how to best do that whether from a beastmode or something else. The tricky part is that the data we have in domo is all written by revenue center in that one customer can have…
-
DOMO CLI Interface Search/Filter
I'm trying to better understand how to use the Domo CLI, and have a few questions. -Is there a way to search for all datasets/flow/cards whose name does not follow a defined convention? Ideally, I'd like to be able to utilize regex to search for patterns. Something like "list-dataset -n TEST%" -When executing a search, is…
-
Tableau-like Parameter actions
I am trying to allow a user to filter a chart that uses an aggregation. My data looks like this: I want a user to be able to choose 'Apple' and then the ensuing line chart would show percentage of items each day that were apple (40% over 1/1, 30% over 1/2, and 60% over 1/3). In tableau, I would set up a parameter (p_fruit)…
-
Filled Gauge Chart
I have a gauge filled chart built that has been working each month and is now showing an error. The field I am using for the time period is Date Closed and now it makes me pick a Max Or Min. That was never showing before. Is this a change? I am trying to show the Ave Days to Close incidents base on Previous Month compared…
-
Use card with drilldown as filter on a page
Hi! I have created a dashboard where I have a map that is drillable (it's a map that goes from a state view to a zip view) but since I have changed the interaction option the card is no longer interacting with the rest of the cards on the page. Would it be possible to keep both functionalities ( when a user clicks on a…
-
Lag Window Functions gave me split rows
I am trying to use window functions for lag/lead. However no matter how I try, the table still show splits. lag(sum(case when `control or target` = 'target' then `vol_usd` else 0 end)) over (partition by year(`trade_date`)*100 + month(`trade_date`)) Is there anything wrong here?
-
Imitating Calculated Line Value (Avg)
Domo allows automatic calculation of some values on bar charts (Min, Max, and Avg). These values can be shown as "Calculated Lines" on a chart for comparison purposes. The great thing about these values are that they adjust based on chart filters. I would like imitate the Avg value and display it in a Single Value chart.…
-
How to add a Jitter to a chart (a Scatter plot in my example)
Hi, I have a number of risks which are each ranked on a scale of 1 to 4 on 'Likelihood of occurring' and 'Impact of Occurrence'. When plotting the individual risks on a scatter plot, because of the relatively few scoring options, I have many points sitting on top of each other. I'm relatively new to Domo and wondering if…
-
Bar Chart - side-by-side comparison of category average and individual item?
Hello All, I'm interested in building the following type of graphic. Let's say I have a category such as 'Truck' and want to calculate the average cost for all categories 'Truck'. And let's say I would like to have a side-by-side comparison of that average compared to a particular 'Truck'. I'm having a tough time achieving…
-
Case When statement
Is it possible to use contains instead of = in the Case When statement CASE when 'Amount'=1 then 10 else 0 End For example: Case when 'Reason' contains 'Retal' then 'Retaliation' Else 'Other' End we have many different variations of Retaliation statements and don't want to spell each one out in a case when statement Fear…
-
How to create a graphic link
Hello, I am trying to create a graphic link that will direct a user in Domo to a specific card in Domo by clicking on the graphic. I was wondering how to create this Thanks
-
Calculating NPS total score based on a survey
Hello, I need to create an NPS score calculation. I know the formula ( [ (No. of promoters - No. of detractors) / Total responses ] * 100), but whenever I enter into a beast mode calculation, it does not work. How do I need to format my survey information data, or write my formual to get the card to aggregate correctly and…
-
Alert History as Dataset
In each of the individual alert, we can view its Alert History as a line graph or as a chronological list of trigger event. (ref https://knowledge.domo.com/Optimize/Notifications_and_Alerts/04Managing_Your_Alerts) We create alerts to monitor our system health and want to build our KPI around how often a given alert is…
-
Weighted Average formula - beast mode
Hi all- I am using a beast mode to calculate the weighted average of days between two dates (payment due date and invoice date). Formula here: SUM((`PAYMNT_DUE_DT`-`INVOICE_DT`)*`RECPT_AMT_USD`)/ SUM(`RECPT_AMT_USD`) However, I realized there may be some zeros in the output that are possibly causing the weighted average to…
-
Adjustable % column
I'm working on an ask that I'm not sure is possible to meet. I have delivery data that I need to calculate the on time percentage over an adjustable timeframe. My key columns are supplier name (column1), PO lines delivered (column2), and PO lines delivered on-time (column3). I also need to display a column that show the…
-
Combining Different Rows into a Single Row
Hello! Was wondering if there is any Domo function/beast mode that can be utilized to combine results of a column across multiple rows to display in a single row. For example, if I had company name and office locations: Row 1: XYZ | Pittsburgh Row 2: XYZ | Fresno Row 3: XYZ | Dallas Could I have it so Domo shows 1 record…
-
How can I set default page filters for each of my dashboards?
Hello, I am trying to set default filters for each of my executive dashboards. The problem is that each dashboard has exclusive data that should not be visible to others. For this reason I wanted to set page level filters to make updating each dashboard easier. Is there a way of doing this so that the data will always be…
-
How to Make a Card of Total Ratio and Recent 1 Year Ratio
Hi There, I need DOMO Dojo expertise to help me on create 2 card using Beastmode calculation. I have a basic data to create this 2 card: Month date (201706, 201707, 20178 etc) Product name, 2 Type: Panel & MB Monthly defect qty Cumulative sales Idea: The Beastmode I should create is: Cumulative Monthly Defect Qty Total…
-
How to make a Monthly Total Sales & Price Per Unit and Summary Table With Corrected Color
Hi there, Since I'm a beginner user in DOMO, therefore I need helps to create 2 cards as below: 1st Card: Monthly Total Sales & Price Per Unit (Bar and Line Chart) Green Bar: Monthly Total Sales in Product Grape Line Chart: Unit Price of Product Grape 2nd Card Table card with exactly background and words color. Header of…
-
how to visualize
Hello I have time and date of equipement use and I want to visualize when they are running. For example something like a calendar; weekly based or graph bar with hours on Y value from 7 am to 7 pm and a bar showing if the equipment was used or not. Data are date/time of start and date/time of end usage for each equipment.…
-
gauge with custom tick marks with values showing
Its possible I am missing it, but I went through all the gauges and settings and did not see how to do this: 1) a gauge with visible numbers for the tick marks 2) Tick marks that are custom values (ideally supplied in the data set, but even manually entered in the settings would be fine) The idea would be to see the tick…
-
Can we set Dynamic color rules for Different inputs/conditions provided by user filter?
lets say, for year 2019 different threshold color rule can be set and for year 2020 different threshold color rule can be set ?
-
Can I arrange these quarters like Q1,Q2,Q3 and Q4?
I have created calculated field Qno and assigned values Q1, Q2,Q3 and Q4 accordingly but it is showing like this in card ? How can i arrange these ?
-
Swapping field names that is used in multiple columns.
Hello, I want to swap a field name that is in use in multiple cards and would like to change this field with a different one. our dataset isn't powered by magic ETL. Any other way to do this?
-
Multiple Countries Map
Hi, In using the Domo country map, I'm wondering if it's possible to assign the same value to a group of countries without repeating the row. For example: Country - Value Kenya, Uganda, Tanzania - 10 Italy - 18 India - 55 Thanks
-
Regards to transforming data prior to joining with another data set.
Attached are 2 different samples of data. Both are in similar format, and have plenty of same columns. The price list is where the bulk of what I am going to use will come from. It is the full inventory for a site. the total number of units, number of occupied, number of vacant etc... It is rolled up in to a single row for…
-
Show x-series minutes with no data.
Hi, I'd like to have a graph by minute and a heatmap for the last 60 minutes of a live data feed, at the moment because the X-series is data driven if data stops coming in the x series stops at the latest minute available in the data. I'd like the graph to always show the past 60 minutes even if data hasn't arrived, and…