-
Shape Gauge
I have a data set that lists the NPS rating a customer inputs on all our interactions. The customer has the choice between 0 - 9 to input a score. The data is in an excel file, I have uploaded this in the workbench. I am trying to create a shape gauge card that will display the count of each choice. I am inputting my…
-
Top 10 with WOW(Week over Week) comparision
Hi, I have a card where I show previous week data by top 10 review projects by timekeeper. Now, want the format to be the same, but want current week bar next to previous week. I am aware that with period over period we need to change the chart type, and have the date on the x axis at least, but then we are not able to…
-
Is there any way to show the card description on the card when on a dashboard?
I can't find it. I made a useful description. I want to show it on the card. TY
-
Hover over hyperlink
Hello, Is there any way to create a text while hovering over the hyperlink text (hyperlink display as)? Thanks, HF
-
Capture Card Summary data on a schedule
Hello. I have a card that is continually counting how many "wigets" meet a certain criteria. The number changes hourly. I'd like to capture that card's Summary number at various intervals (maybe hourly) during the day so I can report on trends. Any easy way to do this? Unfortunately the source data changes when it updates…
-
Adding "Last Updated" Label to Card
Is there a way to add a "Last Updated On....." label to a card? Our data updates roughly every 2-3 hours and we would like the users to see on the card when the data was last updated. Example: Last Updated: 2/14/2020 10:21AM MST Thanks, Ryan
-
Round function
Hello, I have a beast mode that calculates a % and I need it to round to 2 decimals. I'm using the round function as described in the documentation: CONCAT(ROUND(1-(COUNT(DISTINCT `nc_list`) / COUNT(DISTINCT `lot_number`)),2)*100, '%') However, the result is being rounded to the whole number I need it to, using the example…
-
Treemap Chart Customization
Is there a way to organize the treemap chart to a custom layout?
-
Gantt Chart Filter to Limit Data to only Records active Between Dates
I have a Gantt card that uses a Start Date and and End Date to show the span of each record. Some records can span multiple months, quarters. I want my end users to leverage the filter in the upper right hand corner so that they can more clearly see the records that should be in process during a date range that they…
-
How do I delete a dashboard page?
I see the manage pages button but nowhere to remove a page I don't want anymore. Thank you!
-
Conditional formatting in pivot tables
Hello folks, hope all is well! I have 2 tricky questions: 1) is there a way to achieve conditional formating in pivot tables (I'm tracking daily/weekly/monthly changes so it would be beneficial to highlight the direction of change). 2) what would be the way to do calculations, e.g. June vs July = -5000 visitors, so to show…
-
Story Page: Make note card that stores historical data and filters with page date filter?
I am building a story page for a weekly situation report, that used to be on an excel file. The file stores historical data, but also includes a comments section that can be looked back at. How can i make a note card/document card that my controller can make notes in every week that has a date filter so that historical…
-
How do I calculate days remaining in a fiscal month?
I need to grab today's date and find out which month it falls into. For example, today's date, according to this calendar, falls in the fiscal month of August. I need to calculate how many days there are left in each fiscal month. The answer here would be today's date (7/29 subtract 08/22) and that answer in a new column…
-
How to fix a target line independent of filter selection?
Hi, I build a card that shows monthly sales volume (bars) and shows the average sales volume per consultant as a line (=target). Now, I added filters at the top, that allow to select for a specific consultant. I would like to fix the average sales volume, such that when selecting a specific consultant a direct comparison…
-
Configure two differently labeled date categories to filter together?
On my story page, i have a card that measures the date metric as "closed date", but i use a date filter card that filters the rest of the cards on the page for a weekly report. When i try to filter by this date, the card does not work and gives me false information. I want to make it so that i don't need to add another…
-
Date Range Filter with Drill Path
Are we able to use the Date Range function at step two or three of a drill path? I am only seeing it on the first level card. Some users want to see a specific date range when first viewing the card, and then, after drilling in a few levels, they would like to shift the dates. Is this possible? Thanks
-
Creating a Pivot Table Card where the default view is COLLAPSED
Hi Everyone... First post here. Just finished my professional cert level 1 to give you an idea of knowledge level. I created a pivot table chart and by default I have a QTD date range broken out by weeks. My column hierarchy goes -> Week (based on our fiscal calendar) -> Campaigns -> dimensions/metrics. We might be running…
-
Mega Table Dynamic Paging
Per the 7/14/2020 release, there is a dynamic paging feature added to Mega Tables. Does anyone have any additional info on it (how it works, etc.)? I can't find any references to it in any of the help documentation. Thanks!
-
Suppress banner and card titles in slideshow
Is there a way to suppress the banner and card title for cards published in a slideshow? We are publishing slideshows on pages in a Google site and would prefer to use the site headings for titles so that they show up in a table of contents at the top of the page.
-
Change which is the line and which is the bar in a line + Grouped bar
Hello, X axis is Date, Y axis is summed value, Series is the type (in this case actuals and plan). Domo defaulted to actuals being a line, and plan being the bars. Nobody thinks this way. Interestingly, if I look at only current year, it displays correctly with goal being the line because there is no goal in the series for…
-
Graph by 1st-15th / 16th-EOM
Hey everyone! I am using DOMO to run commission reports and I am curious if there is a way to graph by 1st-15th and then 16th to the end of month? I know I can Graph by Day, Week, Month and so on but is it possible to do biweekly? Thanks!
-
How to align scales when using bar and line chart
Hi, I am using the line + stacked bar graph, I added a target line (case when date then 20 end) and now I have 2 different scales. I would like the left and right scale align in values otherwise the traget line is confusing.
-
How to add a Target line
Hi, I am looking at how much time consultants spent on the phone and the traget is about 20%. How can I manually add a horizontal line that shows 20%?
-
Changing the Content of Exporting a Page
Is it possible to change the default content when you export a page to PDF or Powerpoint? I don't want to include who the owns the page. The exports will go to our customers and they don't know me. The customers interact with account managers and displaying "Owner" on the title page is confusing and looks like the wrong…
-
Get Data Based on Comparison of 2 Dates
Hi, I have a Dataset with 2 dates open_date,closed_date for a category(has 2 values open,closed). I want to build a weekly bar chart with a count of category where the date range is selected for the column open_date but the date range should also be applied to closed_date as well. For Ex:- Open DateClosed…
-
Static national average not affected by filters
Hi, I am looking to create a DOMO card with a static national average line that does not change with filters. The goal is to be able to compare a filtered view against that national average directly in the card. Has anyone done anything similar? Any help would be greatly appreciated.
-
Anyone know how the dropdown filter card was made in the Domo Covid-19 public dashboard?
(Picture attached) We're trying to make this card in our dashboard, as the UI seems vert clean. I could not find this card type in analyzer. Anyone knows if we can use custom web development to make this card, and then embed it in our instance dasahboard, and if yes then any resource to look at?
-
AppDB Pagination
Im using AppDB for storing data in my custom Domo app. Wondering how i can do paging with AppDB since i can't find any paging instruction in AppDB documentation: https://developer.domo.com/docs/dev-studio-references/appdb#Querying%20Documents
-
Percent/Absolute Change WoW as a Beast Mode Column
Hello, I am a cardbuilder for my organization and I am having a tough time getting a Week over Week beast mode calculation correct. Our calendars are set on an admin level so the fiscal week is Monday - Sunday. In the screenshot attached, I want to show the % change WoW for the metric "Clicks". I want it so it will…
-
Best Practices for Large Financial Reports in Domo
I just wanted to propose a question that we are struggling with. I am wondering if there is anything you could do that is more intelligent than the out of the box solutions. Prepping the data in a certain way in an ETL would be an option for this if it would help us with the final user experience. We are trying to get here…