-
Subtracting a "COUNT" result from a given value
I'm assuming I have this completely wrong. 1344 - COUNT(`Room/Row Id`) is what i'm trying to do. 1344 represents the total spaces available in a cooler unit. the COUNT equation is how many spaces are currently filled. The underlying math here is 1344-764=580, however i'm getting a result of 12,676.
-
How to write a function that returns positive if function contains values from another column?
The title is a little confusing, but basically I want to write a function like this: CASE WHEN `Track Split` LIKE '%AZ%' THEN 'AZ' end EXCEPT, instead of basing it off of a string, I want it to pull values from another column. I have a lot of changing data from row to row, so I want the row to check to see if the data…
-
I'm facing 'An IO error occurred' in the input dataset step, what does that error means?
-
How do I create a matrix from two unique lists in magic ETL?
How do I create a matrix as shown in the "Result" image based on the two input lists provided (zeros filled in the field)? I am trying to do this in Magic ETL. Thanks in advance! Gregory
-
Choosing the right chart
Hi! I'm working on charting data and want to understand if there's a simple way to find the correct Chart object to meet the needs of the requestor. The requirement is to have 3 data points show up as lines and 3 show up as bars. I'm struggling to find the correct Chart type that will accommodate the request. Any…
-
Add Chart Type as a new field in the "Cards" report of the Domo Governance datasets connector..
It would be helpful to have an additional field in this dataset to define the "chart type" that was picked in the Analyzer when a domo card was created. I have a requirement where I need to know whether a card uses a table, bar, slicer…etc. type of chart. Note: this is different than the existing field in that dataset…
-
MySQL
For this question: Join together two DataSets with MySQL using the name, year, and gender columns and include appropriate indexing. Not sure what to index here, is there any additional resources around indexing? The course doesn't go over it explicitly and this link doesn't either:…
-
Governance
governance question - Is there a way to pull the total number of unique KPIs or metrics within our instance and how often they get viewed? We are trying to put together a high-level usage presentation together that shows how many unique metrics are being viewed by how many folks on a weekly or monthly basis for example.
-
Excel Export Noitce/Warning
When a user goes to export a table type card, it would be helpful if there was a notice or warning when selecting the excel option informing the user that there is a ~1 million cell export limitation and to consider using CSV. This limitation is not found in the card detail view and may be missed by users. By adding the…
-
How to Unpivot or Explode Variable-Length Lists in Domo to Flatten a Table?
Hi Domo community, I have a dataset in Domo where the number of postcodes in a cell can vary. Here's an example of my input data: Network State Postcode A VIC 3000, 3001, 3002 B NSW 3011, 3021, 3001, 3004, 3012 I need to transform it into the following format: Network State Postcode A VIC 3000 A VIC 3001 A VIC 3002 B NSW…
-
Comparison of Tasks Submitted vs Tasks Completed
I have a table which tracks tasks from submission to completion. I have made a card to show tasks submitted per month and one for tasks completed per month. I would like to have a single card with grouped bars to show these compared against each other however the bars always seem to end up the same size as if it's only…
-
Domo comparison with ETL Tools
Does Domo has all capabilities which modern ETL tools like Azure Data Factory, Apache Airflow, Informatica etc.
-
Beastmode Case Statement with NOT IN operator
-
Dynamic Currency Symbol Formatting
Currently in Analyzer, number columns can be formatted as currency, allowing you to append one of 4 currency symbols to the beginning of the number in the chart. It would be incredibly useful to add a dynamic currency column option. Rather than having to select 1 currency symbol for the whole column, you could select…
-
Paging in a Table Card
Hi there, I was reading a closed forum question that suggested an answer that may no longer be true at this date. Original Question: I have a Mega Table with about 600 rows. I don't want to show all 600 at the Dashboard level, even with the scrolling aspect. I'm concerned that it will affect the Dashboard Performance. The…
-
Pivot table, unable to hide months with no value.
I would like to list all the month actuals first, then month's budget numbers, etc.. (ie. Jan actuals, Feb, Actuals, March Actuals. then Jan Budget, Feb Budget, etc.) Unfortunately I do not see a way to do this without creating a separate column for each of the months. This solution however does not allow me to hide…
-
LEAD IGNORE NULL in Magic ETL?
Hi there, I am trying to rewrite a Redshift Dataflow into Magic ETL. I ran across a specific function that was available in Redshift that I dont think is possible in Magic ETL. I wanted to get the community's input and advice to see what you guys think. This is the function found in Redshift: LEAD(CASE WHEN t2."channel"…
-
locks = locks?
Hi all, (I recently posted something similar but updated my dataflow to a new output so wanted to share and clarify) I've got two columns, rate_locks_powerlender and rate_locks_powerseller, that I need make sure are equal to each other. The power lender is slower to update so we do not have data later than 9/11 so I am…
-
Allow 'Rotate Labels' on the category X axis of a TRELLIS chart
Currently, this function does not work on a bar trellis chart which makes it so tough to read the labels:
-
True/False Beast Mode Syntax
Hi All, I am currently working with two joined datasets. Each dataset has a date for each row that gets added. I have outer joined those datasets and am now trying to make sure that the number of date entries are the same in each data set. I can visually tell that they are the same but I am trying to write a beast mode to…
-
JSON No Code Connector Pagination
When using Pagination "Offset by pages" it allows to to set my limit, page and start at page 0. The endpoint returns the data and shows up fine in the Data details section. When running I see requests that keep incrementing the page and eventually we return no records when the paging gets out of bounds for that endpoint.…
-
How to reference a Beast Mode in antother Beast Mode
I've seen this in Ideas Exchange, and it sounds like it's coming, but it's not here yet? What's my alternative for now? In my database, I have an attribute that contains values from 1 to 10. I need to invert these in Domo, and I have a simple beast mode which does that (1=10, 2=9, 3=8, etc.). I now need to reference that…
-
Group By
Anyone knows of a way to GROUP BY in Beast Mode Editor? we can do PARTITIONING but somehow, we can't do GROUP BY? For example: case when 'location'='ATL' then sum((amount)*10) else sum(amount) over (partition by 'Location') end the above works perfect BUT below doesn't. what am I doing wrong here? case when…
-
Connector to Monday.com?
Hi Everyone, has anyone connected to Monday.com? If so, how?
-
Allow an opt-in feature for the "Other" bar's truncation
Currently, when you select a Maximum Bars value in a bar chart, an 'Other' bar appears and it often appears truncated as shown in this article: It would be better to have the option of truncating it or not. Even better, show the break in the bar like this:
-
GROUP BY
Anyone knows of a way to GROUP BY in Beast Mode Editor? we can do PARTITIONING but somehow, we can't do GROUP BY? For example: case when 'location'='ATL' then sum((amount)*10) else sum(amount) over (partition by 'Location') end the above works perfect BUT below doesn't. what am I doing wrong here? case when…
-
How to subtract sales tax from certain rows for sales revenue dashboard?
I'm not sure of the best way to go about solving this, so I'll do my best to describe my issue below. Any assistance would be appreciated. I'm trying to create a pie chart showing total sales YTD and breaking it down by rep. I have it mostly made but my numbers are a little high. I looked at my dataset and my TotalPrice…
-
Default Setting to Pin Dashboards Side Panel for All Users?
It's not entirely intuitive that it exists for new users, so I'd like it pinned by default for all users. If this is possible, could someone direct me to the setting for it please?
-
How to use value from beast mode as a value for all?
Hi, I am trying to figure out how to best solve my issue. I currently have a calculation in my dataflow attached to a certain account code for our organization. That value changes daily but I need to use that value to divide the rest of our account codes by so I can't just add a constant value. Because it is attached to…
-
Projected monthly total based on current progress in current month
Is there a way to project the month-end value based on the current month's progress in a bar chart? So if there are 10 days of data totaling 1M widgets during September (9/1-10), it will project 3M widgets for the current month (1M will be solid and 2M will be striped to signify striped). I see a whole bunch of options in…