ArborRose Coach

Just for clarity, what @Data_Devon is referencing is your field name, not a static value. DATE_ADD(`your_date_field`, INTERVAL 1 MONTH)

I only know to set it for the company. Admin > Company settings. The functionality has been requested: And in this previous request - a loom link was shared but it doesn't appear active. https://community-forums.domo.com/main/discussion/67058/can-i-default-the-landing-page-to-an-app

Being an "Analyst" on your company page is probably not sufficient. LinkedIn's API typically requires the user to have an "admin" role for the company page to access data through third-party tools like Domo.

I believe you would need to setup some kind of work-around. Create an automated dataflow and include a step that validates whether the new data was added (check timestamps or row counts). Or set up an alert with a trigger condition to let you know when new data is added.

Creating a drill path to an existing card is not directly supported as a native feature in the same way that creating a custom drill path is. You can create a calculated field in Beast Mode that generates a URL to an existing card. If it's the existing card, why not use filter views or page filtering (multiple cards…

As David mentions, sometimes a card might not render properly but still occupies space. Go to the dashboard's edit mode. Look for outlines or boundaries of the dead space. Try resizing. There may also be some type of grid misalignment or layout issue. Go to edit and see if you can drag something else there or reposition to…

Sounds interesting. Is this question coming from a school or training exercise? Parsing the Currency Code and Amount: As your screenshot shows, you can use the split column tile toseparate based on a delimiter (space or symbol that separates the code and amount) and then a formula tile to clean up or reformat the separated…

CASE WHEN COUNT(DISTINCT CASE WHEN (Company Name IS NOT NULL) AND (Activity types LIKE '%attended event%' OR Activity types LIKE '%email engagement%' OR Activity types LIKE '%webcast attended%' OR Activity types LIKE '%webpage visit') AND (distribution team LIKE '%marketing') AND (salesforce contact record type LIKE…

When working on the data from the data center, there's a schema option in the upper right: You can reorder the column from that command. But they will not stay in that order. If the ETL is modified or the process re-runs, it will most likely change the order back. Under Admin > Governance > Toolkit, there is also a schema…

You can select a set of stories, features, etc and compare their open/completed status with the their status in the source system. Make sure the totals, averages and other aggregates match the source data for a given period or project.

@ggenovese, Lol….I thought I was confusing computer languages. Obviously…that's a better route to use.

Can you use the year and month to build a date? And then use that date to calculate your end date? Say you create a formula to find the first of the month after and then subtract one day from that. I have to test this, but possibly something similar: DATE_SUB(DATE_ADD(DATE(CONCAT(`Year`, '-', CASE WHEN LENGTH(`Month`) = 1…

You can use a replace text tile in an ETL to remove the known value, "FY2024". Or a command like this if it's static: TRIM(SUBSTRING(`BDM Name`, 1, LENGTH(`BDM Name`) - LENGTH('FY2024'))) Or get a be more complicated using a regular expression in a formula: REGEXP_REPLACE(`BDM Name`, 'FY\\d{4}', '') and wrap the TRIM…

Yes, I would try the Azure Connector. I have a few things hosted in Azure and it works a bit different than having a normal MS-SQL database.

I don't have an example set up to try this. SUM(CASE WHEN ( (Year Selector = Fiscal Year AND Month Number >= 2) -- From February to December of the current fiscal year OR (Year Selector = Fiscal Year + 1 AND Month Number = 1) -- Include January of the next calendar year ) AND Month Number <= CASE WHEN Month Selector =…

I don't think MFA would be an issue. Are you attempting to connect using the Azure Synapse SQL Connector?

I think DomoStats has: - Dataset ID - Dataset Name - Dataflow Name (if the dataset is used as part of a dataflow). - Input/Output Type (whether the dataset is an input or output for a given dataflow).

What if you change January to 13 instead of 1? That should cause it to treat January as part of your fiscal year Feb 2024 - Jan 2025.

There's also a box for "Allow Azure services and resources to access this server".

Sounds like you have a firewall issue. Azure SQL typically use .database.windows.net domain…something like that. And you need to make sure you have the IP addresses used by Domo includes in the Azure SQL firewall rules.

Orphaned datasets would be datasets that, when investigated in DomoStats, would not have "In Use in Cards" or "In Use in Dataflows". So you should be able to use DomoStats Connector to connect to DomoStats -Dataset Usage and filter for no references in cards or dataflows, especially with a long "last accessed" timestamp.…

I don't think there is a direct way to programmatically add a custom button inside a pivot card to trigger an export. But you can probably do something similar through a custom card or app.

Sounds great. Good job.

Domo datasets have a unique identifier behind them. When you view a dataset, you will see the identifier in the URL. When you make a copy of an ETL, you are normally setting up new datasets rather than pointing back at the original source of the tile. This pertains specifically to output tiles vs inputs. Output tiles…

I try to group filtering and sort of summarize based on the groups: Location: Dallas, New York Type: Retail And if no filtering is selected, display 'No filters selected'. Or you could try something on a single line such as : 🏢 Branch: Toronto | 📍 Province: Ontario | 🛒 Type: Retail

It sounds like the PDF export process is capturing the initial value rather than its current state. I assume it is because the displayed value isn’t persisting its selection. You could try making sure there's a persisting variable tied to the dropdown. Make sure the dropdown value is explicitly updated and reflected in the…

You can't directly change the connector type for an existing dataset. Behind the scenes I believe Domo has a unique identifier so it knows two different datasets, even if given the same name. You can update the connection settings for the existing connector. Or create a new dataset with a different connector. And migrate…

Great job. Glad to hear you found the answer. Five points to Gryffindor.

Thank you for the additional information. We need the ability to apply color rules to specific columns based on the values in a different column. Column-Specific Conditional Formatting Based on Another Column: Allow numeric or text columns to be color-coded based on the values of another column. For example: In a mega…

I am not sure I understand the request. Color rules are by column unless the box is checked to apply to row. You can make multiple columns react to the same formula. Can you elaborate?