-
Problem with SQL for WordCloud Chart
Hi all! So, I am trying to run SQL code using these instructions https://domohelp.domo.com/hc/en-us/articles/360042925094-Word-Cloud-Chart When I am at step 9 and trying to run this code CALL word_cloud('nuvaira_patientlogreport_recursive', '`Notes`' , 'y','y' ); It gives me an error 'Invalid. Whoops! Something went…
-
Removing sort symbol from graph
Is there any way to remove the sort symbol from view? It can be obstructive when looking at the axis numbers. I can't find anything in 'Chart Properties' to disable it.
-
Please I need help with setting up a retention chart
Hi Domo gurus. I'm trying to create a "line + grouped bar chart" similar to the ones attached below. My goal is to create a chart that shows monthly cohorts of users who have made '100 api calls" and showing x% who returned to make other 100 api calls at the interval: 31 - 60 days, 61 - 90days, 91 - 120days, 121 - 150days.…
-
Help with Quarter Beast Mode Please`
Hello Community, I have a beast mode that is working for my purposes when reporting on the fiscal quarter in total. What I need to do next is show in a bar chart each month in the current fiscal quarter and the calculated currency value for each month. This dataset is coming from Salesforce and is from the opportunity…
-
YOY & Net diff Beatmode calc
I have kind of a unique YOY period that I am trying to create a report around. I am taking counts of leads that come through different marketing 'Marketing Sources', and only looking at the past 15 day window for each. This is straight forward. Take the counts for each source in the `Marketing Source` columns and use the…
-
How to custom name data series in legend?
I'm looking to name each series its own custom label, take a look: So for example, I want to change the top label to "Point - Tree - Batch", the second label to "Point - Tree - Manual", the third to "Linear - Curb and gutter - Manual", and so on... a custom label for each of the eight series. Can anyone help? Thank you.
-
Sorting-Histogram Text
I have created a histogram chart with custom bins. The value is "text" and the sorting is off see below. How can I fix this?
-
Custom graphics for gauge charts?
Is there any way to customize gauge charts with a custom background, OR, better yet, with svg custom graphics for certain elements of the gauge (Like we can do with map charts)? I'd settle for a way to overlay a gauge on a custom background but right now it seems I can only customize a background to a color, not an…
-
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…
-
Default is reverse legend on a bar chart
I think it seems a bit odd that the default on a bar chart shows the legend upside down. I realize there is an option to reverse the legend order, but I don't know why the default is to have the legend upside down? My idea is for the legend to follow the same order as the bar chart and you can select to reverse them as…
-
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…
-
How to add last year's values to a waterfall graph? (YoY comparison)
Hi, I created a waterafall that shows the flow from opportunities to sales for 2019 and I would like to compare it to the year before. In my data, I have the 2019, 2018 and the difference between these 2 years, which I would like to add at the top or the bottom of the 2019 bar. Any experience/ideas on how to add this…
-
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…
-
Bulls eye charts
Hi team, Is there a way to create radial scatter charts to provide bulls eye view. We need to present various data in those charts? Is a coding required for this or a new extension of API? Please guide. That would be helpful. Thanks.…
-
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?