-
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!
-
Ignore filters + include ALL entires of a specific measure in a formula, but filter other measures
I am tracking performance of a manufacturing process, and the various reasons parts get rejected. I can easily chart (Parts Rejected)/(Parts Run) aggregated by day for a reject rate, but I would also like to be able to separate the reasons out as a series. The formula I am after is then: (Parts Rejected by Filtered…
-
Comparing beast mode calculations and resulting in a string
Due to confidentiality reasons, I'm trying to create a card where it shows if a student has Completed or Not completed a series of tests (we don't want to reveal their actual scores). The Complete/Incomplete column keeps showing as Incomplete no matter what I try to do. I tried switching it to Integers (Complete = 1,…
-
Creating a Card Deep Link Beast Mode - Multiple Filters
Have been searching the Dojo and KB this morning for info on this and I'm not finding the solution. Also, not seeing documentation on Card Deep Links (do see for pages) - is this still supported? I have a card that shows inventory information and users are asking for a way to "see" who is buying the inventory most often. I…
-
Shape card image size reduction on selecting background color
Hi there I see that in the shape card, the size of the image changes if I select a background color. I would want to select different backgrounds to separate out KPIs, but apparently it is not possible. Am I doing something wrong? Regards
-
TOP5
Hey Everyone! I'm here again to use your brains! 😁 Our team is trying to visualize a simple TOP5 of interprise partners considering the total sales of each and we need to see that by month for the past 2 years. We already did this: Beast mode code for ranking: The ranking beast mode is working properly when we use a table…
-
Beast Mode Calculation Subtotal/Total
Hi There, I have a beast mode calculating utilization and I want the calculation to occur in the subtotal and total as well however it is not doing that for HTML or Mega Table. It appears to be Summing or Counting. Can someone please assist? Please let me know how I can rectify this. Thanks!
-
Multi-Value chart percent change error?
Hello all, Wondering if there is a way this value is calculated and where the error could be. Chart 1: Current Month - Value 94.83 | Change is -0.62 when compared to 1 month ago (aka previous month) Previous Month: Value = 95.42% Difference Actual: 95.42% - 94.83% = 0.59% Why does Domo calculate this as 0.62% and this…
-
Card filter not showing all options
Hi there I have a card looking at the email domains of users. I want to filter out public domains like Hotmail and Gmail to look at institutional users. The filter is only showing me A-H of what is a long list. Is there a way to get access to the rest of block the domains I don't want to see?
-
Total row sum % instead of doing the % calculation
Hi, I use one beastmode to give me the MTD % of achievement vs the MTD Target. On one card it work with this rule : sum(`product_A`)/(SUM(DISTINCT `product_a_Target_dly`)*DAY(CURDATE())) So it's giving me the MTD % even in the total row. I use the same formula on another card but with product_B.... and the total row show…