-
Best updating/appending method for sales records?
So I need to append new sales records every end of month. The sales records are stored as Excel Sheet with these columns: Order Date, Product ID, Customer ID, Sales Amount, Unit Price, Qty, Ship Date. So normally I would just go to the dataset → setting → upload new month dataset in → updating method: append Just wondering…
-
Filter does not work on all cards in an App
So I have Dataset A which contains 'Customer' and 'Account Number' columns, I created a Beast Mode 'id & customer name' = CONCAT('Account Number, ' ', 'Customer') then use that Beast Mode to create a selection drop down filter card called 'Customer'→ add that to an App I have a dataflow that is just an unpivot of the…
-
Collapse columns on pivot disapeared
Hello there, We used to have the option to collapse the columns on pivot tables card and disappeared. Does anybody knows if this is something released lately? All my users are complaining… Thanks
-
Customisable Line Type and Symbol in Line Chart
Would like to be able to assign a line type (including dashed) and symbol based on Series value - in the same way that we can set colour rules.
-
Can I suppress a column on a card
Hi, only been using Domo for a few days, but having an issue with a table. In this card I have exactly what I need, but would like to remove the Percent Total column. The beast mode filter applied is just a COUNT(AWV Status) which has "complete or either "Incomplete" so It is the same as just adding the AWV status again…
-
Drill Down card select option
Hello team! A lot of our Domo report users have been asking for an option that lets them choose the column (dimension) for drill down. Right now, in the example below, the user can drill down the report from Customer to Price Line, and then drill down from Price Line to Product. Our report audience would really appreciate…
-
Column With Custom Fields to Reference in Beast Mode?
I would like to generate a custom column from a list of strings that I can then use to reference in Beast Mode. I am basically trying to generate a view analogous to the one below in Domo. Obviously, one can simply input values into a cell in Excel, but I need a workaround to generate those values as a column so that I can…
-
Having ability to work on fields that needs to be extract from API
Having ability to chose the varible and filters on data fields that needs to be extract from API.
-
Beast Mode to Categorize the data based upon the pattern
Hello, Can anyone help me in writing this beast mode. Where I'm aiming to categorize these based on the status reversals from Yes to No. Case when current ready status is No and previous status is Yes then considered as reversal. Example like below: I already have first 3 columns in my data. Tried this beast mode but not…
-
Does Magic ETL v2 Have a Max Row Limit
Hello, I am in the process of combining two DataSets with Magic ETL where they have a same identifying Key. One of the DataSets has 3.9 million rows. When I use 'Join Data' between the two datasets, I end up with exactly 1,000,000 rows (when it should be in the 3 million range). I tried doing another Magic ETL where I only…
-
Hi, Is there a way to connect Google My Business to DOMO?
-
Smart Text as a Variable
At the card level it would be beneficial to know what the current operating environment is for a card and leverage that information in a beast mode. For example, if there were a "system variable" that stored what the current "Graph By" selection is, like what is already available in Smart Text, then you could have a beast…
-
How do I add a total to a column when I added a Beast Mode?
I added a Beast Mode so I would only get the Fee to list once since the Position ID is listed multiple times. I need to see each line so I can have a count on how many candidates per position. have I used - SUM(DISTINCT Fee). It works great, but how do I now get a total for the column? Raw Data This is the pivot.…
-
Automate Exports from Cards via SFTP
We have several use cases where we need to export report data that appears on cards in CSV or pipe-delimited formats and then deliver them to clients via SFTP or an AWS S3 bucket. It would be amazing if there were a way to do the following: 1) Schedule exports of the data that is typically emailed as a CSV and send it to…
-
SALT LAKE CITY CONNECTIONS TOUR CHECK IN
-
When clicking to filter, shouldn't the default be to INCLUDE the value???
Let's say I want to filter the page for the owner changes. Since the slices get small, I have to use the legend to do that. It excludes the values instead of filtering. For extra fun, it also makes the page filter 'In' all the other values! I am also providing an example, using a bar chart, since we would so clearly want…
-
Facebook Ads Advanced Custom Insights report > change in available unique metrics
On Oct 30th 2024, Facebook will make a change to the API that powers the Custom Insights report in the Facebook Ads Advanced connector (com.domo.connector.facebookads.) The change to the API will restrict the action_type breakdowns returned by the unique_actions and cost_per_unique_action_type fields to the following…
-
How can I create a beastmode that will return the desired substring in a field?
Hi all, I've given this multiple attempts and just can't seem to get it. I have a field called 'Destination' that I want to use in a Beastmode that will return the first substring of "B-FGI" or "FGI" in a value such as "Doe, John A-B-FGI-20.15.0003.B-FGI" or "Doe, John A-FGI-20.15.0003.B-FGI". I also want to create another…
-
Working with hh:mm:ss values
Hello everyone, I am relatively new to Domo but have built a few recursive data set, dashboards, and cards already and really enjoy the product. I am running into an issue however when trying to figure out how to best work with duration data that is formatted from the source system as hh:mm:ss. I have created beast mode…
-
PDP not enable but asking permission
I'm having some issues with a sql editor in the Views explore when I go to save it asks the pdp settings but the data set has it off. Even when I'm the owner it is asking permissions.
-
Can I introduce a new column on an existing data set? If so how?
I have an existing data set that I bring in weekly and I use the Append tile in ETL. I started about 3 months ago. 2 weeks ago I added a new column on the data set, but it is not an option when I am creating new card on my dashboard. How can I get this new column to show up?
-
Partition data from a historical date
I currently have an ETL that my team created yesterday, and it is partitioning data as of yesterday so there is currently 2 days of data in the data set. Is it possible to add historical data to a newly partitioned data set? Or is it possible to have the ETL partition off of a historical start date?
-
I have a chart which is populated yoy basis and has Q4 data being shown twice
Hi, I have a chart which is powered using a beast mode with a variable as following: (CASE WHEN (`Content Type ES Quarterly-2` = 'Project or Image') THEN AVG(`proj_image_insert_user_count`) WHEN (`Content Type ES Quarterly-2` = 'Project') THEN AVG(`customize_makeit_hva_user_count`) WHEN (`Content Type ES Quarterly-2` =…
-
Where to find Documentation?
Hi, I am trying to split a string and I cannot find which method to Use. Ive tried the substring_index method and the split_string Method and both have failed. I am trying to extract the city name out of a string that looks like this "CARROLLTON,TX/" Thank you
-
Can I know why the data is not grouping into single column in the pivot table?
-
Dynamic Variables should dynamically change formatting as well
Our company loves the beta of variables. We are able to create charts now where our users are able to change the dimensions and metrics they want on the fly. Our only problem is that we aren't able to dynamically change the format of that metric. So if our stakeholders select Business Area and they want to see the total…
-
Issue with Webhook Secret and Authentication Mechanism
I have configured a webhook for an alert and was able to pass a secret while setting it up. However, I am receiving the webhook API calls even without the secret being validated, and I am unable to see the secret anywhere in the request headers or body. Could you clarify where the secret is being passed, or if there's a…
-
Drill Down to an Existing Card
It would be excellent if you could choose an existing DOMO Card to use on the Drill Path screen as your Drill-in-Place Card. I have a specific Table Card that I use for almost everything as a Drill-in-Place bottom level card. Because i use it across cards types, datasets, and drill-path levels a simple "Save As" and…
-
Total Rows Should Export into Excel
When you export a table into Excel or use the Domo plug in, it will not bring the Total row with the rest. And simply adding a total row doesn't work for all tables. This should be doable. Thanks.
-
Amazon Product Reviews API