ArborRose Coach

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?

I believe you can use the share button to give editor access for datasets, even if the user is a participant for everything else.

Publish app allows you to create a public-facing version of your dashboard that can be accessed by users outside your Domo environment. It is used for creating dashboards intended for an external audiences. When you add a domain as a subscriber, the published app is only accessible to users from that domain. This is a form…

Yes, you can. One way is to create an ETL that does the aggregate (total) and joins it back to the details. location value location1 100 location2 200 location3 300 result after joining location value group total location1 100 600 location2 200 600 location3 300 600 Create a bar chart (or another card) using the value as…

Use add beast mode to create a new calculation using a formula like ( `Paid Amount` + `Savings Amount` ) / `Bill Amount` Domo uses back ticks to enclose field names. Name it something like "Ratio". Save it and make sure it validates properly. Also make sure you have no null or zero values in Bill Amount. Otherwise you will…

I don't use the API with R-Domo. I use other connectors via Python, etc. Based on your "check list", it looks like you can communicate with a small dataset of five rows. That makes me lean toward thinking the size of the dataset may be an issue. You might try gradually upping that size and retest. I've had an issue in…

I don't know any way to impersonate a user to test PDP in Domo. In the past, I requested it as a feature but I've never seen any enhancement for it. I create fake users to test PDP policies as whatever group I need to test.

I concur with @ggenovese. Your month number zero is producing invalid values. DATE(CASE WHEN LENGTH(`Month Number`) = 1 THEN CASE WHEN `Month Number` BETWEEN '1' AND '9' THEN CONCAT(`Year`, '-0', `Month Number`, '-01') ELSE NULL END WHEN LENGTH(`Month Number`) = 2 THEN CASE WHEN `Month Number` BETWEEN '10' AND '12' THEN…