-
Ignore Row Context / Power BI 'ALL()' Equivalent?
I mocked up a simple example to illustrate what I'm trying to accomplish. The question is: how to create a beast mode which will ignore any filters and/or table row context applied to a column, in this case `Store`. The goal is: calculate Average Order Value for the entire dataset (Total Company), so individual Stores can…
-
Single Value Card - Footer use Todays Date mysql like a summary number?
I'm creating a card. In the footer can I put something that will reflect today's date?
-
Date Filter Card Will Not Toggle
Hello! This is my first time posting on the Dojo. I am trying to set up a 14-day and 30-day card filter for my org. The one used at the moment does not toggle. So if I select the 30-day card filter, it will stay at the 30-day filter if I deselect the check box or slide the slicer. It will only go back to default if I clear…
-
What type of chart is this below?
I've seen the chart on the right hand side on a domo video. It looks like a multi value widget but has a graph on it as well. Any idea what it is? Thanks
-
Status tracking for hot board
I am wanting to track a hot board status for part numbers and want to use the status to track through the process. Is there a formula or beastmode that can remove the in process data once the ticket has been fulfilled and reads 'completed'. For example… Once the part number 3333-000 by Robert Storey was completed can the…
-
Fiscal periods in one report
Hi, I am looking to produce a simple report with the following headers Date | YTD Value | Last Week Value I have a dataset linked to my own fiscal dataset that has information for week start, year start, week number, period etc. I am slightly confused on how to write a beast mode for the above as using the built in…
-
Where do Cloned Beast Modes Come From?
Good Afternoon All, I'm working through managing beast modes for my company and noticed that we have a "cloned" beast mode. Our company uses mutliple datasets, and within the datasets I have noticed that while we can have the same beast mode listed in the dataset twice with diffeent names, however the wording cloned beast…
-
Google Ads Data
I am trying to bring in my CPC, Cost per conversion, Total Spend data etc. for my Google Ads. The columns coming in are way off what they are supposed to be. How do I go about getting the correct data in and then converting those amounts into $ amounts?
-
Multiple categories on X-axis - really not possible?
Hi, something that I can easily do in Excel gives me headaches in Domo. I simply want to use two columns at the x-axis, but cannot find a way how to do this in a card. Like this below, 1 Region of Account plus Region of Team. Count cases and split into more/less 24 hrs: Attaching also the spread sheet with some example…
-
Is there a short cut for creating a normal distribution (bell) curve in Domo? Thx
-
Contextual tooltips in hover text
Anyone know if there's a way to show different tooltips in hover text depending on what series you're hovering over? For example, I have a chart that shows the percent change in value from last month as a bar and percent change in value from the same month last year. When I hover over the percent change from last month,…
-
Box plot - different series
I would like to see in a boxplot different series to compare. Is that possible? Thanks in advance!
-
Variable limits in SPC chart
Is it possible to, instead of fixed values, based on the filter selection, modify the limit values for an SPC chart? Thanks in advance Kind regards
-
link to new domo dashboard using applied filter
I think this is similar to pFilter with embedded dashboard but not sure. I want to create a link to a sub page dashboard. When the link is clicked it will keep the filtered value and apply it on the new page. So in "Page 1" I filter card "Campaign Name" to value "xx-on24-L1", In the dashboard there is a link to open "page…
-
Header Labels on Pivot Chart
Hi All, Is there a way to remove the 'value' input label from the headers row of a pivot table? Thanks in advance
-
How to update node.js and Python version?
We have Created cards using custom react app in domo. Now, we need to upgrade to latest version due to end of support for these versions and vulnerabilities. Right now we are using below version in react app: Node.js : 12.10.0 Python : 2.7.13 We use this for Custom app development on Domo. We need to know : Which would be…
-
Multiple instances of same week numbers
My dataset has a date field that has 2022 running data on it. When I'm trying to create a line chart using that date range, it is repeating those weeks. I want to have only one instance of that week. How to resolve this? In the attached ss, you can see Week-6 getting repeated 3 times. I only want to see that week or any…
-
Date filter greyed out - multiple date columns in a table visual
Hi there, When I drag a second date column into a table visual, the date filter auto changes to match the new date column and greys out. It doesn't happen every time though so if someone can send the documentation or explain that would be appreciated. In this scenario, I am trying to bring a create date into the table…
-
Choosing first and last month in BM
Is there a way to use fixed functions or something else to grab the first date that appears and the last date that appears? I am trying to calculate yearly attrition. I have it by month but adding up or avg the monthly % is not mathematically correct. I need to get the first month and last month's values within a certain…
-
Is it possible to add context to legend entries
Is it possible to add context to legend entries? For example if my legend breaks things down as: pending, in-transit, out for delivery I want to be able to add hover text that says something like: pending: at the warehouse, pending shipping label creation in-transit: with delivery partner, moving between shipping…
-
Sending Card Data via SFTP
Is there any way to send the output of a card (XLSX or CSV format) to an SFTP server? We are looking for a way to schedule weekly updates of a report and have it automatically sent to an SFTP directory. I saw that there is an SFTP writeback connector available as part of the Domo Integration Studio, but that appears to be…
-
Aggregate measures not grouping by Date Field
Hi Everyone, I have data at a daily level for every month. I am trying to plot averages (monthly) over time. So for example, if I have 30 rows for June 31 rows for July, I would like to see 2 bar graphs with average metric plotted. Instead, I am getting 30 bars for June with the same average value/bar length and 31 bars…
-
Any chance I can add in a percent change over various fields in a pivot table via window funciton?
I am doubtful that it is possible, but I'm holding out hope that somebody might have some insight. In excel I can take the values of two different cells per row to calculate a percent change, but in SQL I only know how to do this when it's isolated across a single dimension. Below is a screenshot of two pivot tables with…
-
YTD Previus Year
Hello, I want to make a dashboard where i will have 2 single value type cards, one with the YTD for the current year and the other with YTD for the previus year. I've computed both values trough ETL with the rank/window tile. The column has both the values for the previous and current YTD (see image below). However, this…
-
Is it possible to add hyperlinks into a Gantt Chart Y value?
Hi, As the title suggests, I have a Gantt chart of project timelines, and I want to be able to add a hyperlink to the Y value so that when clicked on, it takes you to the relevant project link. I have produced a beast mode that generates the URL format, but I'm unsure how to proceed and if it's possible. Best, Stuck
-
Difference between dates
I'm looking to work out the average time in days from 'Instructed' to 'Completed' (both dates), I'm using DateDiff but the returned value is -151 for some reason. Is there something I am doing wrong with this formula?
-
Page Level Date Filter nulling when not available in every dataset
I have a dashboard with cards running on multiple datasets (5+). To make date selection easier for users I've created a beastmode titled exactly the same across all datasets to show Q#-YYYY. There are instances where a there will be records of that date in some datasets and not others, the issue here is that I assumed as…
-
Trying to hide past months for one value in a beastmode
I am trying to use our actuals to track past month/current value and our forecast to use future month value and I am having trouble writing the beat mode to do this. CASE WHEN YEAR(`Period Date`) <= YEAR(CURDATE()) AND MONTH(`Period Date`) <= MONTH(CURDATE()) THEN 'Hide Future Months' ELSE 'Show Future Months' END Here is…
-
How do I get my bar chart to plot along a minute-by-minute x axis
Test Question
-
Data Cleaning
Hi guys! I am trying to clean bunch of time codes and I have a first line code that's valid, but I am having trouble cleaning other codes such as 'hourly' and 'salary' lines of code without error. case when Right(`Entry Store`,5) = 'PTO"}' then 'PTO' end