-
How to Filter for "Today AND Last 7 Days" in Domo Visualizer?
Hi everyone, I’m trying to implement a date range in Domo (using `Reservation Start Date`) that includes both Today AND the Last 7 Days at the same time. This will be for a weekly scheduled send. I know Domo has built-in filters for "Last 7 Days" and "Today," but I can't find a way to combine them in a single filter within…
-
Domo create react app not populating with the Domo specific scripts.
New to web development with Domo, I've ran domo login and that was successful, but when running npm create react-app todo-app @domoinc like it says in the documentation it just creates a basic version of react without any of the Domo specific scripts like upload. Is there something that I could be missing?
-
Hubspot Writeback error
Hello! I'm trying to set up my first dataset via the Hubspot Writeback and I'm running into the following error after adding the dataset ID. My dataset I'm using is a dataflow from magic ETL that is joining the Hubspot data (containing company ID, etc) with some other data in Domo. Any help to get past this is appreciated.…
-
Creating a card alert on card powered by Dataset View
Can you not create an alert on a card built from a dataset view???
-
Magic ETL Question: Rank and Window and Filter
Hi, I’m trying to retrieve the current major for each student. Specifically, I need to select the ACAD_PLAN that ends with "BS" (for example: "BUSMBS"). Once I have those, I need to find the most recent EFFDT (effective date) that is less than or equal to today’s date, because I want to exclude any future majors.…
-
shareCardWithPerson [Invalid type: expected NUMBER. (Expected non-null value)]
POSTMAN: ACCESS_TOKEN obtained: POST: https://api.domo.com/oauth/token data = { "grant_type": "client_credentials", "scope": "data" # "data dashboard workflow user" }, auth = {CLIENT_ID,CLIENT_SECRET} CodeEngine Called: POST: url:…
-
Publish a dashboard or app as a draft with collaborative reviewing features
Publish a dashboard or app as a draft and include some features before it's launched as a live page. Similar to a type of certification, but specifically around an entire dashboard/app collaborative building experience. Annotations on various elements of the page - headers, sections, clicking on a card and adding a note to…
-
Date Key in Datasets
It would be great if dataset developers had the ability to tag a column in the dataset as a "date key". In theory downstream when building cards, anytime a user creates a new card, Domo would default to adding this tagged column as the date field. I feel this would save card builders an infinite amount of time not having…
-
Card direct impact
It would be helpful to have another level of information before deleting cards which showed the cards direct impact. Our team recently learned the hard way that when viewing cards used from a dataset, it does not show if a card is only located on someone's Overview page. So, when you look at the card information it appears…
-
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
-
Allow differential shading between multiple sub-total fields in Pivot Table
Domo allows multiple sub-totals in Pivot tables depending on how many dimensions are thrown in. In my example, I have Daily, Weekly, Monthly, and Overall, where Daily is the lowest granularity, Overall is the Total, and thus Weekly and Monthly are both sub-total fields. Monthly is a higher level than weekly, but the…
-
Is there a DOMOStat that shows what users have access to what Pages/apps?
Hi, I am wondering if there is a domostat connector that shows what users have access to what pages/apps? Thanks!
-
Using Partition by with Count
Hi, I have this beastmode that is taking the % of people over $1000 in revenue and dividing it by the total # of people. It behaves correctly when I have only one terminal selected, however it shoots up to 350% when no terminal is selected. What is causing this? I tried removing the Partition by in the count distinct but…
-
Quick toggle to exclude "Today"
In a report set for "last 7 days", Domo will automatically include the current date if your dataset has rows representing that date. I have many datasets with rows for the future, where the data isn't filled in yet. In order to get today's date to be suppressed in the report, I have to write a Beast Mode: case when `Date…
-
Domopalooza announces SHAQUILLE O'NEAL!
You can't spell Shaquille O'Neal without 'AI', and you can't host THE AI + Data Conference without Shaquille O'Neal! He's shattered backboards, won three NBA Finals MVPs en route to four championships, made a second career as a TV commercial legend, donated countless hours and $$ as a philanthropist, and won everyone's…
-
How to link Microsoft teams to workflows
-
JSON Connector - File without extension
Hi everyone, I need to connect with a EndPoint that has an specific Id, domina,, viewId and apikey. I have tried out many Json connector without any luck Is there any specific connector that I can use considering the following parameters? EndPoint id domain viewId apiKey
-
Switch Order of Period over Period Chart
I'm afraid the answer is no - but is it possible to switch the order of a Period over Period Chart? I want "Year to date" on the far left, followed by 1 year ago, 2 years ago, 3 years ago.
-
Add Distinct Count to Summary Number
It would be nice if Count Distinct was an option in the Summary Number aggregation options to quickly show a distinct count. Right now, I have to create a beast mode for this number to show up in the Summary Number choices. It would be a nice timesaver if it was a built in aggregation choice.
-
sendEmail Function via API
Hi Team. I'm using this method: With the below details from postman (replaced inputs{} for this question) ``` POST https://{company}.domo.com/api/codeengine/v2/packages/{package_id_found_in_url}/versions/{version_integers}/functions/sendEmail Authorization: Token (generated via Admin > Access Tokens) body (JSON) {…
-
Rank by Sum of Style then Compare Rank to total
Hi, I have transactional data over periods of time. Data includes dates and time periods as well as SKUs and Net sales. I want to be able to dynamically rank SKUs based on net sales to create a top 10 group and then compare that group to the total sales for the category. Trying this but I don't want the SKUs in my report…
-
How to resolve CORS error while using Product API's?
{ "method": "POST", "url": "https://my-instance.domo.com/api/ai/v1/text/generation", "headers": { "X-DOMO-Developer-Token": "generated from Admin>Auth..>access token", "Content-Type": "application/json" }, "body": { "input": "why is sky blue?" } } Above is the request I sent but getting CORS error like below Access to…
-
New ETL Tile
It would be great to see an etl tile which can be placed before outputs of ETL which give the option to set different update frequencies for different outputs of the same ETLs.
-
How do I avoid decimals from being truncated while bringing data from Excel?
I have an Excel that has several measures that are percentages. The Excel is in a Box folder, so I am using the Box connector to bring the data to a Domo dataset. Everything works fine, except that the percentages get converted to decimal numbers (so, all are <1) and truncated to 2 decimals... so that is causing me issues…
-
Is there a creative way to adjust the decimal places on a progress bar?
I have this progress bar that is showing two places past the decimal. There are no chart properties to allow for adjusting this. Is there a beast mode or some other method I could use to get this to round?
-
Extract multiple sets of numbers from a single string
I am trying to extract two different sets of numbers from a string. I have tried substring and Regexp, but to no avail. Examples of the stringss- Possible string format #1 Company Name - 2024-07-01-2024-07-31 - GPPC - YTUBE - VYT - 63784 - 2782837 - 458573682 - [745-000121-003] Possible string format #2 Company Name -…
-
Beastmode to flag an item if the date is longer than a week from the current date.
Hello, I am trying to write a beastmode to 'FLAG' and item if the submission date is longer than a week from the current date. How would I proceed? See below for my current beastmode that flags something if it does not fall into the current week of the current date. My thought process is if the date is longer than the…
-
How do I make a Domo to Power BI Connection with Microsoft Authentication or Okta SSO and not ROPC?
Using the connector on the left requires an ROPC verification type which asks for the users Password. Our security requires that we work through a redirect with SSO and a token is passed back so passwords are only entered in one area. I believe the MSAL connector on the right should fill that criteria but it is still…
-
Managed attribute can't be edited or deleted
I'm getting "Attribute definition failed to be deleted" when trying to delete a managed attribute and an unspecified Error when trying to edit it. I can get to the edit modal, but it throws the error when I try to save my changes. This attribute was previously used in two PDPs, but I've now deleted the PDPs. In the…
-
Efficient Way to Rollover Filters with New Month
I have a dashboard with monthly volumes by service line. In order to only show the prior month that is closed, I manually set a filter to the prior month. Instead of going through each card and updating this filter manually to the next month (current state), is there a way to automate this rollover? Or perhaps have a…