-
Drilling between custom charts
Hello, I'm trying to make a tool using custom charts for our building, but I'm not sure about the feasibility of my design idea. Essentially, I'm trying to recreate the drill down process to Zip Code shown in this DOMO video: https://www.youtube.com/watch?v=UUZ_RvKX8O8&ab_channel=Domo, but instead using custom maps of our…
-
How do I preserve color in custom chart?
Since cell color options are lacking for pivot tables, I decided to use a custom chart. But when I upload my svg, all color information gets wiped. Is there a way to preserve it like the example that you have in your custom charts site for college campus map?…
-
Frequency Chart / Histogram
Hello, I have a range of Velocities (ft/s) and I am trying to show how many jobs we have performed within this range of velocities. I need to remove the decimal places and would like to round the numbers up. Is there a function to do that in beast mode or ETL? Then I would like to create a card that shows number of jobs…
-
How to hide target in Bullet Chart
I want to create a chart that displays the percentage of opportunities that have closed. I created a Beast Mode that displays a 1 if the Opp has closed and a 0 if it hasn't closed. I then threw it into a bullet chart, categorized by Lead Source. This is all well and good, but I don't want the target value to be visible…
-
Year over Year totals by month and sort
I am trying to create a bar chart that contains totals for 2 types of requests and their lines of business. This card will be a monthly card and would show a comparison of current year versus last year for that particular month. Example: y axis LOB A + Request Type A total for 2020 LOB A + Request Type A total for 2019…
-
How to add month over month and year over year column to data table
Is it possible to add percentage %change for current vs previous month in a column next to my current table data? My current data set is set out as shown below. Any help would be greatly appreciated! Domo analyzer view:
-
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…
-
Rearrange values on X axis
Hi, I am creating a view where I want to observe volumes base on a time of the day bucket. So have a variable: time_of_the day that I created using a timestamp variable. When I put the variable on the x axis, it starts with 10-11 AM first and and with the earliest value, 9-10 AM. I would like to organize the values in a…
-
Web Analytics Pathing Chart
Hello All! We use Domo as our digital anlaytics tool. I'd be interested in hearing from other customers who also use this tool for web analytics. More specifically if they have a possible solution for pathing questions. With the introduction of the sankey diagram I thought this would be the ideal chart for web page…
-
View last 2 weeks of data
Hello. I know there is an option to view Previous Week data. But how can I manage to display a week before the Previous, JUST AND ONLY the week prior. Example This week is 16 of the year Previous week was 15 Pior to that, it was 14 I want a chart to display only data for week 14, and ANOTHER chart to display only Previous…
-
Report on Column with Multiple Unique Values
We are looking to build cards on a field/column that has multiple values from JIRA and need to report on it into DOMO. Fi eld Information: Field contains associates names, and can contain anywhere from 0 to 20 people in this field for each row. This field can contain anyone from hundreds of end users we have today in the…
-
Change display of medium card on page to clip left side
Is there a way to change the way a medium card is displayed on a page so that it clips the left side of the data instead of the right? For instance, I have a Line chart with dates on the x-axis from a specific start date, 3/15/18, till now from left to right. As the date gets further from 3/15/18 the x-axis gets longer and…
-
How to change the data labels in the legend and chart
I don't want the percent values on my pie chart and legend to have any decimals. In "General" I changed the Value Decimal Places and Percent Value Decimal Places to "None" but that only changed the hover labels. Is there a way to change the auto-generated percentages to only display whole numbers?
-
How to create a backlog trend card?
I'm trying to create a card that shows the trend of case completion against a backlog each month (based on open/close dates). Ideally, it would be a multi-line chart with 'month-yr' on the X-axis and COUNT of cases on the Y-axis, for the following series: * New = COUNT of cases opened during month * Closed = COUNT of cases…
-
Aligning zeros on both y axis
Hi, I'm wondering if there is a way to align both y axis (primary and secondary) on a combined bar and line or symbol graph, so the zero line (x axis) intercepts both at the same time. In other words, how can the zero in the primary y axis be right in front of the secondary y axis? As a workaround, I can manually set the…
-
Multiple data labels on a card
Hello, Is it possible to show multiple data labels from macros on a chart, such as in the attached image?
-
Remove secondary axis
I have set up a line + stacked bar card on a dataset in which all data is on the same scale. By default the line was placed on a secondary axis, but I would like the line and the bars to all show on the same axis. How can I remove the secondary axis? Thanks
-
Comparing 2 Points on a Line Chart
Is there a way to easily compare the data behind 2 points of a line chart? When clicking on any point of a line chart I get the tabular data for that point. To see the differences in data of 2 points on the same line I have to click on each one independently and export the tables to then compare the data using the created…
-
Calculating Beast Mode YoY and MoM Type Calculation
Hi all, I want to calculate a YoY or MoM calculation for each month in which data is available for such comparisons. I would then like to possibly create a chart showing the trend of my YoY and MoM % changes. The Example data looks like this and I would like to calculate a column of YoY and MoM and trend it:…
-
Pie Chart Sorting?
I have a set of categories that I would like to display in a specific order in a pie chart, but no matter what I do the pie slices are always ordered by biggest slice to smallest slice. I have tried writing a variety of beast mode sort calculations to address this but nothing happens when I apply the sort. Am I missing…
-
Altering how a card/chart is displayed in a Group/Collection
Hi. I'm new to Domo and I was wondering, is any way to alter the graph that is displayed on the card when I view the group/collection? For instance, the attached graph is so scrunched and tiny that you can't get any value at a glance for a dashboard type of experience. So I was hoping that I could alter the "thumbnail" in…
-
Pie Charts - Can I force categories to display when the value is 0?
Hi all. I am having an issue with a pie chart. When I am looking at company wide data, I can assign a color to each series in a way that makes sense. However, when I filter into a specific area or sales rep, The colors do not make sense anymore. Is there a way to force a pie chart to display a series even when there is no…
-
Making 2 lines as symbols and rest as lines in a line chart.
I want to make my total and plan as symbols, while the rest of the products are shown by lines in a line chart. As of now, all the lines turn into symbols or lines. Is this possible?
-
How do you group sources within a pie chart?
I have a pie chart that contains 3 sources that are all named "Web Order". Even though they are technically different orders, I would like to just group them all together. I've provided a screenshot below. Thanks.
-
Funnel Card using Column Aggregates?
Hi, as the title sugests, I am having trouble creating a beast mode that I can use to funnel the totals of several different columns.What I would like to do is create a funnel for marketing emails, columns are 'email delivered', 'email opened', 'email clicked', and 'email bounced'. Each row in the dataset is an email…