-
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?
-
Is anyone else getting a bug where dates do not group on cards which they previously did?
The first pic is the normal card display. When I enter the analyser it changes to this. This has been happening across our instance today
-
DP22 - Using Beast Mode to Build Data Storytelling - Formatting Text
This post is part of a series of beast modes I presented on during my “Using Beast Mode to Build Data Storytelling” Domopalooza 2022 session. If you find this post helpful please make sure to give it a like or an awesome below. Use Case: We wanted a way to allow our users to quickly visualize good or bad data results. To…
-
Period over period gauge
Hi, I have crated a dashboard with a period over period gauge. When I set the date range to "This year" which then looks from Jan - Aug as those are the only months this year with data I have noticed the previous period say 1 year ago is looking at the whole year. This obviously gives a silly variance. Please tell me there…
-
Trying to figure out how to get this data set up in card
I have the following data below. I would like something like the grouped bar graph where the bottom would be my "y" column the values would be my "z" column BUT I only want to display the top 3 values of "x" column. So with the current data it should only display the values from where "x" is 4,5, and 6 ..... so when this…
-
Count and filter multiple row values in one column with same unique ID in another column
I am having some difficulty effectively reporting (counting, filtering, etc) on unique IDs that have data listed in multiple rows in another column within a dataset. Ex, my data is structured like this: ServiceName EntityID A 00001 B 00001 C 00001 A 00002 B 00002 C 00002 A 00003 B 00003 A 00004 C 00005 etc... I need to be…
-
Zip2Fips - map card issues
When I try using a United States map card or a State map card, I get the result in the screen shot I've attached. In this example, I've narrowed it down to 2 donors from Illinois (shown in the data table below the card). I am using the column "zip2fips.donor_state_tz" column for the "select county fips code" for US state…
-
How to create a card that includes top 3 rows (based on top 3 values)?
I an trying to create a card that shows the top 3 reasons for termination based on the number of responses for each reason; I would also need it to show all other reasons when you drill down. The dataset has 2 columns: Reason for termination (10+ reasons), number of responses. Thank you in advance!
-
Year = current year
If my booking year = system year then cy else py not sure what was the error in beast mode..pls suggest CASE WHEN YEAR(`Booking Year Nbr`)= YEAR(CURDATE(),"CY" ELSE "PY" END
-
Pivot Table showing correct grand totals but not all records
I am counting story points from a jira import, and while all the records are in the base data, when I create a pivot, it shows correct grand totals but skips some records, and fails to do row totals correctly. Even when I remove filters.
-
Fiscal week comparison
How to compare the data i have column like Fiscal Week so i wanted to compare each Qtr. trending by fiscal week comparison between Qtr with fiscal week trending pls suggest Column 1 column 2 FW 1 Q1 FW 2 Q1 FW 3 - 15 Q1 FW 16 Q2 FW 17 Q2 FW 18 Q2
-
Notecard Card changes won't save?
I'm in the process of creating a series of Notecards with hyperlinks and an image in a Design Dashboard. After adding the links and the image to a card, the updates disappear after navigating away from the page. This has happened several times in a row - am I missing something or is there a known Notecard bug?
-
formula to include values that don't contain string
Is there a way write a formula that includes a field that doesn't contain a certain string? So for example, I'd like to name a value in a column based on other columns where if the event_name contains "Add-To-Cart" and the page_location doesn't contain "shop", then it'll be "Add to Cart from XXX"... when `EVENT_NAME` like…