-
Any graph/plot that can help show moment of people between different categories over time?
People are classified into groups based on their activity. And the group a person can belong to changes over time. So people move between these groups as time passes. A person can belong to only one group. Is there a graph on Domo that can help me visualise this? i.e. How many people moved from Group 1 to Group 4 in ANY…
-
Possible to filter on one dataset based on the results of another dataset in a page?
I have a user table and an activities table. I want to track the activities over time, but since there are too many activities, if I include a user details for every activity, the dataset will be too large. I want to be able to filter the activities by features of the user. And the features are contained in the user table.…
-
Beast mode to kill div0 errors
Hi, can anyone tell me why If my "A" code works, and my "B" CASE WHEN... THEN 0 ELSE 2 END code works, why can't I substitute code "A" for "2" in code B? I'm trying to kill divide by zero errors in a beast mode. --A SUM(IFNULL(`qty sold instock`,0))/SUM(IFNULL(`qty found`,0)) --B (CASE WHEN (IFNULL(`qty found`,0)) = 0 THEN…
-
Beast Mode: Extract a string from a column based on a custom character is starting from right
I have some data we are pulling in that has a column full of text. The very last part of that string is a part number (variable length) that is always preceded by a dash. I'm wanting to split the column from the right at that dash. How would you do this with Beast Mode? Examples: (the part number is shown in bold)…
-
Show only Max Values in a chart
Hi, I have a line chart like the one below. For each of the trend lines, I want to show the value when its the max value in that trendline. For example, in the bottom most trendline, I want to show the value only for "2021-02-09" as its the highest value in that trendline. Is this possible in Domo?
-
Beast Mode - CONCAT with a carriage return?
Looking to CONCAT several address fields into one, but with carriage returns between Name Address City State, Zip Any thoughts on how to accomplish this in a beast mode?
-
Previous Row + Following Row: Cumulative Sum
Previously, I was provided a video to help with receive this result, but didn't realize that performing it in View Explorer didn't quite work, so I sadly had to create an thread for the same question. Using Magic ETL I would like to find a way to take the previous row + the following row, keep the sum and continue to add…
-
Using Checkbox how do you group the dates by week?
Is there a way to show dates as a group using the checkbox selector. example below.
-
Page Analyzer Links (or Deep Linking with Filters)
I am trying to create this BM calc but instead of the example shown in DOMO where you create a column with the link (Deep Link Col3) and also display the value (Owner Name Col1) I am trying to do it as one column but I am getting an error on the card. The link takes you to the page and you can see the filter is added to…
-
Deep Linking with Filters -- Special Characters?
I have a beast mode that I am using to pass along page filters as a hyperlink. It looks like deep linking does not properly work with special characters like a "+" sign. Beast Mode: case when `Designation` != 'Subject' then CONCAT('<a href=''https://woodpartners.domo.com/page/2101023617?pfilters=[' ,'{"column":"Name and…
-
Difference between preview and data table
As you can see my data table groups by month which is want to achieve and my preview doesn't. I've no filters or any sorting. I am probably overlooking something simple but I tried following Onyx' his tutorial (https://www.youtube.com/watch?v=cnc6gMKZ9R8) about window functions but I can't seem to group by month. Should I…
-
Updating individual rows- dataset
Hi, I have used an excel upload for my dataset, and want to know if it is possible to make changes to individual rows within DOMO using Magic ETL or another function? For example, if I need to update a specific field within a row, without having to make the change offline and reuploading the dataset. Thanks
-
Deep Link Weirdness
I have a card deep link that has some weird behavior I am hoping someone here can help me understand how to address. I build the deep link and it works great for me (I am the admin). When my users attempt to follow the link the card opens, but the filter in the deep link does not apply. They are seeing all rows... I have…
-
Error using Multiple Filters on Beast Mode
Dear friends, I trying to create a Multiple filter on Beast Mode following the instruction given on the link below. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Sample_Beast_Mode_Calculations%3A_Miscellaneous_Transforms When a execute a test Domo returnos error…
-
Leading zeros in csv exports removed
I have several scheduled reports where the leading zeros in certain fields are removed. The field itself is formatted as text, and it shows up properly in the cards, however once it is emailed in a .csv file those zeros are gone. Is there a way, maybe even in the ETL or the card, that I can prevent this from happening?
-
Positional Inventory
Hi, I am looking to build a beast mode calculation to give me the sum of my data based on the max date currently in my card. So if I have the card at the day level I show the sum of inventory position of that day. If I have the card at the week level I show the sum of inventory position of my last day within the time…
-
How to disable "Quick Sort" on graphs?
I would like to remove the ability for a user to quick sort at the dashboard level (not in analyzer). The quick sort can make things a bit messy and is not very intuitive. It doesn't serve much purpose especially when a graph is meant to only show the Top or Bottom X # of records. Quickly sorting from Low to High would…
-
Beast Mode Calculations missing on subscriber instance
Hello , I have a few bm calculations created on my end and published into a subscriber instance. When I go to look at the charts though I get an error that the calculations are missing although they are there on the source. I have to pull in the field again for every chart - any thoughts?
-
How do we calculate current day Vs Previous day in Domo.
SUM(CASE WHEN MAX(`Day`) = DAY(MAX(`Day`))-1 THEN `Visits` END). I tried this, but this is not working
-
Drill Down From Summary To Detail Records
I know how to use different tables on cards when drilling down. My question is around handling drill downs from a summary table on the first layer/card to a detail table when drilling down to a second layer. The summary table holds KPI's such as # of created requests by month, # closed requests by month, # active request…
-
Adding a line on bar-chart
Hello, I have the following bar chart, it has some metrics and a target line that was defined under the "Scale Marker" section. I would like to add another point of data in the form of a line but I am not sure how to. Ideally, the card will include this other point as below: (sorry about the ghetto and bad drawing) The…
-
Average of an Average of an Average
Hello, I have a project that is using an interesting methodology to score social media ads/campaigns/accounts. They first score each ad, then they average the ad level scores to get the campaign score, then they average the campaign scores to get the account scores. In the example above I score the ad based on the…
-
Problem with Flex Table input columns
I was looking into Flex tables for some of my work which includes dates, numbers and label columns. I don't why my Flex tables has only two input columns while I found on the documentation on Flex tables has three columns. Is there some configuration or anything I am missing on my organisation domo. Any help would really…
-
Is it possible to add multiple image tags in a single table cell?
I want both of these images to show AND be clickable in a single HTML Table cell <a href="https://www.walshportal.com/walshintegrated/images/logo-white.png" target="_blank" rel="noopener noreferrer"><img height="20px" src=https://www.walshportal.com/walshintegrated/images/logo-white.png></a> <a…
-
Exporting Dashboard to PDF - Sorry. This content is no longer available
When exporting a dashboard to PDF/Powerpoint I get a couple of cards that do not export instead there is a placeholder that reads Sorry. This content is no longer available. I have tried messing around with the dashboard layout but there is no change. If I revert to standard page everything exports correctly. I have also…
-
Duplicate Entire Dashboard
Is there a way to duplicate an entire dashboard with all of its subpages as a new dashboard? When I use "Save As" the new subpages will still link to the old dashboard.
-
Is it possible to hide cell content in an HTML table based on security group?
Hi, I'm using an HTML Table and I would like to hide the contents of a cell based on the logged in user's membership in a Domo security group. Is this possible?
-
Calculation for days between 2 dates
I have a dataset that has 2 dates auction date and last payment date, both are in the same format "2021-06-03 05:00:00 AM" I am trying to write a beast mode that will count the number of days between the last payment date and the auction date. I struggle with any date statements, any help would be great!
-
Is it possible to hide the PDP symbol on cards to end users?
Hi, I have a DataSet and a PDP specified for it. End users of cards which use that DataSet see a shield-like icon like in their cards. It sometimes overlaps over the Data Tables associated to some cards, hiding values that lie in the corner. It there a way to minimize that icon, or to avoid showing it altogether, even as…
-
Linkedin Report
Hi Guys, Need your help, Does anyone know which connector I should use for "Linkedin Campaign Reporting". I am specifically looking for the below fields in my DataSet. Campaign Group Name, Campaign Name, Total Spent, Impressions, Clicks, Leads, Cost per Lead, Reach, etc