-
Show values in the donut chart
Hi, I am using the donut chart to display values, but somehow there is only the hover option working to show numbers of each section. Is there a way to see immediately how much each section makes up without have to hower over the chart?
-
Changing field names
Is there a way to change the naming of a field output. Our organization names are long and take up a lot of space on a chart. I would like to shorten the names so they appear cleaner on the chart. Can this be done in beast mode and can you give me an example. Example: Mount Carmel Health System change to MCHS I would need…
-
Box and Whisker Plot Not correct when aggregate
I'm doing a box and whisker plot for number of followers each user has grouped by clients - so my chart is catergory names = Client, Column containing dataset = total followers. When I filter for individual clientname, the low, median, high values are correct but when I don't filter for a specific client and try to show…
-
Color Rules Not Working on Scatter Plot
Hello, I'm trying to create a Scatter Plot with the X axis being % of Total Activated Users and the Y axis being % of Users following another User and the series is the Clientname. I'm trying to set the ColorRules so that clients who are "high risk" would appear as a Red dot on the chart and "satisfied" as green on the…
-
Monthly and weekly forecast view
So i have a dataset linked to a forecast file that contains weekly numbers as below when i graph it weekly i used sum distinct(forecast) for Y axis or else it would sum every line up or average it which is not right, how do i show it in a monthly view in the card filter without changing the Y axis?
-
market share over time with maximum slices
Hello, I'm trying to find a card or a way to build a card that shows me our market share over time and our main competitors market share over time (say top 6 competitors) and will group all the other smaller competitors into an "all other competitor category". The pie chart has a nice feature where you can pick your…
-
Graphing a [Case Statement + Window Function] calculated field
Hey everyone! I've run into an issue while attempting to create a card to graph a calculated field that involves a case statement and a window function but I'm not sure if my implementation is wrong or if this is a Domo limitation. I have a database that records the Employee's ID, Date, Hour of Availability (24H format)…
-
Filters & Drill Throughs - Is there another way?
I find myself in this pickle because of the nature of my data. I have employee data that is batched monthly. So each month has all people ever employed at the company(along with info such as hire date, termination date, position, department etc..). I've already done some manipulation in ETL so that when an employee is…
-
Nesting Bar Chart not showing totals after filter
Hello, I've created a nesting bar chart and it shows the totals when I have all the data selected, however when I try to filter down to a specific format, the totals go away even though there are markets and stations still in there. Any filtering removes a total and I would like totals implemented. Any advice?
-
Dynamic Text on Dashboard textbox?
Hello All, Trying to add some dynamic descriptive text to my dashboard and not sure if this is possible. I want to put the dynamic verbiage "increased" or "decreased" depending on the percent change of my metric of the given timeframe. Is it possible to display this sort of dynamic text as a summary number in a dashboard…
-
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