ArborRose Coach

Aggregation Context: If records are appearing multiple times, it might be due to the aggregation context. You need to ensure that the aggregation functions (SUM, ROUND, IFNULL, etc.) are correctly applied. This can often be a result of improper grouping in the dataset or the way the calculation is being performed. Data…

You could do a recursion to store values to an archive each week. Then poll the archive to identify changes. https://domo-support.domo.com/s/article/360057087393?language=en_US

Are both hosted on the same domain? The single sign-on state may not be shared across them. Do they share tokens or sessions? Auth0 may issue a token that needs to be recognized by both. Make sure that the SSO integration settings in DOMO are correctly set up to use Auth0 as the Identity Provider. DOMO should be configured…

Oh..and congrats to @Craig_Lynch on leveling up. 🏆️

Congratulations @nmizzell! Thanks for your help and participation.

I can't speak to what the limit might be. I have an app with around 30 cards on a single page (gauges, charts, brick, filters) and more on additional pages. It doesn't seem to care, and updates quite well. Some of the cards on my app share datasets, others on the same page pull from different data. Any that share a field…

If its survey data and anonymous, you may need a rule in there to account for groups smaller than X. If there are fewer than X, you aren't supposed to reveal the findings - something like that.

Yes, I see the same thing you do…a broken link.

I've only found it on the URL or via code (API). Here's a Domo reference for finding it on details. https://domo-support.domo.com/s/article/360043436533?language=en_US#:~:text=You%20can%20find%20the%20dataset,following%20%22%2Fdatasources%2F%22.

You can reset a password by going to More » Admin. Then edit the person and click the Change Password button.

Sorry, I did not see the first two sheets in the file. Hopefully some others will chime in. The following is just an idea, others may have better theories. Me……I would not attempt what I see in your spreadsheet. I did something like this a few years ago. My data was anonymized survey data for a large school district with…

Hey, that's terrific. You could also use a filter on that branch to limit what comes through that path.

Good question @Jarren. Expanding on what Grant suggested, you might be able to poll Domo via Python or other method. Something like this would give you a list of things affected by a rename. import requests import json # Replace with your Domo credentials and API endpoints client_id = 'YOUR_CLIENT_ID' client_secret =…

Correct, you see only what is produced by the Group By. But, you can either add fields to the group (if they match that "level"). Or, you can spawn a branch off that backbone, do something on the side branch, and then use a join to join new things back to your backbone. Edit…I said that slightly wrong. If you add a new…

Setup your data in a way that is structured to include columns for user scores and direct reports. Leader View Score Direct Report 1 Direct Report 2 Direct Report 3 Regan Regan's View 85.8% Rosy Suzy Rosy Rosy's View 80.3% Paul Jhonny Paul Paul's View 93.8% Josh Kate Jhonny Jhonny's View 86.0% Jackie Linda Tyson Suzy…

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…

https://community-forums.domo.com/main/discussion/comment/97480#Comment_97480 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…