-
Period over Period - Month to Date - Weekday comparison
Hello, I am trying to create a multiple series, period over period chart on a Month to date basis. I want to create a chart that shows Revenue and Jobs comparison on a weekday basis where this year vs previous year. For example a chart that shows October Month to date weekday comparison like Oct 1st 2020 is a Thursday and…
-
Radar handling of Nulls
Does anyone know how to not have a radar chart not connect across the axes that have null values? Trying to show active users as the metric and the axes be the months to look for annual seasonal trends. The current year connect the ring across the future months. Would prefer it be an incomplete ring.
-
Is it possible to add a hyperlink to an image in an HTML table?
Hi there, I'm trying to build an HTML card that has images with clickable links. I know that it's possible to add a clickable hyperlink to text in an HTML table, but is it possible to do so with an image as well? I tried: CONCAT( '<div><a href="CLICKABLE LINK"','"target="_blank">', '<img align="center" src="IMAGE ADDRESS"…
-
Is there a way to embed video in a card?
I want to be able to embed a video in a card inside domo. The catch is, I don't want to put the video on Youtube (which is how you would do it with the Illustrator app builder) because it has VERY sensitive customer information and the privacy settings in youtube will not work for this project. I'd like to be able to…
-
Can a Period over Period chart with no data in previous quarter display data in subsequent periods
I have a question about using a Period over Period chart. We have a field call Organizations comprised of all of our locations. If I filter on one of the locations to show the number of reports from previous quarter over 1 quarter ago from that and over 1 year ago and if that location does not show up when I filter on…
-
How to represent the data as line chart for 'Grouped Bar with Line Chart'?
The tutorial says 'Series data can be represented as lines or bars.'. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Grouped_Bar_with_Line_Chart I don't know how to configure this. In the tutorial, all the data are integers and some of them are represented as lines and the…
-
Create 'same' drill path for multiple cards
Does anyone know of a way to create drill paths for multiple cards formatted the same way? I have several cards with similar data (same column names) and would like to create a drill path table for all of them, but would prefer not to do it 20 times. Thoughts?
-
Specify Mean and Control Limits for Statistcal Process Control Chart
I am using the SPC chart card and would like to specify (not actively calculate) the control limits and average for our process. It doesn't make sense to automatically generate these based on the data set as that will hide mean and variance shifts in our process which is what we are using the chart to detect. We have…
-
Averages over 5, 10, 30 days
Hey Team, I am new to DOMO so I hope this may be something easier than i have figured out. I want to create a line(?) chart that counts the items in one column (with an associated date field) and then provides me a moving average of those counts over the past 5 days, 10 days, and 30 days. for example: over the past 30 days…
-
Merge two dates
Hi, Is it possible to merge two different date fields into one? I want to merge the Project_startdate and Project_upgradedate as one field. Below is an example: Project_startDate Project_upgradedate Projects 10/14/2020 10/14/202034 10/15/2020 10/20/2020 50 10/16/2020 60 10/17/2020 50 10/18/2020 50 10/19/2020 50 Thanks in…
-
Schedule monthly reports - what date range is selected?
Good afternoon, I'm setting up my first (!) scheduled report in Domo and have a few questions that Knowledge Base didn't cover: * If the data in the card I'm trying to schedule is displayed at the monthly level, and only displays the last complete month, the report should then also only display the last completed month,…
-
How to default a Pivot Card to a Collapsed View?
Hi all, I'm wondering if there's a capability to save a Pivot Card defaulted into its COLLAPSED form within a dashboard. The idea is to give the user the flexibility to expand out if need be in order to see the granularity within the data. Is this possible? I know I can collapse the rows but it won't "stay" there if I say…
-
Day over day data tracking alerts
I have set up a dataset in domo that updates in the morning. I am trying to create a dashboard and set up an alert to check if the data being brought in has a delta of not more or less than 40%. So I have set up a day over day chart but I am not sure how the aleert would have to be set up
-
How To Wire A Domo Card To Take You To Another Domo Page?
This Domopalooza 2019 video (≈ 4 min). Speaker states the he's wired a Domo card to take him to another page in Domo. I can see there is a hyperlink on the card when the mouse hovers over it. How can this be done? Is it simply a custom chart where the svg contains something like <a href = "..."> or is it some other type of…
-
Do word cloud cards have the capability to parse individual words from a phrase or sentence?
In my dataset, I have full sentences as commentary on a question and I would like the word cloud card to parse out each word in the comments and aggregate a count of most commonly cited words. Do word cloud cards have the capability to parse individual words from a phrase or sentence, aggregate and then provide a count? I…
-
Running Total Distinct over time
Hi! I have data for trainings/sessions that have been held over the last year, specifically who attended them. I would like to visualize how many more unique attendees we are having every session, on each internal team. When I do a distinct count of attendees over time (a running total line graph), it gives me the running…
-
Pareto based on the higher percentage
Hi All, i have data that is sorted by fault category (400+ categories) they are then sorted by the temperature (warm if greater than 24degC and cool if lower then 24degC) at the time of the fault. What i would like to do is create a pareto based on the higher percentage of warm than cool. Any ideas?
-
Can I make this type of scatter chart in Domo
Hello, I'm trying to use DOMO to mimic a chart used for tracking driver duty state over a 24 hour period. Basically at any time in the day, the driver may be in a different duty state (driving, sleeping, off duty, etc). These states are predefined. I want to be able to graph a line that represents which duty state the…
-
bucket courses by count of grade items, visualize count of courses in each bucket by department
I have a large data set with 29 columns and over a million rows. The rows are each grade item in a course. Courses with no grade items are listed as a single row with a null for the grade item. The data set also includes key details like instructor, semester, department, type of activity associated with the grade item, as…
-
Changing Font Color
Good Morning. Is it possible to change the font color of my table if a condition is met using a beast mode. I have something like this CASE When `BI_Weight` ='5' then CONCAT ('<div style="font-color:#A43724">', `ICR_NUMBER`, '</font>') else `ICR_NUMBER` end but I only get text. Any help would be appreciate it. Thanks
-
Difference in Time duration as Line graph
Hi, I am making a dashboard for a call center. They record things like hold time, call length...lots of time values that have nothing to do with dates. I am trying to chart the average call lengths by week for this year versus last year. I am not having any success finding a way to handle this on my own or in the DOJO. I…
-
Last Value Projection when Using Right and Left Value Scales
I have a chart that summarizes sales performance by month using a grouped vertical bar chart. The vertical bars represent units sold, sales dollars, and sales dollar margin. The margin is represented in dollars. My problem is this: If I only use the left scale, the regression projection for the current period (last value)…
-
Date range filter not working properly
Hi, I have a query on the date range filters in cards. I have a card and filtered date range to show last 12 months by month, and then if I just select the date range ‘this year, by month’, instead of reformatting the card to show those months only(inside the analyzer when I select This year, I am able to see this year…
-
Fill the space in a row for a domo card table
Hello, I wanted to replace my client name with their logo, and I did this by creating a separate domo card with the logo and creating a beast mode to replace the name with the image. CASE WHEN `CUSTOMER_NAME`= 'DELTA AIR LINES' THEN ('<img…
-
Replacind information with images
Hi, I am trying to replace the name of the client with their logo in my domo card table, but so far no luck. I tried a beast case calculation but to no avail. I also created a domo card with their image to see if that helped. Any help would be appreciated it. thanks
-
Anyone else? Dimensions, et al are not updating when changing data sources in analyzer
Yes, Auto preview is on - no dimensions, measures or calcs get updated when changing data source in Analyzer. Just started happening today 9/14. Cheers!
-
All cards on the dashboard should open up in a new tab.
I am having a dashboard and there are 30+ cards in that dashboard, what I want when we click on any of the card then that card will open in a separate tab. Thanks, Akish
-
show percent on period over period graph
I want to show the percentage of anonymous callers on a period over period bar graph but the %percent over time option in the bar label setting uses the total of the entire time periods (current quarter, prior quarter and prior year) in the denominator. I want the percentage of anonymous just for the quarter and one for…
-
Filter Chart Columns from Dashboard
Is there a way to filter what lines show up on a chart from the outside like you can date and other values?
-
I have a card that displays Total Tasks and Performance per Task (Minutes).
When I use Beast Mode to modify the Summary Number, the I receive an error "unable to load at this time". My Performance per Task (Minutes) Beast Mode due to TotalTaskTime is decimal. SUM(`TotalTaskTime`*60) My Minutes per Task Beast Mode which displays valid formula. CONCAT(SUM(SUM(`TotalTaskTime`*60)/`TotalTasks`)) An…