-
Graph Bar split by Quarter and by month
Hello, I am trying to split a table by Quarter and then show each month on that quarter, I was able to recreate it on Excel by using a pivot to split into quarter. If someone has come across this issue in the past I will appreciate some guidance. Chart that I want to replicate if possible I would also like to be nested to…
-
HTML Code shows with output values in filter or export of the card
Hello, I am trying to color cells in the card with HTML code. The issue is, if I filter or export the data for this card, all HTML code is showing up with the result. Is there any thing I need to add so that this code just works within beastmode? My code is CASE WHEN `column name` = 0 THEN concat('<div…
-
Summary Number Format in Notebook Card
Is there a way to remove the dotted lines on the Summary Number? Here's the sample result:
-
Pivot table issues
I don't know if I am running into a limitation with Domo, as I have about 500K rows. Trying to pivot on Area, State, Market (DMA). I get some of my data to break out correctly, but other data only posts in the totals and doesn't go into the state and Market rows correctly. If I select just one account, I get the data to…
-
Default landing page for group
I wasn't sure where to post this because there isn't a topic for administering site. I can easily filter my people on members of a particular group and assign a default landing page, but is there a way to set the default landing page for a group? Seems like a logical thing to have.
-
Beast Mode Calculation in Summary Number
My beast mode formula goes something like this:- SUM (x) / SUM (y) I am not able to use the above beast mode for my summary number. I am looking to get the average percentages, but the aggregation field is greyed out and I get the message "using aggregation in beast mode formula". Any help will be appreciated. Thank you
-
AND function is not working in the case statement for a single column values
Hi , I'm working with the Domo Governance dataflow, and I wanted to create a card which shows a message based on the successful update. I have 4 dataflow A,B,C,D. I wanted to see a message 'successful', if all the 4 dataflow has ran successfully today. Else it should should show a message 'Pending'. Here is my beast mode:…
-
Question related to case when formula in beast mode
Hi, I would like to ask about the beast mode formula related to this situation. I would like to get the data like this: If rating 'Superb' and 'Outstanding' are below 10 % then it's 'Below' If rating 'Superb' and 'Outstanding' are above 35% then it's 'Over' However, 'Superb' shouldn't be more than 5% What is the suitable…
-
Column Calculation in pivot table
I just build a pivot table with Year as column & dynamic filters ( so that column is dynamic ) Month as row Amount as values When I select year 2020 and 2018, the pivot table displays the values as expected. The question is, how do I add column calculation to show the variance between the two years selected ( assuming we…
-
Domo Everywhere- Embed Card- Change Background of card to black.
Hi guys, When I embed a card using Domo Everwhere, I would like to have a background color to be black. But by default I guess it is White. Is there a way we can change the background color of the card.?
-
Dynamic rank and filter lowest granularity - graph at aggregate level
We are so close to the solution we need! We are utilizing a Beast Mode to calculate the rank percentile of each row dynamically as other quick filters are applied (date, location, etc.). We are also using that rank percentile as a quick filter so the user can say: "give me the top X% of rows based on all the filters I have…
-
Filtering Pages and Sub pages in embed dashboard
Hi, I'm new to Domo, and I'm trying to do something that I do not know if its possible. I have a list of Reports created. These reports are in different 'buckets' i.e.: Facility ___Report 1 ___Report 2 Maintenance ___Report 3 ___Report 4 When the user clicks on Level 1 i.e Facility, it would populate a radio button list of…
-
plugin not downloading entire dataset
Whenever I download datasets using the domo excel plugin, the plugin doesn't download the entire dataset. Instead of downloading all 317k rows, it only downloads 50k. Has anyone else had this issue?
-
Displaying a single row on a card
I'm in the process of building a drill down report. At the bottom I'm looking for a single page of Column names and text. Ex: Order #: 8675-309 Customer: Jenny Order Date: 2021-04-07 Any help would be appreciated.
-
How to add percentage in the pivot table?
Hi, I'm new to Domo. Is there any way how to add a percentage in the pivot table? So, besides the total, I would also like to know the percentage of each category. Thank you.
-
Could we show the last run "date and time" of dataset on Dashboard?
I want to show to my team members and other users, When the dashboard is refreshed last time. Please suggest how I can do it?
-
Birthday calendar
Looking for a way to put team member's birthdays and anniversaries onto a calendar card for the team to see. Thanks in advance
-
Group by Month, sorting by Year with that month
I was able to get the following created in Domo, but it is not sorting my data correctly, as I want a stacked bar and then grouped by Month and then Year. So, I want January data from 2019 first, January 2021 second then February 2019, followed by February 2021 and so on. I am trying to mirror a setup from a co-worker on…
-
Is there a way to reference a segment in a BeastMode?
Is there any way to reference a Segment within a BeastMode formula? For example, I want to show the difference between a filtered total and the segment (which excludes filtering). Below is the BeastMode. Here is the segment definition: The Do Not Filter columns are part of our organization tree. We want to see the…
-
Aggregation by month with segmentation
Hi there. I am breaking my head about something that just feels so easy to get. Is there somebody who can help me out with this please? I want to show a bar chart grouped by month (please see example below). The bars then should be segmented into categories. The data is coming from the user activity in a tool. The idea is…
-
Progress Bar Gauge visuals
Is there any way to change the visuals of the Progress Bar Gauge? I want to display my data as a percentage but would like to use the visuals of the Filled Gauge rather than the Progress Bar Gauge. I attempted to create my card using the Filled Gauge option but it seems to only show whole numerical values rather than…
-
Period Over Period Nested Bar
Hey guys, I'm trying to create a week over week bar graph that shows the next 7 day production vs the last 7 day production. That is the easy part, I'm also trying to group the bars by our different locations. Below is an image of what I have so far. Is there an easy way to split up those total production amounts into our…
-
How to Create Monthly Averages for Headcount?
Hi All, I'm in the process of building an attrition model in Domo in the form: Total Terms / Average headcount Terms is easy, that's just a count of everyone with a term status for that time period. Headcount is where I'm getting stuck. My headcount numbers are currently aggregated based on headcount at the end of each…
-
Comparing two dataset outputs
I am trying to find a solution to compare output of two datasets. Both have same columns and same timeline but I want to create a flag if there is any difference in any of the col when we compare both outputs.
-
is there an easy way to not show zeroes??
I have a table that consists of inputs from 3 different sources. What I am running in to is more of an esthetics issue that I am hoping to clean up. I have areas where a zero appears, and other spots they don't appear. The data are all integers so i understand why there would be zeroes showing but confused why it shows up…
-
Is possible to use text values in a pivote table?
Hello! I am trying to create a table like this in which the values are a text field. I am using the pivote table that allows me to create the headers the way I want them but I think this type of chart only allows me to use numerical values. Is possible to use text values in a pivote table?
-
Division by Zero ETL error
Hello Can someone help me with this error... I am inputting a formula in Magic ETL and am receiving a division by zero error. How can I rectify it? I know in some cases the divisor in my calculation will be 0 but that is fine. An example of the 2 formulas I've tried below. Thanks for any insight. IFNULL(`Total…
-
refresh interval
Hello everyone, is there a way to set-up the card auto-refresh interval once the dataset has been updated, and which is the default one,? I'm experiencing refresh interval form seconds to minutes, so I'd like to have a more linear behaviour of the system. Also: using Domo Everywhere is there more flexibility about page…
-
Align headers to bottom
Is there a way to have the column headers positioned at the bottom of their cells?
-
Alert message for card is not supporting the card filter
Hi, I am facing an issue with the alert message. In the card, I have a filter for date, which is 2 day lag from current date. So that I wanted to get the alert by showing the data for 2 days lag. I have checked the option for filter in the alert rule part and even though when data gets updated, the alert is showing the…