-
Excluding Current Month (but on a different fiscal calendar)
Hi - we work off a broadcast (Monday-Sunday) calendar and was wondering if there was a beast mode that can exclude the current month? I've tried a few versions found on the dojo but since I'm checking "use fiscal calendar" on my graphs (eg: bar chart) it seems to not function correctly. Eg: Case when Month(`Date`) <=…
-
Sum value on a specific time window deduplicating
Hi all, I'm trying to solve something a bit weird. It was working correctly, and without doing anything, my card is not working anymore. When I'm editing it, it's completely broken Type of data date|service|daily_service_sales|placement|daily_placement_sales 2021/04/01|Service_A|80|Placement_AA|10…
-
Preserving Rich Text Formatting from Jira
My team is leveraging a Domo Workbench connection into a on-premise Jira instance. Jira allows rich text formatting in many of the fields that we need, and I'd like to preserve that when I display the data in Domo text cards. I can see the patterns in formatting when I compare my Jira input to my Domo card (ex: [text] = _…
-
Tableau-like parameter actions
Hi all, I'm trying to use a filter inside an aggregation. My data looks like this: On a page, I want to add a slicer/filter that would allow a user to choose a fruit. This would filter the line chart below which would show % of count that the fruit makes up each day. So if a user selects apple, the line chart would have a…
-
Only include the first instance and ignore others in beastmode
Hi all, I'm trying to calculate between signup and the first sale: DATEDIFF(`sale_date`,`signup_date`) Which works fine. Only problem is, is when a person makes multiple sales it does counts towards the average. Is there a way to ignore any other instance and pick only the earliest date? Thanks in advance
-
Compare month to month | Table
Hi all, I am trying to get a table to show the difference between this month and the month prior: January | 100 | February | 50 | -50% April | 200 | +400% But how? This should be possible via beastmode but I can't figure it out. I tried the month over month charts but they also don't show what I want so I want to try it…
-
MoM variance calculation
Hi all, I am looking to create a variance calculation for change in 'amount due' over months. The date column I use is "Invoice Date" and I was hoping to create a column that shows the variance from jan to feb, feb to march, etc.
-
Color rules - logic based on other columns
Often times with color rules, we want to base the color on the value of another column. Few examples: 1) There is a Value Column and a Goal Column: -When the value is greater than or equal to the goal, color Green -When the value is less than the goal red 2) Color the Value column by a calculation: -When the value is under…
-
Initial Card Selection Settings
Every time I create a new card, the card opens with a set of pre-filled settings (a chart type selection, X-axis and Y-axis variables selected, a Summary Number selected). I have to un-click these selections each time before I begin building my card Is there a way to turn off these auto-filled selections? I looked…
-
How to identify and visualize the Top N percent
Given a set of companies and a revenue number associated with each one, sorted by revenue in a descending manner, I'd like to visualize the subset of those companies that comprise the Top-10% of all revenue. For example, if the set consisted of 90+ companies... Company1 $5 5% Company2 $5 5% Company3 $2 2% Company4 $1 1%…
-
Conditional formatting
Hello Members, I have this unique situation where I need to show both Actuals and Plan bars ( preferred). But if my Actuals are less than 25 % of the Plan ( which is true in this screenshot ) , I want to show Actuals bar as red color.. I am open to switch to different chart but at the end I want Actuals to be shown in red…
-
How to custom sort a Quick Filter
Hi, Is there a way to sort this quick filter in the order below - Past Due >25 Days Past Due 21-25 Days Past Due 16-20 Days Past Due 11-15 Days Past Due 6-10 Days Past Due <5 Days Current <5 Days Current 6-10 Days Current 11-16 Days Current 16-20 Days Current 21-25 Days Current >25 Days Best, Varun.
-
How to conditionally format color on Stacked Bar + Symbol Chart
I have a dataset that looks like this: Each row is a day an employee was active. If this was the employee's first day, Hire Flag = 1, else 0. If this was the employee's last day, Term Flag = 1, else 0. I am building a chart to show hires, terms and net over time. It looks like this: I am using a Symbol + Stacked Bar chart…
-
Drop down list - similar to data validation in Excel
Hello, Currently I have a file in my SharePoint that I maintain daily (adding new information). My goal is to upload the file as a dataset in DOMO and to further maintain the needed information here and not in the SharePoint but I wish to keep the data options in certain columns limited by having a dropdown option in each…
-
Is it possible to create a filter view based on a beast mode?
Hi, I have a beast mode attached to a dataset. I know the Card Analyzer lets you filter a card depending on te value of a beast mode. But, is it possible to create a dashboard-level Filter View based on the the beast mode?
-
How Can I Hide The Subtotal Label Value?
We tend to use subtotal rows more for grouping than we do actual "sub-totaling" the rows. When no subtotal label is entered, it will just default to "Total". How can I have no label and just bring up the record value only? Also, any tips and tricks about grouping rows? Has Domo ever thought about allowing you to group…
-
Avg Per Hour
I'm trying to use the analyzer tool to get the average number of posts per hour. avg(COUNT(DISTINCT `Permalink URL`) over(partition by HOUR(`Created Time`))) I want to be able to use the following graph where the series is the average. For some reason, when I run the query, nothing comes up on the graph and it turns blank…
-
Comparative Gage - What's wrong with my query?
Using the Comparative Gauge, I wanted to display our performance by whether the number of impressions have increased or decreased. Only, when I use the following window functions, I get a blank card with a downward arrow. Current Month: sum(case when MONTH(`Created Time`) = MONTH(CURRENT_DATE()) then…
-
Finding the Max Average
Can someone help me build a beastmode to locate the max average? I am trying to return the average day with that, on average, shares the highest value of the week. By taking the max average of days, with the max average of days with the highest values, is it possible to discover the day that returns the highest avg? I…
-
What does 'Last 3 Years' mean?
Hello, When Domo uses 'Last 3 Years' for a date range, does it mean data from 2018, 2019, 2020, and to present date in 2021, or 2019, 2020, and 2021? Or is it April 15, 2018 - Present Date? I am having some data that I expect in my results, but there is some data missing and I think it is because I am using the 'Last 3…
-
How do I preserve color in custom chart?
Since cell color options are lacking for pivot tables, I decided to use a custom chart. But when I upload my svg, all color information gets wiped. Is there a way to preserve it like the example that you have in your custom charts site for college campus map?…
-
Unify two filters in one Beast mode function ?
Hello, In a card, I edited a Beast Mode function in order to combine two filters: (case when (`Distributors`='DistributorA' and `Country`='CountryA') then 'Distributors' else 0 end) (case when (`Country`='CountryB') then 'Distributors' else 0 end) I would like to combine these two in one unique Beast Mode function like a…
-
Frequency Chart / Histogram
Hello, I have a range of Velocities (ft/s) and I am trying to show how many jobs we have performed within this range of velocities. I need to remove the decimal places and would like to round the numbers up. Is there a function to do that in beast mode or ETL? Then I would like to create a card that shows number of jobs…
-
Values showing as Number with K -how to remove/change?
Hi, I have a list of pressure values in psig and I am trying to show a histogram of the range and number of jobs we have done at these different pressure values. The issue is that the column is a number and when i create the chart, DOMO is picking up with psig value as a number and adding a K to it. How can I change this…
-
CY-PY calculation for a value within a column
The issue I am running in to is how to call out the value with in the column i want to find CY-PY variance. I am using the formula from Domo page on the topic. In that formula it only has use using a single column. How can I find that variance of one single value with in a column? SUM(CASE WHEN YEAR(`Activity_Date`) =…
-
I am trying to get the timecards created this quarter for last quarter
I am trying to get the timecards created this quarter (Q2) but for last quarter (Q1) the reference dates are created date(current quarter) and end date(previous quarter) so, I have this created in beastmode>>> (case When `TC: Created Date` >= '4/1/2021' and `TC: End Date`< '3/31/2021' then 1 else 0 end) how can I make the…
-
Changing Date Format in Period over Period Additional Text
Hi, I have a Period over Period Multivalue chart. I am comparing yesterday's number vs same day a week ago. When I add the CURRENT_PERIOD_DATE AND PREVIOUS_PERIOD_DATE in the "Additional Text" they show up like below (2021-04-11 and 2021-04-04). Is there any way to change the format? I want it to show up as 04-11 vs 04-04.…
-
Global Map, can you have dynamic filters
Hi, I have a global map card which shows our total number of jobs per country. We have different job types and ideally I would like to show these on the map but in a different colour. Is it possible to have the map coloured in relation to the filter "Job Type"? Thanks,
-
set custom start days of the week at a card-level
Hi All, I want to set custom start days of the week at a card-level, I referred the article(https://dojo.domo.com/discussion/47172/changing-a-day-week-start-to-friday) and created below beast mode. case when DAYOFWEEK(`Start Time (UTC)`) = 1 then 6 -- Sunday when DAYOFWEEK(`Start Time (UTC)`) = 2 then 7 -- Monday when…
-
Help with Beastmode on Count with Condition
Hello, I feel like this should be a simple thing to do, but am stumped. I am trying to do a count of order numbers where there is a condition to be met. Is there a if function that I can follow to do this? For example, there is a list of vendors, some of which have registered and some have not. I want to count the # of…