-
Counting or Grouping?
Hello, embarrassed to ask what's probably a fairly basic question… but hey, we're all new at some point, right? So here goes: I'm building an app for a department at my org to bring in event data from an external platform (API hurdle crossed✅). I would like to show a few cards for things like an event count per month, per…
-
Is there a way to remove cards en masse from my "Shared" page?
Is there a way to remove all the cards from my "Shared" page? I don't want to delete. Just want to get them out of "Shared".
-
How to pull data from a report within a website report
Hello, We pull pricing information from the USDA: https://mymarketnews.ams.usda.gov/public_data Previously, we used an advanced HTML connector and it was easy enough to just swap codes out in the path to pull the item I wanted information on - example below ONS was for pulling onion pricing. They have changed their website…
-
Is there a way I can see what dashboards a card is on from the card details page?
I am trying to do some auditing of what visualizations are being used from datasets as we are preparing to swap source data. I want to be able to easily see what dashboard a card is on without searching for the card in the admin section. Previously, I was able to click on the Move/Copy option and it listed what pages the…
-
Any ideas how to best visualize boolean data?
I have data where as checkboxes are used to describe an event - on the drill of the event - I am looking to represent visually if the check boxes were utilized… this is how the data is gathered on the collection form… any ideas out there? I would like to use the Checkbox selector chart type - but you cannot populate the…
-
Movable Dashboard Page Filters
Problem: Our community applies many page filters to dashboards, many of which have a general order they should be listed in. When these need to be rearranged or have a new field added in the list, you have to remove all the filters up to the point where the new filter is added to correct the list. This is very tedious…
-
Variance % formula not working correctly at Grand Total
What I am trying to do is look at Monthly Headcount Trend (Variance %) by Billable, Non-Billable and Total. My approach to identify change % is : (Current Month - Previous Month) / Previous Month. Since, it will be showing multiple months data in a tabular form, so I used the following formula for Variance % (SUM( CASE…
-
Convert to App feature not available in brick
I had an option earlier in Domo bricks to convert it to an app. However the feature is not available now. How can I get the feature back?
-
Is there a way to include a series in a period over period chart type?
I'm trying to include a series (basically different locations) of sales during this current quarter and graph compared to the same quarter one year ago. Using a period over period chart, I don't see any charts that allow for a series to include that 3rd metric broken down by location. Basically I want to include 3 columns.…
-
Automatic Daylight Savings Update
Every year, updating each connector by an hour due to daylight savings can be really daunting and frustrating. If this can be automated in Domo, it will make many of us happy.
-
Filter Formula - Current Date + 3 days
I am running some automated production reports through the Shopify connector. Part of the data set is tags on the different lines items, which includes the date selected for pickup. I need the formula to essentially look in the 'tags' column for the Current Date of the report + 3 days. I thought something like this would…
-
Assistance Needed for X-Hub-Signature Generation for Alert Webhook
We're currently working on authenticating Domo alert webhooks to trigger a pipeline in a third ETL tool and are having trouble matching the X-Hub-Signature from Domo with our computed signature. Specifically, we're unsure if we are implementing the correct algorithm for generating the signature. Does anyone have a good…
-
Syntax error?
Hello, I am trying to load a Oracle discover report into DOMO. The select statement works fine but when I add the statement below before the select statement I get a syntax error. Does anyone see a problem that needs to be changed? execute fnd_client_info.set_org_context (209);
-
Why is one of my dropdown filters not working on all cards
I have three dropdown filter cards, one of them is not working , the card value does not change when the filter is applied, however it worked when the filter is applied within the card.
-
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?
-
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
-
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…