-
Weighted Averages of Summary Data
Hello! I am trying to create a pretty simple bar chart visualization based off of sumarry data but with numerous filters. The summary data that looks something like this, where I'm charting the average of X-Y average : XYNX-Y Average00100050%0190060%0250070%0330070%0430070%0530070%0610080%0710080%0810080%…… 88100050% The…
-
Natural log (ln) in beastmode
Hello, Does anyone know how I can perform a log calculation in beastmode? SQL has the LOG() function but beastmode doesn't seem to have it as far as I can tell. Thank you! -Derek
-
Period over period card- Day of Week instead of Date
Has anyone figured out how to update a period over period card to say the Day of the Week (i.e. Sunday, Monday, Tuesday, etc) instead of the date?
-
how to get distinct emails
I have create a card to show the monthly subscriber, I then wanted to do a drill down to show the exact emails for the subscribers. However, there are dublications in the emails, how to only show the distinct emails? Thank you.
-
Custom Data Label
Hi guys, I am facing an issue where I need to create a custom data label at the top of a stack bar chart. The 100% stack bar chart is used to display the sentiment of a brand ranging from positive sentiment, neutral sentiment, and negative sentiment. The 100% stack bar chart works perfectly to visualize this data…
-
Heatmap table with descriptive hover text
I have a heatmap table which shows a Red/Yellow/Green status by Solution, over time. The dataset also includes notes about the status e.g. 'had a great quarterly review'. I would like these notes to show up upon hover. Is there any way to accomplish this in a way that has a clean user experience? Current setup: Right now…
-
Is it possible to change the font color on the value number in the Spark Line chart type?
Is it possible to change the font color on the value number in the Spark Line chart type?
-
Can you create a BCG or 2X2 quadrant report in domo?
Hi - see below as a visual example of what i am trying to find in domo... https://alesandrab.wordpress.com/2014/09/08/how-to-create-a-bcg-matrix-in-excel/ this is a common visualization for decision making in our company and I'd like to build reports on two dimension any ideas?
-
Retention card - trying to get all employees when filtering by a few months
I'm creating a retention card. Date range is currently set for all time filtering by hire date. When I shorten the date range to 3 or 6 months, I lose everyone who has been hired before the last 3 or 6 months, which makes my numbers inaccurate. If I filter by termination date, I only receive data if the date range is set…
-
Formatting Week Number Display
I have a use case where I need to show charts by Week Number formatted as "W1-19" vs the Domo default of "Week - 1 2019", while retaining the functioniliy of the dimension as a Date type. Does anyone know if it's possible to modify the date format for week number? Thank you!
-
Created vs Resolved chart over month
Hi, I'm importing data from both Zendesk and Jira where I want to create a graph for each with number tickets/issues being created vs resolved each month. However I can't seem to make it right. For my X-axis i put the "Created" value, on the Y-axis i put the counf of ticket/issue numbers and then a series with the "Count…
-
First and last week of the year
When building cards and having it weekly, my cards always shows a dip at the end/beginning of each year. This is because week 1 and week 53 are typically shorter. Has anybody came up with a method to combine these accurately?
-
Trying to use the forecast value in chart properties but getting the error
I'm trying to get a forecast of quantity of sales for the current month using the last value projection in the chart properties. When I select the Forecast Value option, I get this error: An issue has occurred during processing. We are unable to complete the request at this time. Why am I getting this and how do I get…
-
Percent Increase/decrease in hover settings in a bar graph
I have a card with 4 bar lines for each Month. I want to show the percent increase/decrease from previous month for each of the bars when we hover on one of the bars. Is there a way to show the percent increase/decrease for the bar quantities from the previous month ? The Period over Period graph doesn't work as it works…
-
Dates show a day ahead
I am creating a card and noticed that the data in my Date field is being changed, For example 2019-04-17 18:16:00 shows as 18 Apri 2019 18:16:00 AM. I am not sure why DOMO is adding a day to the raw value.
-
Domo Stories: How can you drill your data in the same card?
I'm just trying the new Domo stories option and I'd like to be able to drill data on the same card, I can´t find the option or documentation how to do it.
-
Chart Average, Max, Min with Date/Time
Hello, I am trying to use a Line Graph to see First Reponse Times. I want to show Shortest, Average, Longest. I have a the main date/time, then used Beast Mode to calculate the minutes from the first reponse date/time and subtract it from the main date/time. ABS(MINUTE(`FTechStartTime`) - MINUTE(`ChatTime`)) I noticed most…
-
Hide Legend for Funnel chart
Hi All, As title says, I want to hide legends from showing when i use Funnel chart, I'm getting the hide legend option when i use Pie-chart though. Any thoughts?
-
axis break in bar graph
Hi Everyone, New-ish user, first time poster. I am trying to find a way to add an axis break to a bar graph, but cannot find anything anywhere on the interwebs or in the domo dojo about this. Does anyone know how to add axis breaks?!?! What am I missing here?
-
Date Selector Card - Default Value
Does anybody know if there is a way to set the default value on a Date Selector Card? My situation is that we have a few YOY comparison cards on the dashboard at the day grain. Most users look at the dashboard for the previous day and also current/previous week. If I set the card to current quarter or current year then the…
-
Multiple line graph with bar graph
I am using the grouped bar + line option to graph 3 different columns, currently the problem I am having is that I cannot move the bar and the line graph to the left axis and have the 2nd line graph stay on the right axis. I am trying to move the circled line to left axis. Any insights? Thanks
-
Previous quarter, group by month filter does not show the months in order on the card
is there a way to show the months in the correct order using the previous quarter, by month grouping on a card? when i use these selections, the months show based on the data on the Y axis instead of ordering by month along the X axis. i have attached a sample screen shot. any help would be appreciated.
-
Summary Number not showing in dashboard view
Hello, I have a dashboard that is showing 8 different cards, each with a summary number. Two of the cards are not showing summary numbers on the dashbord view but the rest are. When I expand the card or go into analyzer, it is showing the summary number but not when I'm in dashboard view. Is there any way to get this to…
-
How to creat a filter for currecy change
Hello, I wonder if someone can give me some ideas on how to do this: I have a coulmn for SpendingCost that contains both Euro or USD. I created 2 new columns one for EURO as SpendEuro, and one for USD as SpendUSD by converting the currency. Now, in my dashboard, I wanted to set up a filter to let user choose currency type,…
-
Accept two different column names as the same column within the card
Using DataSet via email to load data. Sometimes the date column name is "Source Date (America / New York)" Sometimes the date column name is "Source Date (America / Chicago)" Is there a way, within the card, to have domo accept either as the Source Date? That is, NOT to build a data flow to address this issue, but some way…
-
summary number
Hi, I'm very new to DOMO and can't figure out this summary number right.... I have no idea where the summary number 15.0% comes from. If I select only one campaign_name, then summary number is correct but when selecting more than one campaign_name, the number looks really odd. I noticed under filed&function, there is no…
-
Card Building from Domopalooza 2019
During Domopalooza, we saw that some domo clients had nice background images on their domo cards. How can I go about doing that? Is there an app that I need to use to create more nice visuals on my cards?
-
Is highlight filter available in DOMO ?
Dear All I want to know wether DOMO has highlight filter feature ? When you choose spesific item via filter, rather than only showing the items that you are filtering and removing the other items not included in the filter, instead they keep all of the item, but highlight the item that you filter. I attach a picture to…
-
Interactive Date Filter Card
I created a date filter card but I do not understand how a user can select the Presets when the mouse over covers the card with the wrench menu. Any advice?
-
Interactive Date Filter card
Hey all, I'm building out a dashboard where I want the user to be able to easily select a date range for the data being displayed. I've built a date filter card for the dashboard and it appears as the "date filter 1" image. However, I'd rather have the view after you click on the "Presets" button on the top right hand…