-
Parameter Filer
Hello everyone, I wonder if someone has successfully figured out how to create a parameter filter in DOMO. I want to create a filter that allows dashboard readers to choose which two years they want to compare (e.g. 2021 vs. 2019 or 2022 vs. 2024). Thank you very much. Best, Anna
-
Beast mode to only show matching creative types in grouped bar chart?
We are using a grouped bar chart to compare client and typical engagement rates by creative type (see 1st screen grab). The report is filtered by a SalesQuote field where client results have one value and typical results='Banner Average'. These are unique rows in the data set (see 2nd screen grab). There are six 'Banner…
-
How would I get a percent change for each t value from baseline and chart it as a bar line graph
/* Get RCI avg of all scores that aren't baseline CASE WHEN `summary_order_rule` > 1 THEN AVG(`RCI`) Get RCI avg of all scroes that are baseline CASE WHEN `summary_order_rule` = 1 THEN AVG(`RCI`) END Get %change between baseline and followup scores for each summary order ((avg_followup - avg_baseline) / avg_baseline) * 100…
-
Hyperlink to Sharepoint
Hi, I want to create a hyperlink to a sharepoint file from my domo card. The hyperlink is working correctly to the sharepoint destination. I would like the user to be able to choose a record and be taken to the matching record using the link, the only field I have to utilize is 'Name'. I found a discussion with this…
-
CY vs PY and Multiline Chart
Hi All, I am trying to build a multiline chart that would have 2 Y-axis line chart. Y1 Axis to show Cumulative Line of YTD Sales vs PY to Date Sales and Y2 Axis to show YTD Average Sales vs PY to Date average sales. I have tried all the available line charts and seems not to be the one as per the picture attached. Also,…
-
Filtering on an Aggregate FIeld
Hi everyone. I'm a novice at SQL and more specifically, DOMO. This is also my very first post on this forum so forgive me if I've not followed a proper format or given enough specifics upon first request. I currently have a table card that aggregates a dataset by sum. For example, there are 4 line items and I have a BEAST…
-
Help use a beast mode to dynamically filter a dataset
I have a beast mode that returns the name of the current day. I want to filter a dataset to show only the rows where the Day column in my dataset are equal to the name of the current day. Can someone help?
-
Month Over Month % Change of Total Number
I have revenue figures recorded at random intervals of days throughout months. It has not been updated since June, so I cannot use the automatic date filters in Domo without manually going in every month it gets updated and changing things around. I was able to get the most recently updated month and the prior month totals…
-
FIXED Function As Background Filter
I have a headcount dashboard where I would like the cards to render 0 values in case of any filter combination resulting in the headcount <3. I created a beast mode calculation using fixed function to use it as a background filter in the cards. however when I am adding it to the cards and try to save it, it throws an error…
-
Help with a complex calculation that isn't working in Beast Mode.
I am trying to calculate a comparison of an individual's performance compared to the established average. This is for setting appointments. The appointment conversion ratio is found by (appointments set / number of contacts). The appointment conversion ratio / average gets the performance multiplier. 1 being average, 2…
-
Using Variables in Beast Mode
Hi all, I'm trying to write a Beast Mode and it would be much easier if I could declare a variable to make my code a bit simpler. I would want to do something like this: CASE WHEN `Date of Death` is NULL THEN FLOOR(DATEDIFF(CURRENT_DATE(), `Date of Birth`)/365) ELSE FLOOR(DATEDIFF(`Date of Death`, `Date of Birth`)/365) END…
-
Beast Mode
Hello All, New to DOMO and I wanted to check is there a way to reuse an already calculated field in another calculated field instead of re-writing the whole logics again? Example: CF1 = sum(A+B) CF2 = AVG(C+D) Why can't I write a 3rd calculated field as CF3 = CF1 - CF2
-
Beast Mode Formula error
Could you please help me identify an error in my formula: POWER((SUM(CASE WHEN Parts Kits Fiscal Year=SEG PMKA CAGR End Period THEN Parts Kits Qty END) / SUM(CASE WHEN Instrument Fiscal Year BETWEEN SEG PMPK CAGR Start Period AND SEG PMKA CAGR End Period THEN Instrument Qty END))/(SUM(CASE WHEN Parts Kits Fiscal Year=SEG…
-
Calculating Week on Week customer retention
Hi, i need assistance calculating week on week customer retention using a domo beastmode on a transaction dataset. Dataset appends new transaction based on the transaction date so a single customer has multiple rows of transaction distinguished by transaction data
-
Domo Ideas Exchange - Beast Modes - First / Last Days of the Month / Week
Problem: How Do I calculate the start or end date of the week or month? Solution: Last Day of the Month: This is fairly simple as we can use utilize the LAST_DAY function which will return the last day of the month for the provided date. LAST_DAY(`dt`) First Day of the Month: For this we can do some simple math to subtract…
-
This is coming out to be a date format beast mode. How can i change this to integer?
(((DATE - Lag(DATE,1) over (partition by ID,FAMILY order by INVOICE))))
-
Group By Condition in beast mode
It would be nice to have a "Group by" condition in beast mode
-
Sortable Link
We know how to add a link field to a table, using: Here is a way to get it to be sortable… Insert a throw-away attribute to the left of the link. instead of CONCAT('<a href="', `Card Link`, '" target="_blank">',`Title`,'</a>') UseCONCAT('<a title="', `Title`,'" href="', `Card Link`, '" target="_blank">',`Title`,'</a>')…
-
How do I get the following aggregation setup in domo?
I have a dataset as follows: and I want the aggregations as shown below (number sum is just the sum aggregation of column 'number' the first table is the actual data and the next three tables are the aggregations I want in the same sheet (i.e. the user should be able to add/remove the columns on their own and see those…
-
Greater than current date
Hi, I'm working on a beast mode that groups sites into four buckets (Digitisation, Acquisition, Portfolio, Buy Out'. The last 3 are working fine and I just need to setup the formula for 'Digitisation'. The logic for Digitisation needs to be 'if Contractor completion is greater than or equal to CurrentDate then…
-
Distinct Count with Case statement not working
This is a bit of an odd issue, the below calculation ends up adding 1 when rolling up data: Distinct count of ID (if Flag=1)=COUNT(DISTINCT CASE WHEN Flag=1 THEN ID ELSE 0 END) ID Flag Distinct count of ID (if Flag=1) GRAND TOTAL 1 2 456123 1 1 123456 0 1 654321 0 1 Any ideas why this might be happening? This is a mega…
-
Is there anything wrong with this calculation?
((case when Date = '2023-03-01' then sum (test1) end ) - (case when Date='2022-03-01' then sum(test2)end)) / (case when Date='2022-03-01' then sum(test2)end) Trying to calculate the %chg between two points in the dataset
-
Making a formula that produces value from another column when conditions are met
Hi, I am trying to make a formula I feel like I have built a million times and for some reason, this is not working for me. Can someone tell me what is wrong with this formula? I am just trying to make a new column in a view that basically says if the "Current Log" checkbox is checked and if the "Website Status" is…
-
beast mode using rank function
I have created a beast mode using rank() and using it to filter a chart. It is able to process the desired chart. But while saving the card domo says "There was a problem saving your card. If the problem persists, contact the Domo support team." RANK() OVER (PARTITION BY first_day_of_month ORDER BY COUNT(DISTINCT user_id)…
-
Want to add minutes of a particular day from different rows
I want the sum of downtime in minutes for a particular day. Eg: 14th May had a total downtime of 33 minutes. I want to have a single row for 14th May with downtime 33 minutes. How can this be done?
-
Quarterly Chart
I am trying to create a line chart and graph it by Quarters but the only thing is that instead of summing the values or taking their average, i want to only take values for the last month of the quarter. e.g For 2022 q1 it would be march 2022 , q2, june etc
-
Prevent Beast Mode Sharing on Dataset
Is there a way to prevent users from sharing Beast Modes on datasets but still allow them to create cards?
-
String Aggregation in Beast Mode
Hello everyone, I am trying to come up with a table that shows the unique emails of subscribers, and to which partners they're subscribed to. I'm trying to concatenate the partner field so that those with multiple subscriptions will remain unique. Is there a way to do this in a beast mode? I saw in some training video that…
-
Hi Team, Need help in converting a string value to date.
Hi Team, I have a column which is has string values. This column has data related to months and years. Example : Jan-23. The problem is when i am using this column in the chart, its not detected as a date and so i do not get options to filter month and year. I want a way by which i can convert these to a date value. And…
-
Remedying Data Recording Issues on the Front End in Domo
I have a dataset with item names. These item names have a preassigned "price" to them that is not in the source data (although I know what they should be). What has happened is that some people (not all people) record their transactions all at once, combining what should be multiple revenue values into a single one.…