-
Using Separate Filters in a Dashboard as an OR type argument
Hi all, I have a situation in which I have a High Roll-up of States grouped together and then a separate State level filter and want them to work together. Example is: Region Filter: -East -West -South -Midwest And then a State Filter of all 50 states. I would like to have the have an option to pull in data that can…
-
Exporting the Predictive Analytics
I really like the predictive analytics piece that was recently added, and I was using a stacked bar graph to see various account spend and future spend. I wanted to export the future values to excel and it seems to stop at current values. Any ways to accomplish this without manually recording the data?
-
Plotting points on a map card
Hey all, I am looking for a way to plot store locations and radii around them on top of a zip code map card with customer count data like attached. Has anyone ever accomplished something like this? Thanks!
-
Correlation Coefficient in Beastmode
Has anyone successfully calculated a Pearson Correlation Coefficient in Beastmode? My idea is to create a scatter plot that graphically displays the relationship between two fields in a dataset, and display the Correlation Coefficient for those two datasets as the Summary Number. For example, if the card is filtered for a…
-
Pivot Table conditional format
Hello, I have a pivot table card where I need to compare if the value is greater than the goal, and paint that field in red. How is this possible? I can only compare it to a single value, but it is not the same over the timeframe I have. Thanks.
-
Error uploading assets via domo publish
Hi , Getting error while uploading to existing card via domo publish command Design can be found at https://pg-azure.domo.com/assetlibrary?designId=7ff12cbf-e2fc-4353-bb5c-93837234d762 X Error uploading assets error Command failed with exit code 1. P.S. This works when connected to Office network but not working when…
-
Prior year bar in YOY card adds an extra day for current MTD
I am working on a YOY bar card and the results for the prior mtd is adding an addtional day. For example, as of today, the bar for this month includes activity mtd to the 20th as expected, but the prior year bars are giving me information through the 21st. January and Feb. completed months are correct. Is anyone else…
-
How to access a particular column value in beast mode calculation?
I want to calculate Salience = This Year/ Total ( 500,000 / 980,000 ) and based on filters Total value will be dynamic is it possible to access 980,000 to access in beast mode? Please tell me how to write a beast mode for this.
-
Can anyone let me know about create a card with multiple datasets?
Hi all, I remembered during our call last Friday, someone mentioned this new feature about creating a card using several datasets. However, I could not find it in the DOMO site about the new features. Can anyone let me know waht si that? I happen to have a stakeholder asking me to create a table card with summaries from 3…
-
Added Filter chart type using beast mode, getting error on click
Hi All, I have written a simple beast mode monthname('date') on a filter chart type to display name of months from date column from dataset. However, on my dashboard when I click on any month and expect the filter to work, like other pages data with respect to selected month, it gives me error message on a click as…
-
Date filter
I want to set up a date filter, however, my current dataset only has a date variable "occurred date" which means only when there is an activity, it will have a date. Is there a way I can set up a date filter with generic calendar date? thank you.
-
Tracking Sales cycle duration
I am looking for best practices or pre set cards that help someone track the average duration for a sales cycle. We currently have 7 stages in our sales cycle and looking for more efficient and accurate ways to track the avg days per stage. We currently have a card that shows this but I am finding that it is not including…
-
Filter Out Current Week in WoW Card
Hi, I'm creating a Period Over Period card that displays number of tickets created as a week over week comparison. I'm running into an issue: I don't want to include the current week since the results are incomplete. * When I use Date Range = This Year, Graph by = Week, and Compare to = 1 Week ago: The Card includes all 52…
-
Assigning color palette for stacked bar chart at once
Hi Everyone, I need help in knowing if we can assign color palette to various categories in a stacked bar chart at once and most preferably pastel color, Because as of now i need to select each category and change its color according to my need of showing a lesser value category with slightly dark color as it would show up…
-
Knowledge Paper so bad
Why DOMO training continues to lag far behind vs. Tableau and Alteryx. They can't even get their knowledge papers right....check it if you wish : https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Stacked_Bar_with_Line_Graph
-
Poll Card
Has anyone used poll cards? I created one but I would like to see who has responded so far. I am not sure when to end the poll because I do not know how many people took it.
-
Filtering Multiple Values in One Column with Match Values
When filtering with Match Values as in the screenshot below, does Domo intuitively understand that these are all individual things to filter out? I cannot use a selection filter in my case because the values are not currently in the data but may be included in the future.
-
Two trendline questions
Hopefully someone can shed some light on two issues I am having. I am trying to compare hiring activity between four different functions, and am looking at the number of resumes reviewed per week. I have attached a screenshot of the card I am using, here are my questions: 1. The date labels are currently Excel format, but…
-
Pivot table-Add one blank row
Hi Team, Is there any option or way to add a row heading and a blank row in pivot table. Something like as in attached screen shot, done for DB1 row and PRG row. Thanks, Neeti
-
Conditional drill down
Good day, I have a card that I'd like it to do a conditional drill down. This is, when in the first view of the card, depending on the selection clicked, go to one of several cases. Let's say I have my overall plant data plus a breakdown by area, all that in the same first view. If I select to drill down to the overall…
-
Post Domo Alerts onto Slack channel through webhook
So I'm trying to post an alert from domo onto a channel in slack. I made the slack app and pasted the webhook url provided into domo's webhook portion within the alert settings. I run a test and it says it sends the payload successfully however in my slack channel, nothing got posted.
-
How do I display Time (mm-ss) as a value in bar chart
Hi - I have tried to hunt down this answer but it is tough to phrase and I haven't found a solution. My time is in seconds, and I used the SEC_TO_TIME function to get a nice output - the data is exactly how I want it. In a table it looks like this: However, when I try to put this information into a Bar or Pie, it shows no…
-
Period over Period - Hourly comparison
Hello, I want to do a period over period comparison on an hourly view. I would like to compare against 48 hours ago but the hour comparison is greyed out. If I changed the "graph by" to days then it shows up but greys out once I change it back to hours. Any idea on how I can do a comparison of hours? Screenshot attached.…
-
Cool Coronavirus Tracker
Domo put this out and is very cool use case of Domo Embed and Stories. Also has code to embed on your own website. https://www.domo.com/coronavirus-tracking
-
Sorting 100% Stacked Bar by category
I have a 100% Stacked Bar Chart for net hours worked. Each bar is an employee and is broken into net hours by pay category (OT1.5 vs. OT2.0 vs. Reg). I want to sort the chart so that the employee with the lowest percentage of OT1.5 is on top and the employee with the largest percentage is on bottom. I started by fiddling…
-
Flex Table with only one column
How do I make a flex table with only one column? I don't want more than one columns, but it seems that the flex table input needs at least two columns to work. Could anyone help? If not, then I was thinking of using a Comparitive Guage as an alternative. However, I cannot make the beast mode calculation as per my needs to…
-
Tiered Date Chart Properties
Has anyone had any luck successfully using the Tiered Dates in the Chart Properties? I haven't been able to figure out how it's supposed to work, and the only documentation I can find on it is the original release notes when it was first announced and one other article that it links to, neither of which go into much…
-
Show Google Sheets text/cell colors in Table
Good day everyone I am just wondering if there is a way to pull the cell or text color from Google Sheets into a Domo Table? We have a google sheet that is updated manually with scheduling information. If an appointment is scheduled then the date is input with red text color, once the appointment has been completed the…
-
Comparing year over year data- by same week day
Hi All, I want to compare the sales volume for 2020 against that of 2019 on a by day basis. For example: 1st Feb, 2019 was a Friday and 1st Feb 2020 was a Saturday. Instead of comparing Feb 1, 2020 against Feb 1, 2019, I want compare Feb 1, 2020 against the nearest Saturday in Feb 2019. Has anyone faced this scenario…
-
Weird Sorting Issue - Total Sales
Hi, Experts, I created a domo card in table view for some top-level KPIs. I am running into an issue when I sort by Total Sales (calculated field/beast mode) by ascending you get the column sorted by 0 to the bottom. When you sort by descending it sorts by blanks. Thoughts or help would be greatly appreciated.