ArborRose Coach

I think you can set the background image in the App settings. If you adjust the card transparency on all your cards, the background image may be visible through the cards.

If you are using the brick method, you may need to refresh or reset the dataset0. You can also make new columns with a formula tile. Say for example you set the fields for "Field1" and the formula to ''. The output tile will see that new Field1 and leave it blank. I'm not sure how you are filtering on the extra columns. I…

@Eric.P - I see your question. But I have to join a conference call for a bit. I'll circle around when I can and clarify with an example of how I implement comparisons. Someone else viewing may also jump in and explain.

If you are looking to compare quarters from current year to previous year, you would have something using Quarter(). SUM( CASE WHEN YEAR(event_date) = YEAR(DATE_ADD(CURRENT_DATE(),-365)) AND QUARTER(event_date) = QUARTER(DATE_ADD(CURRENT_DATE(),-365)) AND event_date <= DATE_ADD(CURRENT_DATE(),-365) THEN amount ELSE 0 END)…

The way you describe it, you are pivoting on the values in column, "Values". After that pivot, you would have Questions, Labels, and new columns, based on "Values", but not the values column itself. I would think if you want to pivot twice off the same column "Values", you would have to duplicate the column before the…

If I understand the issue properly, you need to go to Data label settings (under chart properties). In the first box that says "Text", hit the plus sign. Click on value to put the value represented by the bar as the label.

Perhaps this would help you: To obtain the access token using OAuth 2.0, you need to make a POST request to the Access Token URL with the appropriate parameters. Step-by-Step Guide Get the Authorization Code: Direct the user to the Authorization URL. The user will log in and authorize your app, after which they will be…

If you recreate my example, and set dataset0 to your dataset, the following JavaScript code should be able to pull that data. JavaScript is case sensitive. Make sure you modify fields to exactly match the spelling and case of your own. // Assume dataset0 is already set to your dataset let data = dataset0; // Aggregate…

Here's the shared link to the example I have created on my freemium site: <iframe src="https://embed.domo.com/cards/W7x0g" width="600" height="600" marginheight="0" marginwidth="0" frameborder="0"></iframe> To replicate this, go to AppStore and find Blank Brick. Then hit get. It will set it up with Example Data. You can…

Hmm. You could try doing it on a blank brick. In a brick you can access the datasets and make your own logic.

Doh! It must be time for the weekend. Thanks @MichelleH.

The warning "Not all data is shown" in Domo typically indicates that there’s a discrepancy between the data you expect to see and what’s actually being displayed in your chart or table. This can happen for various reasons, including issues with dataset synchronization, table settings, or the visualization configuration.…

When you say bar properties, do you mean the value? There's a property setting for data labels. Hit the plus sign and select what you want on the label, or type directly.

Sorry, that did not format well. I created a sample table based on your question (mysample): ProjectName,Month,PlannedCost,ForecastCost Project1,2021-10-01T00:00:00,10,10 Project1,2021-11-01T00:00:00,15,10 Project1,2021-12-01T00:00:00,3,20 Project1,2022-01-01T00:00:00,6,20 Project1,2022-02-01T00:00:00,10,9…

Using mysample as: ProjectName Month PlannedCost ForecastCost Project1 2021-10-01T00:00:00 10 10 Project1 2021-11-01T00:00:00 15 10 Project1 2021-12-01T00:00:00 3 20 Project1 2022-01-01T00:00:00 6 20 Project1 2022-02-01T00:00:00 10 9 Project2 2023-01-01T00:00:00 30 44 Project3 2024-07-01T00:00:00 5 3 Project3…

Correct Encoding for Basic Auth: Ensure you are encoding the credentials correctly for Basic Authentication. The btoa function should encode the credentials as username:api_token. For example, if metadata.account.Username is user@example.com and metadata.account.APIToken is your_api_token, the btoa function should encode…

When you add a series to a bar graph, it often changes the way the graph displays certain metrics like Min, Max, and Average. Sometimes removed or not shown in the way they are with a single series. You could try creating calculated fields to manually compute the Min, Max, and Average values based on your data. You can…

I think you can use other parameters are long as they are appropriately created and referenced. Something like this maybe? Making sure you keep everything case sensitive. { "parameters": [ { "name": "Geographic Breakdown", "type": "select", "label": "Geographic Breakdown", "values": ["Country", "State"], "default":…

It might be a bug or a misconfiguration if it doesn't allow submitting without filling in the optional question. Double-check to see if the "Required" toggle is turned off for the optional questions. And make sure that there are no conflicting settings in the form’s overall configuration that enforce all fields to be…

In the Form Builder, I believe there's a "required" toggle you can adjust for question settings. For multiple options, select the response type as "Checkboxes" or "Multiselect" from the list of available response types. To enable a text box when the 'Other' option is selected: Add the Multiselect Question: Add your…

I don't know about whether it does it "easily". You would need to create a table in Domo where users can select date comparisons between two periods and see the data along with the percentage change. Create two Beast Mode fields to capture the start and end dates for both periods. CASE WHEN `date` BETWEEN '2024-09-01' AND…

You can manually export the data from Google Ads and then import it into Domo or Looker Studio. Go to your Google Ads account. Navigate to the "Campaigns" tab. Apply the necessary filters to display the "Demand Gen Product Feed" campaign. Export the data to a CSV or Excel file. You can create a custom solution using Google…

The totalDuration field in the DomoStats Card Loads dataset represents the total load time in milliseconds for all card loads on a given date. To get the total load time for each card, you need to aggregate this by card ID. Regarding embedded cards, the DomoStats Card Loads dataset does capture load times for embedded…

If your date is less than the current date in the current year, it's YTD. If you do a previous year, you have to include the statement date less then the date minus a year, which is the comparison date for previous year. You can subtract an interval of days or subtract an interval of year. SUM( CASE WHEN YEAR(`date`) =…

If you set all three of the datasets (dataset0, dataset1, dataset2) to your dataset, you can remove the Example Sales Data. But be careful, removing it without changing all can wipe out the brick.

I don't think there's a direct connector. You probably have to use a combination of Azure tools, export methods, etc. Workbench, Python or something to import into Domo. You could try PowerShell scripting… Install-Module AzureAD Connect-AzureAD #Use cmdlets like Get-AzureADUser and Get-AzureADUserLastSignInActivity to…

The Bitly Connector in Domo typically provides data on link clicks rather than QR code scans directly. Bitly’s standard metrics focus on tracking clicks on shortened URLs. If QR code scans are linked to Bitly shortened URLs, you would see the data on those clicks, but the connector does not differentiate between scans and…

I would think that filtering would limit the incoming dataset before any of the brick code occurs. From that point, it would be up to your code in JavaScript to deal with the changes. Order of processing. It seems like you are trying to put a condition on the code that might be trying to put back data that isn't there at…

If your brick dataset is on dashboard with filters against the same dataset, it should filter on its own. Filters must have the same field name. And Javascript is case sensitive..make sure you type the field names exactly the same.

Here's an example. Note that my dataset0 is set for Example Sales Data. This would be set to your own dataset. Javascript: var domo = window.domo; var datasets = window.datasets; // get the data domo.get(`data/v1/${datasets[0]}`).then(function(result){ var tableHTML = "<table><tr>"; // Extract headers and make them bold…