-
I have AWS ELB log files stored in S3 that I want to load into Domo
I have been unable to get the S3 Advanced connector to process the file. The connector has successfully connected to the correct bucket in S3. The logs are space-delimited text files that use double quotes around multi-word elements. The files do not contain headers. Since there are no headers, how do I name the columns in…
-
Image size doesn't reflect settings (table)
I am trying to set an icon in a table column that links to an outside site/page. The Beast Mode works as expected, but the table is not reflecting the style/height setting. The current version of the code is here: concat('<div><a href="https://xxxxxxxx.app.netsuite.com/app/common/entity/custjob.nl?id=',Customer Internal…
-
Compare against a specific date?
I have a dataset that aggregates data on a daily basis. I would like to compare the most recent value to the value on a specific date. Example: Date Value 1/1/24 400 1/2/24 403 1/3/24 410 …. 5/7/24 500 In my Multi Value card, I am using MAX of Date and Value to pull the value 500, then for comparison, I have the all the…
-
Scheduled Report - Excel Attachement
Allow scheduled reports to attach the data in excel format rather than csv. CSV files don't keep special characters in the data, so accented characters are messed up in the CSV.
-
Add Count Distinct to Column Aggregation options
For string values, the Aggregation options are currently No Aggregation and Count. Adding an option for 'Count Distinct' would be very helpful. Instead of having to write Beast Mode calculations.
-
Single Value Card - No numeric abbreviations
Is there a way to turn off abbreviations of numbers in Single Value card? I have a card that has the value of 1023. It shows as 1.02K (I have it set to 2 decimal places). I can't find anywhere to tell Domo not to use the abbreviation on this card. (ether in the card settings or the value display settings).
-
Adding data that matches a date to a date dimension table.
I have HR data that has Start Date and End Date (or null) for each employee. I am looking to be able to see the number of active employees at any given date. I have added the Domo Date Dimension table to my data set, but I can't figure out how to join so that for any date I can get the count of employees who's start date…
-
Year over year cumulative average
I am trying to create a line chart with the year as a series. The data points are per month with a cumulative average. Data: Year Month Closed Cases Total Cases % Cumulative % (Cum. Math) 2022 1 50 100 50% 50% (50/100) 2022 2 100 150 75% 60% (150/250) 2023 3 100 100 100% 71.43% (250/350) etc. across multiple years where…
-
Scheduled Report - CSV problem
I have a scheduled report that includes a CSV export with address info. The addresses contain accented characters. These are all great in Domo. When I export to CSV, these characters get screwed up. Is there an Excel export (exporting the card in Excel directly works correctly)? Is there another way to schedule sending…
-
MagicETL/SQL to join datasets using a comparison between values
I am trying to get a geolocation based on the IPNumber. Dataset a: ipaddress ipnumber (translated from ipaddress) Dataset b: lowIPNumber highIPNumber Country Region City I would like to add the Country, Region, and City values to an output dataset: ipaddress ipnumber Country Region City where a.ipnumber >= b.lowIPNumber…
-
REGEXP_REPLACE in ETL add new line?
I have data in Domo for an address that includes a new line character. This data was brought in from NetSuite in this format. I am trying to add additional data that matches this format. I have the following data: Ship Address: attn~company~addr1~addr2~city, state zip I would like it saved as such: attn company addr1 addr2…
-
LISTAGG or equivalent during data import from NetSuite
What SQL should I be using during an import to collapse data from a column into ',' delimited strings? when I use: listagg(item.NAME,',') "ITEM(S)", I get the error: [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Failed to retrieve data. Error ticket# l27jpdhw1857xj1xsmvi0[400] with just item.NAME…
-
Comparative gauge and filters?
I am trying to build a gauge that shows a % for the currently selected company value in comparison to the % for the community as a whole. The problem i run into is that as soon as I filter the card to the current company, I no longer have the entire community's data to compare against? I don't see any way to just filter…
-
Generate an Average ignoring duplicate rows
I am trying to generate an average value for a single value card, The data has duplicates of this value due to other data within the set. In the example below, I am looking for the average number of seconds per customer. I need to be able to dedupe Customer 1, then average the remaining rows. Can this be done with a Beast…
-
Is there a way to prevent a card in a story page from using the page filters?
I have a page that shows info about a customer, and I would like to show info about that customer in relation to another group of customers. For example: Filters: Customer = Bob and Industry = Retail With those filters both active I would only see data about Customer Bob. I would like to have 1 card that shows the average…
-
MagicETL2 Filter issue?
I have a filter in my dataflow: id NOT EQUAL value This filter removes all rows that have 'value', but it also seems to remove rows that have null in the 'id' field. Has anyone seen similar behavior in the Filter Rows ETL?
-
Is there a way to filter a card based on a sub-string in a text field?
I have a text field that is delimited by '|'. I would like a user to be able to use a quick filter that allows users to find a sub-string of the text field. Regions Covered Row1: North|South|East Row2: East|West Row3: West Row4: East|South I would like to be able to filter if a row contains 'East'. (Yes, I know I could do…
-
In a table card can I use a value to color code a cell?
Here is the example: I have a list of customers with 10 columns of data about the customer in a table. One of the columns is a boolean value (T/F). Instead of using a column to display that data, which takes a lot of horizontal space, I would like to have the customer name column change colors (ie: green background for…
-
Using an interaction as a filter on another story page?
I have a card on a page that gives high-level information about a set of customers in a table. When one of the customers is clicked in a table card, I would like Domo to open another story page and use the clicked customer as the value of the customer filter. When I change the interaction to open another story page, it…
-
Create a MagicETL function to Split Column and Dynamic Unpivot
I have a column that contains multiple values. I would like to be able to flatten these values. Ex: Document ID Author(s) 12 Bob^Sally 13 Bob 14 Fred^Ann^Sally I would want the output to be: Document ID Author(s) 12 Bob 12 Sally 13 Bob 14 Fred 14 Ann 15 Sally
