-
Previous day status from snapshot data
I have snapshot data everyday that has customers and their statuses. I want to create a formula that looks back one day and reports the status (previous day status) How would I do that in Magic ETL?
-
Hey can anyone help me in regards for creating a custom connector using OAuth for authentication
Hey, I hope you are good. I need some guidance because the built-in connector is not getting the access token from the code it receives from the auth URL. I am inputting the right Token URL but still, for some reason, it is not working for me at all. It just gets the code and gets stuck there. I do not see any example that…
-
How to create a collection for form input data through form & dataset brick when embedded publicly.
How to create a collection to store form input data through form & dataset brick when embedded publicly? Currently my collection is only storing the data entered locally.
-
Move Dashboards for Non-Admins
The location of a dashboard can be an essential part of the appearance and structure within a DOMO instance. However, as we know, the original location a dashboard is created may or may not be the best location; or the best location for that dashboard may change with your organisation's structure. Admins are able to move…
-
How can I use Domo for Email Marketing
@DanHendriksen
-
Month filter not working on all cards in an App?
I have 2 card visuals for my app right now. Card #1use dataset 1 (have a month and a year column). Card #2 use dataset 2 (which has a date column, formatted as 'yyyy-mm-dd' And so my goal is to select a Month (say August), and both card #1 and #2 would show the data only for August. But if I create a "Dropdown Selector"…
-
Create Microsoft SQL server connector to Azure SQL Server - Firewall Issue
I am not able to connect to my Azure SQL server. I guess it could firewall prevent. How can I verify domo on my azure site?
-
Custom Names for Styles in App Studio
With the crazy awesome ability to manipulate various area of a specific style in App Studio, I think it would be super helpful to be able to rename styles (instead of seeing Style 1, Style 2, etc.) to keep styles organized and be able to quickly reference a specific style across several pages in an App!
-
Calculating period over period change in Domo
I've been trying to find a solution for easily calculating percent change of metrics between two periods and put them in a table. Like "What is the percent change for "costs" between this month, and last month?" Normally this is easy to calculate outside of Domo using the standard formula: (V2 - V1) / V1) *100 However,…
-
Aggregate (SUM) the results of Lead Function Beast mode at Card Level
I have a dataset wherein I have to count the number of cases which falls in the below filter and conditions. CASE -- Check if the current row is 'Ringing' and lasted 11 seconds or less WHEN STATE = 'Ringing' AND TIME_TO_SEC(AGENT STATE TIME) <= 11 AND LEAD(STATE) OVER (PARTITION BY AGENT NAME ORDER BY DATE, AGENT NAME) =…
-
Can we schedule a PDF or a Powerpoint?
I know that we can schedule reports in Domo, that come in the form an email with images in the email. However, does anyone know if we can schedule PDF or Powerpoints? Like PPTs or PDFs attached to a scheduled email via domo Thanks!
-
DV 360 Connection Error
Hi everyone, I am trying to connect with DV 360 and facing the below error. Is there any steps that needs to be done in Google Console? If yes, please help me with the steps. Thank you.
-
Changing color/styles for table values
Im trying to write a beast mode that will change the value to a Bolded colored text when meeting a certain condition. As a test I wanted to try to just get the bold color to apply without condition but for the whole column. I have found Domo articles and forum posts about this but nothing works. To verify this, I added my…
-
What is the credit cost associated with a Federated Dataset
So if I am using federated data from Snowflake what would be the credit consumption for the same considering I am in consumption model.
-
Ability to share filter view with a specific person and not to everyone
Give the capacity to share filter view to a specific person / group. Today, either we have the option to not share it at all or to share it with everyone. It creates useless noise for users. Having the capacity to share filter to only the needed users, would help the user experience.
-
Create a "Latest Available Date" selection for page level and card level filters.
I know I can do a max (`datefield`) over () in a beastmode, but this only works for card level filtering and not page level filtering due to the fact that this is an aggregation beast mode. For the page level, it requires a rank and window in a dataflow. Both of these work arounds break any smart text that would refer to…
-
Dropdown Selector: always have pre-selected the latest date on a filter card.
Hi, I have a filter card (dropdown selector) to display all dates available and I would like to have pre-selected the latest date. Is this possible? Right now I added it by manually typing the latest month but I'd like it to switch automatically when the month ends. Any ideas are welcome! Thanks
-
Better table design
The possibility to customize a table. Modify the thickness of the lines, modify the color or size of only one cell, show only one subtotal / total and not all, change values manually within the table, etc.
-
'Prevent drilling to final data grid view' manage at dashboard level
Rather than having to open and edit each card's drill path manually, it would be very convenient to have a setting at the dashboard level to prevent drilling to the final data grid view on all cards on a dashboard.
-
Amazon Advertising Connector: Entities report deprecation
Amazon has announced that the endpoints that power the Entities report in the Amazon Advertising connector will be shut off on Oct 15th 2024. As a result, customers who currently use the Entities report will need to switch to the Exports report instead before Oct 15th 2024. The Exports report supports the same entities as…
-
Workflow Triggers Using Activity Log Events
Hi All, Right now workflows can only be triggered via scheduling, an alert or via API. It would be EXTREMELY useful if Workflows could be automatically triggered based on events I can select from the activity log. I have a need to validate an end-users PDP as soon as someone logs in. Running a workflow at timed intervals…
-
BeastMode code to take one value from each category
This question is going to be really difficult to describe, but I will try anyway. I am trying to get a unit count for each facility, the problem is that bc we filter by time and different facilities can gain units over time, I can not just have one row per facility, I have a row for each month. That being said I need it to…
-
Same week last year
Hi, what is the best way to write a beast mode that returns the same week last year, e.g. 09/09/2024 ⇒ 11/09/2023
-
Default Values on Filter Cards
It would be a huge QOL improvement for our company if filter cards could have a default value selected (the most recent date, the first value in ascending order, all values that equal a specific string, etc.) because many of our dashboards need to have a single filter value selected to display accurate data. For example,…
-
Show Top 10 in Chart (Rank in Beast Mode)
Hi, I am trying to build a multiline chart based on the following Dimension: Date (x-axis), Search query (line series) Metrics: impressions and position The multiline chart should show the position (y-axis) by date for only the top 10 search queries based on the total impressions during a the selected time period. I cannot…
-
forcing x-axis in bar chart to ignore filters
Hi all I have 30-40,000 rows of data presented to a bar chart with 5 dashboard filters operating across the data. There are 15 different categories presented as the x-axis. Occassionaly filtering removes one of these categories. I'm trying to find a way to leave the category on the x-axis despite the fact that it is no…
-
Possible to use a value that ignores filters?
I'm looking for a way to use a value in a beast mode formula that ignores my current filters. I've been wrapping my head around this problem and can't think of another way to solve it. Here is an example with my issue: Let's say my company has 5000 employees. There is a survey database with multiple rows of data for each…
-
CSV SFTP Advance Pull Connector public key
While I was setting you this connect I was given a public key. Am I supposed to save that in the SFTP client server? Thanks
-
Self-Published Redirect URL Issues
I'm trying to build a connector that uses OAuth 2.0. Within the connector IDE it works without issue. When I self-published a beta version of the connector, I was provided with a new Redirect URL to add to my app. When I try to use the self-published version of my connector, I get the following error message: { "status":…
-
ConsolidationDay to 'Wed, Fri' for 'Spektra' and fill null values for this?
I am trying to create a beast mode where when the customer = 'Spektra' then the ConsolidationDay = 'Wednesday, Friday'. I also need this to populate the ConsolidationDay cells with 'Wednesday, Friday' as they are currently null. What would be the correct Beastmode to do this?