-
Test question?
Test question and can be used only for demo.
-
How to use a calculated field in a SUM function? (Statistics)
Hello! Please someone help me with this error! 😥 I am creating a table (card) with the mean, variance and standar error of a data column named "Score". The mean is calculated like this and the value is 6.67: If I calculate the variance using the value of the mean it works: That's not the idea cause the mean can change, but…
-
Is it possible to overlay a "milestone date" onto date-based cards?
When we show data to our customers like this... ...it would be helpful to overlay it with milestone dates or other significant dates, to put the changes in context. Something like this... It would be great to maintain lists of these milestones and overlay them onto the data where the dates overlap. Is this possible?
-
How to set a default date-filter for iFrame-embedded dashboard?
Folks, First, this dashboard will be viewed embedded in a webpage iFrame. These seem to behave differently in a lot of regards, to please keep this in mind. Okay...I have 18 months of data and growing. I want users to arrive on this dashboard page and see the previous TWELVE months by default. But I want them able to…
-
Filtering by latest date in table
I have a dataset which appends updated content data on a daily basis (with a 1 day reporting lag). I want to have the table show the latest data, however am struggling to do so. I tried filtering by last 2 days, which works most of the day until 7 PM CT, when everything is filtered out because I guess the filter is going…
-
How to convert a Beast Mode with a CASE function in it into an aggregation?
Hello everyone, Please, do you know how to convert a Beast Mode with a CASE function in it into an aggregation? I have tried adding a SUM() before the CASE function, I have tried converting the CASE into a number using CONVERT() or CAST(). Thanks in advance!
-
Running Total Year over Year
Hello, Is there a way to do a running total year over year inside analyzer or do I have to go into ETL and manipulate the data in order to have a year over year? When using the running total graph, I tried to change my X-Axis by month and Series by year but it made my current year the same value for future months but my…
-
Comparitve Gauge Last Week Vs This Week
I'm trying to create a card to show last week's sales Vs current week's sales, I'm but having issues with the values my beast modes are returning. The week should start on Monday and end on Sunday. I have our fiscal calendar enabled and checked so I'm not sure if that's causing the issue or not. Last Week: SUM((CASE WHEN…
-
Join in Domo
Hi everyone! I am looking to get the below outputs for the for the following columns in Domo: Distinguished Name Column: CN=Janet Jackson,OU=Users,OU=Technology,OU=TheArtFactory,DC=artfactory,DC=priv Output needed: Janet Jackson Manager Column: CN=Joe Jackson,OU=Users,OU=Information…
-
Orientation of Reports
Does anyone know how to change the orientation of reports/cards? When I go to the wrench and click SEND NOW the card is sent, but it is portrait, not landscape, and therefore not all of my rows display... so not really helpful
-
Repeating .gif in html table cards
Hello Domo Users! I have recently created a html table card that pulls in image / gif URLs. When the page the card lives on is first loaded, the gifs play once, and then do not repeat. Is there a way to get the gifs to repeat while the page is loaded? Not sure where to start on this one, and I don't see anything like it in…
-
Custom Month Filter for building cards
Hello! I am currently building simple gauge cards that show sales for today, week, and month vs our goal for each of those. (see screenshot) Is there a way for the 'This Month' card to have a custom date range each month and have that automated so I don't have to change all the cards each month to a new date range? I work…
-
I am trying to calculate the difference between values in the same column on 2 different dates
I only have 3 dimensions and one measure. Dimensions: Date Category Company Measure: Category Rank I am trying to create a calculated field based on Rank, that tells me the difference month over month. I thought I'd be able to find a calculation in beast mode for different, but am not. If anyone can help me with a…
-
Dynamic Percentages of Total
Hello! I am trying to get a percentage total column to work within a beast mode calculation in a pivot table card. I'm using the OVER () function, but because I have dynamic date ranges in the table (ex: we're looking at last 30 days only) it seems to aggregate by the grand total instead, not considering date ranges. Is…
-
Can you freeze a column(s) in a table?
I have a mega table I'm building, which would require scrolling over (which is fine...), but I want the first couple columns frozen. Is there a way to do this?
-
Removing sort symbol from graph
Is there any way to remove the sort symbol from view? It can be obstructive when looking at the axis numbers. I can't find anything in 'Chart Properties' to disable it.
-
I am trying to build a beast mode that compares Quarter over Quarter.
This is the formula I am using but it keeps telling me Invalid Formula : This calculation contained a syntax error. These are my headers: The first part is how I got QTR Lbs. I would like to compare the differences Quarter over Quarter and then format it in percentage. I am not sure what the error is. (SUM((CASE WHEN…
-
Imitating Bar Chart Calculated Lines (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 create date dimension table
@GrantSmith Hi Grant, you provided a very intriguing solution for identifying time periods here: https://dojo.domo.com/discussion/comment/50540#Comment_50540 You mention, "What you can do is create a date dimension table which calculates the dates for this year, last year, last quarter etc. I utilized a MySQL dataflow to…
-
How to make card of Monthly Total Sales & Price Per Unit and Summary Table With Corrected Color
Hi There, I'm a beginner user in DOMO, therefore there is a lot of DOMO functionality I'm not familiar with. Currently, I need to make 2 DOMO card one is Bar with Line chart and one is table card. 1.1st photo attachment is to make Monthly Total Sales & Price Per Unit (Bar with Line card) Green Bar: Total amount of Product…
-
Summary % Changes in Cards
Hi there, I'm looking to incorporate the colour-coded summary % changes number in a graph in my instance, like the first few cards in the Awareness or Consideration section of this dashboard [https://www.domo.com/dashboard/marketing]. I can't find a clear option in Analyser so was wondering I could please get some guidance…
-
How to build card for DOMO?
Please help me to build new card for DOMO
-
Can we create a beast mode calculation with case statement for a value field?
I wanted to set the range of a value field like, case when 'value' <=1 then '0-1 end from this range, I wanted to see the count('dimensions'). I have tried this in beast mode, but not getting the correct count for each range. Any help is appreciated Thanks in advance Salma
-
Weird/Random Question about the date filter.
I have a card that is a POP trendline and is comparing current year to the previous 2 years aggregating by month You can see that in the current month (September) there is a drop off from August because it is an incomplete month. Is there a way to show the card in this same view but just not display an incomplete current…
-
Can we do unpivot functionality in ETL, in the beast mode?
Hey, I wanted to unpivot two value column, let's say, A & B, in which the first column gives A,B (row wise) and the second column gives its corresponding value. Thus, I can use the first column as filter and value column in the card. When we select either A or B, then the values in the card will change according to that.…
-
How to calculate Percentage in each Series - Bar graph
I have created a card that displays total population of universities with respect to its ACT value. I want to create a card like below, I have created a beast mode calculation to determine the percentage in each of its series. My beast mode calculation, Case when `Public/Private`='Public' then sum(`Undergraduate…
-
How to aggregate CASE Statement values?
In my dataset, I have three different tests that aggregate the field Forecast differently. Here's a beast mode I made that works pretty well, except when I'm trying to add them all together: CASE WHEN Test = 1 THEN SUM (Forecast) WHEN Test = 2 THEN SUM (DISTINCT Forecast) WHEN Test = 3 THEN SUM (DISTINCT Forecast) END when…
-
Formatting Numeric Values within CONCAT functions to Currency
Hi there! In one of my graphs, I have created a few beast modes involving nested CONCAT functions so I can capture many fields in a hover text. Some of the fields in the CONCAT are numeric but I would like them displayed as currency. After running the beast modes, the numbers are displayed as a long integer with no…
-
% of total in dynamic Textbox
Trying to get a dynamic textbox to display the following: "Sale Type 1:" %_LAST_VALUE %_OF_TOTAL "Sale Type 2:" %_OF_LAST_VALUE %_OF_TOTAL Looking at a few other questions asked on this forum, % of Total does not seem possible for dynamic textboxes. I have tried using Flex tables with the horizontal bar chart, but % of…
-
How to add multiple Name Columns to a custom chart
Hello! I have uploaded an svg with a custom data diagram. Within the diagram and within my data there are 2 columns (component and connection) that I would like the names to be displayed and the colors to be highlighted. However, it is only allowing for 1 name column. Is there any way to add another? Thank you!