-
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…
-
dynamic rank/ordering for Beastmode
Is there a way to create a dynamic column via Beastmode that will rank the rows (1, 2, 3, etc...) based on the filtering and sorting for a table card? So however you filter and sort your table, there will be a rank column that adjusts so you can see the ranked order?
-
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
-
Struggling with Beastmode formula
For some reason, the following BM formula is not working. I get a Calculation Error: This calculation contained a syntax error. Can anyone advise on what I'm doing wrong here? sum(case when `EVENT_NAME` like 'user_engagement' then `EVENT_PARAMS_ENGAGEMENT_TIME_SEC` end) / COUNT(DISTINCT case when `EVENT_NAME` like…
-
Mod please remove
-
Segments
Hi, I have sales data by month, by country. I would like a segment for sales data in Canada so I created a segment named Canada and added the filter for the Country Canada. Am I right in thinking this should then be removed from the rest of the data and the country filter within the analyser? At the moment Canada appears…
-
Show the latest data without affecting date card filter
So I have this dataset and it has a column for 'Date'. I need to be able to show the latest data for each member without affecting the date card filter. Is there a way to do that in domo?