-
What are all the reserved words in creating a new dataset?
We are using the Stream API to create datasets. This is all dynamic so we have no idea what the data is going to be or what the columns in the source data are called. What we found is that if the source data has a column named 'row_number' the call to create a new stream dataset will fail but with no message or…
-
DDX: Getting Data in DDX form
Hi, I'm trying to bring in data in a DDX form, from a Domo dataset column using domo.get api using the following code. But I keep getting [object Promise] as a response. All I'm trying to do is getting the distinct value of column "Version" and populate in one of the DDX form input. The value in this column is same for all…
-
Building Data Mart inside Domo
Hi, Can we build Data mart inside Domo? Are there any challenges or limitations we need to consider?
-
Charting
I am new to Domo and busy learning Analyzer. I'd like to know how to convert a bar chart (with two variables) into a line chart with percentages, so if you have a column with 75 Male General Managers and 50 Female General Managers, another column with 100 Male Executives and 50 Female Executives, and a final column with 65…
-
Beast Mode
Hello All, I want to build a card comparing cy with py grouped by location. My plan is to use bar chart side by side comparing cy to py. My beast mode calculations seem correct when I create a table with them. When not comparing to PY, I just built a filter to include the dates i need, and it works fine but when comparing…
-
ARR Between Two Date Columns (Sub Start and End Dates)
I have three columns… Subscription Start Date Subscription End Date Subscription ARR Subscriptions are typically one year but not always. I want to chart ARR by month which is defined as the sum of all of the ARR for subscriptions active for each month. X-Axis = Months ←- Not sure how to do this because if I pick Sub Start…
-
In-Dashboard Navigation Options.
We have developed a pretty long dashboard that encompasses a large number of different components. As a result, our dashboard length is exhausting from a UX lens - especially if your area is closer to the bottom of the page. A card interaction or contents style card would be a fantastic addition to enable page navigation…
-
Set the default value of date type Variable to current date or today's date
A date type variable needs to have a functionality where the default value can be set to today's date
-
How do I get percent of total on pie chart?
How do I get the percent of total on a pie chart? I added pie name and pie value, then change the pie value format to a percent. Rather than giving me a percent of a total, it is giving me the percent. For example, one of my numbers is 799. When I change the format to a percent, I get 79,900%. What am I doing wrong?
-
Calculating MoM, YoY, YTD in table
Hi Domo users, I have been trying to figure out how to represent some values in a revenue table and hoping you can help. Here is what I have so far: As you can see above, I have something like this cable that I want to replicate in Domo. For the most part I can do this in a pivot table in Domo, however I am not sure how to…
-
Enable pfilters for Variables
While it's possible to use pfilters to pass parameters to cards and pages via URL, this does not seem to work with the Variables recently introduced, although visually they appear in the filter var when you apply them at the page level. This would allow a higher degree of control when creating links to navigate between…
-
Comparing YOY trend lines
I'm struggling with building a chart to show YOY trends. I was able to use a combination of the following beastmodes to create the following chart from a dataset containing a small amount of data. But when I attempt to do this with a large dataset, it doesn't work (I'm wondering if it just requires too much processing).…
-
Formatting Summary Number For A Calculation
Hello All, I'm struggling here as I feel like I'm so close. I'm trying to show a summary number that is a calculation (Cost/Leads) and while I've been able to figure out the font size and color, I am still struggling to control the format to be a currency without decimals instead of the number its at now Right now, I've…
-
Build ODS Layer Inside Domo
Can we build ODS (Operational Data Store) inside Domo for serving the use case of near real time reports (~ 6 mins latency) ?
-
Is it possible to achieve last 30, 60, 90 days from the current date
When I am trying to achieve last 30, 60, 90 days from the current date, it is displaying as (0- 30 days), (31-60 days) and (61-90 days) in the data when filtered, but the requirement was (0-30 days), (0-60 days) and (0-90 days). Calculation: For date range Iam using this calculation Date range: DATEDIFF(CURDATE(),(`Date`))…
-
dynamic date associating
I have a dataset that contains IDs and meta data to include modification dates. Each ID has a last modification date. However, each ID may (or may not) be associated with other IDs. I want to identify the latest modification date (direct or associated) for each ID. Below is an illustration of what it looks like, except…
-
Date Format change
I have a few columns which use the date format 01/Jan/2016, I need to convert these to 'Date' to use as date ranges in metrics. I have tried using the 'replace' text card in an ETL to change the forward slashes and months to numbers. This works on some rows but not all (trying to figure out why). Then I change the data…
-
Bryan Van Kampen Joins the Ranks as the Community's Newest Coach!
👨🎓 Graduating to coach status in the community forum is a monumental achievement! 🏆️ It is a sign of prestige and knowledge that few Domo users can claim to have. Which is why we all need to give @trafalger a massive round of applause for this impressive accomplishment! 👏👏👏 Bryan has been a long participating member of…
-
How to display inventory total value over the past 5 days
I'm looking to show how the total value of our inventory has changed over the past 5 days. Ideally it would be a bar graph showing the rise and fall of inventory value depending on what's been sold/purchased over the past week. I believe I have all the data I need in Domo, I just need to figure out how to create the card.
-
Comparing Datasets to Determine Variance
Hello everyone, I am working on comparing data from a previous data input, Universal Analytics, to a new one, Google Analytics 4. Basically, there was an update and data is formatted differently. I am attempting to join the two datasets to compare the month of A ugust for variances, but the closest thing to a unique column…
-
Properly Writing Back to Output?
Hey, first time Domo Jupyter user, and a new Python user. I'm having a difficult time exporting my data to a new dataset. From this: I keep encountering this error: /home/domo/.conda/lib/python3.9/site-packages/domojupyter/io.py:125: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future…
-
how do you calculate the age (in months) using the date of birthday?
how do you calculate the age (in months) using the date of birthday? Can I use this: ROUND(DATEDIFF(INFANT'S DETAILS:\nDate of Birth,CURRENT_DATE()) / 365,1)*12
-
Field Use Export
Is there a Governance connector or way to filter to a dataset and determine which columns are used in cards/beastmodes?
-
Group By feature at the card level
Having a "Group By" option available at the card level when we are in the Table type visualization would be of great help. Currently the grouping feature is only available on the dataset level which isnt easy, because there are times you dont want to group it on the data source level but only want to do it for a particular…
-
Python error - dict keys must be non-empty strings
ValueError: domomagic: Array dict keys must be non-empty strings I have tried the code on both the VS code and jupyter notebook its working on them. What might be the problems coz its giving me the above error.
-
Sorting Beast mode
Hello! I'm trying to sort my beast mode where I'm normalizing my data to trend performance by the first month it's published and trending for a year since all my rows of data will have different dates in which they are published. The issue I'm running into is I can't sort the beast mode in order of Month 1, Month 2, etc.…
-
Heatmap Hover Character Limit
Have a customer that is working with heatmaps and noticed that when he increased the characters in the hover the information disappeared. They wanted to know if there is a character limit that is inplace for the hover picture and if there is a path forward they should take to include more information. Thanks!
-
Add REGEX functions to Beast Mode
REGEX functions are currently supported in the MagicETL formula tiles, but not in beast mode. It would be helpful to have these added to Beast Mode.
-
Creating a variance column
Hi there, I am new to Domo and I have a question that I believe has an easy solution, however, I cannot figure it out. I have a table created to display Cost per load over the past three months. The formula for CPL is SUM(carrier pay)/ SUM(Loads). I want to have a column that displays the previous months CPL - Current…
-
Long Running Dataflow Alerting/Auto-Restart
We need to have the ability to understand when dataflows are running longer than the average duration. We would like to set user defined alert criteria based upon the dataflow's duration. For example: alert when dataflow has been running 15min, 1hr, etc. longer than the average for the dataflow. Having the functionality of…