-
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
-
Creating Page Analyzer Links
Hi, Need help with page analyzer links I have a dashboard with about 6 different filters (two of them have been shown below). I have "xxx" ed out the actual ids for obvious reasons. I have two questions 1) How can I pass multiple filter values and multiple field filters over to the new page. I have two fields in my example…
-
Make dashboard bigger
Is there a way to make my dashboard bigger so there is more room for my cards? I am working on a 1440p 27" screen and have a lot of white space. Around 50% of my screen is unused by my cards. Hopefully someone can help me with this as a lot of companies are working on +1440p resolutions. Thanks in advance!
-
Powerpoint plug-in unable to change page filters
Hi, I am trying to use the powerpoint plug-in for customer presentations by changing the customer id using a page filter. In the Domo Choose Cards Wizard, I get the Choose the page filter to apply option but am unable to select any other customer id apart from the default. This means that to change the customer id, I have…
-
SubTotal Category Remaining Amount: How to calculate difference between two columns
How to display the value of "Remaining Amount' in subtotal category: I have the following scenario, using a Pivot table Displaying the budget amount and actual amount along with remaining amount. for every subcategory I do not want to display remaining amount if either value budget or Actual value is 0. However I will…
-
Comparative gauge and filters?
I am trying to build a gauge that shows a % for the currently selected company value in comparison to the % for the community as a whole. The problem i run into is that as soon as I filter the card to the current company, I no longer have the entire community's data to compare against? I don't see any way to just filter…
-
Remove date from timestamp
Hello, If I have a timestamp that includes month, day, year, hour, minute, second, as follows: 2020-08-12T16:57:45Z How do I get a timestamp that shows just the time and not the date? Thank you.
-
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…