ArborRose Coach

You need to be careful how you compare week from one year to week from another. Depending upon how the calendar falls, it's apples and oranges.

Tweaking that a bit… CASE WHEN `Customer` = 'Spektra' AND `ConsolidationDay` IS NULL THEN 'Wednesday, Friday' ELSE `ConsolidationDay` END

Domo does support some basic HTML formatting in Beast Mode, such as <b> for bold text, and <font> tags for color. But, not all visualizations honor HTML formatting in column data. It sounds like you had success in summary but not in the column data itself. To create a string as bold and color, your formula would be…

I've never done this type of writeback connector, but I think you have to upload a public key to the SFTP server through the SFTP client. Look for a folder such as ".ssh/authorized_keys". You upload your public key file to that directory on the server, typically handled server side, not in Domo.

Sorry, part of that answer was redundant since I made two calculations with the same formula. <:*)

Assume my dataset is: A001 All Good A002 All Good A003 Our Leaders are approchable A004 All Good A005 We have good Cafeteria A006 All Good A007 I have a Good Work-Life Balance A008 I feel I am valued A009 I enjoy doing my Work A010 All Good A011 All Good A012 All Good A013 I enjoy doing my Work A014 I enjoy doing my Work…

A calculated field something like this? CASE WHEN `Date_StatusChange` < '2024-08-25' THEN 'Carry-In' ELSE CONCAT(YEAR(`Date_StatusChange`), '-', MONTH(`Date_StatusChange`), '-', DAY(`Date_StatusChange`)) END

Hard to say what's going on without seeing a data sample. It's normally due to the way the data is structured or the settings on the chart configuration. 1. Check your formulas. Make sure you are aggregating data based on the states. Since you calculate average days and median days, each beast mode should properly…

I don't have any experience myself connecting to BlueCherry ERP. But I would assume you could connect using any of the normal methods we connect with other systems such as via an API: Obtain API Documentation: Get the API documentation from BlueCherry ERP to understand the available endpoints, authentication methods, and…

Domo does not provide a standard SFTP server endpoint for file uploads directly. Instead, Domo typically integrates with data sources through connectors, APIs, and other methods rather than direct SFTP uploads. If you need to transfer data to Domo, you generally have these options: Domo Connectors: Use one of Domo's…

I agree with @nmizzell, if you can share with the groups. Sometimes that's not an option. Make sure the end users have been granted the correct permissions to the dashboard. Sometimes, dashboard permissions might not automatically extend to all the components within the dashboard. Card Permissions: Verify if there are…

Depending on your technical resources, you might be able to create a custom solution. For example, using Domo’s API to extract data from cards and then generate reports or files programmatically could be a workaround. This would involve some development work and could potentially be integrated into your embedded app. Domo…

Sorry, that's what I meant by "simplified". I didn't have the time to fully think through the whole solution.

Add a calculated field that determines whether a customer should be included based on their invoices. This field will check if any invoice for a customer falls within the selected aging range. Simplified…. Customer In Range: CASE WHEN `Aging Range` = '151-180' THEN 1 ELSE 0 END Aggregate the customer inclusions. To ensure…

Talking to SFTP sites is quite different than acting as an SFTP host. Domo isn't designed to replace an SFTP server itself. Domo excels at connecting to various data sources, including SFTP servers, to pull in and manage data. But it has no host area that I am aware of to act as a repository for files. If it did, the…

That works. Thank you @GrantSmith .

Okay…I get it. Something like this Domo blank brick….

An app in App Studio is a compilation of cards with easy to use styles and "fanciness". Okay, I made up that word…fancy-ness. Some cards may be tables, charts, bricks, etc. The "forms" you see in the AppStore can be used to create cards, which can be added in App Studio.

I'm not sure if I understand the question. Does this help? Year Outcome Type Count 2023 Win Retain 50 2023 Win Capture 30 2023 Loss Retain 20 2023 Loss Capture 15 2024 Win Retain 60 2024 Win Capture 35 2024 Loss Retain 25 2024 Loss Capture 10 outcome and type: CONCAT(Outcome, ' - ', Type) retain: SUM(CASE WHEN `Type` =…

I guess you could say they don't talk well together. I would say FIXED BY isolates the situation for each so they don't "see" each other well.

Given your use case, where you need to handle a POST request with a dynamic body and interact with third-party services, you might want to explore a couple of alternatives: External Server Proxy: Set up an external server or service that can act as a middleman. Your external server can handle the API requests, including…

The requests library is a popular choice for making API calls in Python, and it’s what I would typically use in most environments. However, when working within Domo's Python script task, the standard library might be more limited. If requests isn't available directly in Domo, you can achieve similar functionality using the…

Is it possible your name is being interpreted to cause that space? As a gap between the start of the timeline and where your first task begins? Chart date range maybe too broad, encompassing more dates than where the tasks start? We can't see the actual dates associated to things like State of the Company Dashboard….so…

There's no way to save from the card. As you mention…you can create calculated fields…setup an ETL transformation that can replicate the logic of the card. The FIXED BY clause in Domo is part of the window function capabilities. It allows you to calculate metrics within specific partitions or groups in your dataset,…

Go to the Admin Settings: Click on the Admin tab in the top-right corner of the screen. If you don't see this, you might need to access it from the Settings menu or another admin area based on your Domo version and permissions. License Management: Look for an option related to License Management or Subscription. This area…

I was only introduced to using Python inside Jupyter Notebooks in the past few months. But it has worked well. Somewhere out there are demo pages and videos. Short and sweet - I go to "Data" and on the left side, there are three dots. Click there and you will find Jupyter Notebooks. Within your Python code you can edit,…

import requests def add_user(instance_token, domo_instance, new_user): url = f'https://{domo_instance}.domo.com/api/content/v3/users' headers = { 'x-domo-developer-token': instance_token, 'Content-Type': 'application/json' } # Example payload for the new user payload = { "name": new_user['name'], "email":…

I like @MarkSnodgrass suggestion. You could also use Python scripts using the imaplib, email, and os libraries to automate the download of attachments from emails. Alternatively, third-party tools could possibly automate the download process. Domo Workbench could probably do it, but you would need to handle the specifics…

I have not. But you could use Jupyter Notebooks and Python to establish connections to the APIs of the tools you've mentioned. Wiz - CSPM: import requests token = "your_api_token" headers = {"Authorization": f"Bearer {token}"} url = "https://api.wiz.io/your_endpoint" response = requests.get(url, headers=headers) data =…

The data is still uploaded to the cloud. Domo Workbench is a tool that allows you to connect to various data sources on your on-premise server. It pulls data from those sources and then uploads it to the Domo cloud environment for processing, visualization, and storage. Although the data originates from your on-premise…