-
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…
-
Including multiple values on on card
I'm interested in creating a card that will show values from two different columns... For example, I have a table that includes two columns: -Sends -Delivered I'd like a card that has the sum of the Deliver column and also what percentage of the sends were delivered also in that card. i.e. 500 delivers and 75% delivery…
-
understanding null vs blank or empty string values
I've always struggled with figuring out how to filter by fields with nulls vs blanks... for example, if I have a formula to identify if a field is null (this will not work with fields that contain empty strings or blank values, correct...?). I've tried using charlength functions to say (when charlength' is greater than 0…
-
How do I calculate the average of the past 3 sales of an item?
I have a database of millions of sales over time for a thousands of specific assets. I'd like to have a calculated field that determines the last 3 sales of an item. For some, they may have sold 3 times last month for others 3 times in the past 24 months. Thanks!!!!!
-
Dynamic Segments
Looking to create a segment calculation that essentially becomes the leftover rows of what is filtered. So lets say you have 5 zones and someone filters the page on Zone 1. I want the other zones to show up for comparison. The filtered zone will be highlighted. This is a workaround attempt at highlighting page filtered…
-
Arbitrary Periods as Pivot Table Columns
I'm trying to build out a pivot table card and I'd like to use some arbitrary time periods for the columns. This Week, Last Week, Month to Date, Year to Date. I'm not sure how/where to define these periods so I can use them in the pivot table to both use them as labels for the columns but also to then use them to do the…