-
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…
-
Create a cars to show Domo Email Interaction/Engagement
Hi Guys I`m looking to to create an "engagement" report based on Domo Email. We`ve created a number of automated reports that are sent out at periodic times. My theory is that the end users are getting the information that they need from these email, causing logins to decline..... and therefore are the users licenses…
-
Domo card total columns is correct, but rows are incorrect
The total figure of 361,646 is correct, but the totals for each month are incorrect and clearly do not add up to 361,646.
-
Need variable past/future daily date range with ability for user to adjust
I have a number of cards where I need to present daily data with a range of past and future dates. I've found that I can easily fix the date range, and this then still gives users the ability to modify the dates when using the card. This last part is where I am having trouble, as I know I can use a beast mode to create a…
-
Different Date Label on a single chart
I am trying to show a monthly/quarterly trend chart showing actual and forecast numbers. Is there anyway to label the date for actual and forecast differently? For the year of 2020, Jan through June would be labeled a regular date, but July 2020 and forward will be labeled something like July-2020(F) and so on. Thanks Juan
-
Pivot Table Average Summaries instead of Totals
Hi all, With the new pivot table card designs we can add Totals and Sub Totals which is great and sums values into collapsable groups. I can't seem to see a way to set a similar summary using a different aggregation like average, count, min and max. For example, I have data showing a number of staff working hours which are…
-
Filtering on Checkbox "Not In"
Hi there, I've gone through the Filter Cards properties in the Knowledge Base section, and doesn't mention about a "Not In" option. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Slicer%2C_Checkbox%2C_and_Radio_Button_Cards I'm building a Story Dashboard about Transport Carrier…
-
Calculate Average and Standard Deviation with missing dates in time series
When calculating the average usage and standard deviation for a list of parts based over a time series the results are not what is expected. The problem is not having a complete list of dates for each part number. I would need to generate the missing dates for each item number with a value of zero for the equations to work…
-
Changing colors on a treemap
I have a set of server applications which I want to track the status on the dashboard. Each application should have it's own square with a color associating with the status. My data looks like the below: app_name | status | color app1 | ok | 1 app2 | not ok | 3 app3 | warn | 2 The only way I found to create equal sized…
-
Use pfilter to limit data to 50 rows
For an embedded card, we want to limit the used rows for the visualisation to eg 50. We use PFILTERS to filter the data for a specific client, so that data is already filtered. Is there a way to limit the data to the most recent 50 rows? (the card is already sorted by date column)
-
Why I can't drag column to analyzer
When I drag a column named "Created" to x axis, but nothing happens, the column is not applied to x axis. How can I apply columns to x/y axis. And it seems like that all the "Drag column here" are not available. Could you help me?