-
How can I select a date range that shows Facebook data from all campaigns, regardless of start date?
Hi there What I would like to see: Data for all Facebook campaigns in my card, within a specific date range. I want to see data from all campaigns, regardless of their campaign start date What I am actually seeing: Data for only the Faceook campaigns in my card which have a start date within my specific range. Please help,…
-
Calendar Chart - NON-abbreviate Values
Hello all, This should be simple and straight forward but I can't find the setting/property I'm looking for. I currently have a calendar chart showing values in each day. However the values have been abbreviated by millions and I'd like to see the full value rather than the abbreviation. I don't see an option in the…
-
Grouped bar - Category as text and each bar (series) is a year
I need help making a grouped bar chart that shows each category as a text field (e.g. Aerospace, Automotive...) and each bar to be the value for the year. For example one group would show Aerospace revenue for 2018, 2019, 2020 the next group would show Automotive revenue for 2018, 2019, 2020. I am not having any luck…
-
Summary number displaying the wrong number
Hello, I'm trying to display the total number of conversions in the summary number. In the graph, it is displaying the correct number by day but when trying to display the total in the summary number is missing 6 conversions. Here is the beast mode used: COUNT(DISTINCT(CASE WHEN (`a.accepted_migration` =…
-
Order by Trellis after limit rows in bar chart
Hey there, My question is related to this request: https://dojo.domo.com/t5/Card-Building/Limiting-Pivot-Values/td-p/48031 which get a good solution from @jaeW_at_Onyx . But my further question is that I want to show the data in a bar chart instead of a mega table. I put the suppliers' name on the y-axis ( it is cal 2…
-
Remove hover values in Bar chart
Hi, I read that you can't remove hover values for the stacked bar, is it the same case for bar charts? Thank you!
-
Filtering Dates to Get the Last Access Date
Hello All, I have created a card with the following fields (see Table 1) and trying to edit it using the Beast mode. I am basically looking for help to filter rows the courses last access by a user with the number of days (Today’s Date - DayAccessed). Below is a user “John Doe” who accessed two courses on three different…
-
Graph with tags on dates
Have a simple line graph but I want to call out specific dates, that remain static, and what those dates meant. See example.
-
Blank column in Pivot table not displaying
Hi, I have a pivot table with 1 row and 2 columns which works fine except when 1 of the columns has a zero count for all rows it disappears. How can I force that column to display with zeroes? As you can see, the orange group has no "High" category column as the count is 0 - I want to show this. The count is a BM…
-
How to add parameter into Beast Mode
Hey there, I want to set a parameter and use this parameter in a beast mode. For example, I want to set a parameter with a sales volume range from 5 to 20. The customer could change this parameter to a specific value within this range. And then I want to create a beast mode showing that case when the sales volume >=…
-
Is it possible to pass custom parameters to a card and merge them into a report?
Let's say I had a report that had external links, but I wanted to pass in a custom parameter based on the viewer and built it into the link on the fly, is that possible? For example if I had my domo card showing a table and there was a column that linked out to an external site, but I wanted to pass a UTM code that I added…
-
Sales Revenue Ranking by dynamic date and limit pivot rows
Hello, I am trying to get a pivot table card in Domo and it could show sales revenue by different categories and reporting date. More importantly, I hope to rank the categories by total sales revenue within a specific time and the card could only show the top N categories' records. Within a different period of time, the…
-
Filter by multiple values/ filter by using a list of values
Hi All, I have a DOMO card which contains a very big number of records and each of these records have an email address. Let's say I have a list of 100 email addresses which I need to find in this card. So by using 'Show filters' button and selecting 'email' string, instead of writing email addresses one by one and…
-
Insert card while maintaining ratios
Maybe I am doing something wrong but when I already have a couple of cards and I insert an extra between them it takes up the existing space. Resulting in cards getting smaller. Only solution is to enlarge the cards from the bottom up so I can space it out. Which takes a lot of work and doesn't seem to be the right…
-
Heat Map Cohort Analysis Subtotals and Percentages
Hi Dojo, Can you guys explain to me how to transform this cohort heat map (attachment 1) to a heatmap with average percentage retention for each time period (months in my case) across the x axis and cohort totals in the beginning of each period across the y-axis (attachment 2)? It would be a lot easier just to add…
-
Barchart with a series of 2 different types (sorting issue)
Hi, I've build a bar chart where I can see sales by sales person. I have a beastmode variable that calculates sales and I dragged into the Y-Axis field and I put into the series field a product field that allows me to distinguish between food and drink items. Now I am trying to sort the bar by sales descending, but it only…
-
How do you apply color rules to subtotal rows in a chart?
I created a chart with color rules based on calculated fields, but my subtotal and grand total rows didn't change color. How do I get the color rules to apply to my subtotal and grand total rows as well?
-
Remove hover value that appear automatically (100% stacked bar)
Hi, I am using th 100% stacked bar. I selected some data label setting but did not select anythig under the hover text setting. When I hover over the chart, it shows me onscure values and I want to get rid of these. Any suggestions?
-
Can a report be scheduled to be sent out biweekly (every two weeks)?
In the reports scheduler, I have options for daily, weekly, and monthly. Is there a way to schedule a report to be sent every 14 days? I'm not seeing an option and can't think of a workaround. https://knowledge.domo.com/Engage/Sharing_Content_in_Domo/021Scheduling_Reports
-
HTML as an image in an html table
Hello, we are trying to report on performance of certain creatives within one of our ad serving platforms: flashtalking. Within Flashtalking they have a link which takes you to a preview of the advertisement, however the creative is not in an image format, just HTML: example…
-
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…