GrantSmith Coach

Hi @WizardOz Currently I don't think there's a way to do this but there are a few posts in the Idea Exchange which relate directly to your request: https://dojo.domo.com/t5/Ideas-Exchange/Jump-Sections/idi-p/42789 https://dojo.domo.com/t5/Ideas-Exchange/Dashboard-Page-Anchor/idi-p/47452 Perhaps you can give those a like to…

Hi @user003911 It appears you have duplicate rows in your dataset. The main reason this happens is because of how you're joining tables together. You have a few options: * Change your query to make sure you're joining on a one to one relationship (most ideal) * Add a DISTINCT keyword to your select statement (quickest) *…

You could write a custom connector if you've got the technical resources for it. The process is outlined here: https://developer.domo.com/docs/custom-connectors/connector-dev-studio

Hi @Hulachic5 You've got a sum inside a sum function which won't work. You should be able to utilize something like (untested but should work): SUM( CASE WHEN `Specify type of PFC activity:` LIKE '%Video Teleconference Client Contact%' THEN `Enter the number of minutes in direct service for this client contact activity (1…

Typically the way to to parameterize a dataflow is to utilize a separate webform dataset with your value you want to filter on. You'll also include a second column in your parameter dataset called "Join Column" and set it to a constant value like 1. You then can utilize the dataflow to add the same constant to the data set…

I figured out the reason was that the windowed function beast mode won't work if the date is being graphed by anything other than "None". This is likely because it's trying to slice / window the data twice or two different ways.

Didn't work as a table card. No chance of it being null. Just doesn't make sense to me because I've done this a bunch of times before and it's a very simplistic beast mode. If I take out the ORDER BY `dated` section it'll work just fine (and of course not give me a running total). I've even tried filtering the date on the…

Hi @AJ2020 Since Domo doesn't support formatting strings yet you'll need to do it manually. You can utilize a beastmode with CONCAT and a bunch of substring manipulation like this to solve it (this is up to 12 digits / Billions but can be modified to go higher) (Untested but should give you the general framework)…

You'll want to do this utilizing an ETL. It's possible to do it in a Beast Mode with window functions however it would start on the first date that is filtered and not going back entirely in time to the start of your ledger. For example if you only displayed this year the beast mode variant would have $0 to start the year…

Are you and admin or card owner? Do you own the underlying dataset?

Here's an attached screenshot of a card in Analyzer highlighting the trash can icon to delete an annotation.

What the behavior it's currently displaying? What's it doing wrong?

Hi @Jessica You should be able to click on the annotation icon on the top of your graph and then click the trash can icon to delete the annotation when you're editing your card.

Hi @TylerMarshall It appears that Domo only supports the http or https protocol when attempting to make dynamic links. Likely for security reasons but that's a guess. When it generates the page it completely removes any link information and you're left with a stand alone anchor tag with no href property if it's not one of…

Hi @user084060 You could set the Value Scale (Y) > Max Gridlines to 0 which will remove most of the grid lines, it'll keep the 0 axis but also display the max y-axis line. There doesn't appear to be a way to remove the upper line.

Have you tried using a beast mode to calculate the total and then putting that into a tooltip and change your data label text to the Trollope value?

Thanks @jaeW_at_Onyx . I was looking for it last night on mobile but couldn't find it. @user052485 - You can refer to Jae's video for a visual representation of what I was talking about.

Typically to parameterize something like this you'd have a web form input with the parameter you want to use and in your case use PDP to filter the rows. You'd then add a join column as a constant in your ETL and set it to 1 on this web form and your input dataset and join them together on this column. Then if you need to…

I took a look at your SVG file and it appears that the bounding areas that were defined are well outside of the actual stadium image itself. The image goes between roughly 400 and 1300 wide (x) and 0 and 800 tall (y). Most of the locations of the sections I've seen are well in the 8000 ranges (x) which is outside of your…

Hi @user008949 Can you expand more on how your SVG isn't working properly? Are you getting an error? Is the data not displaying correctly? What is the exact issue with the SVG file?

Hi @WorldWarHulk It appears that the screenshot you posted is from the Knowledge base article (https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_ETL_DataFlow) which is what I'm going off of. The way that's configured is it joins the historical with the live data and ignores /…

Hi @user039888 If you're using workbench you can export jobs via the export-job or export-jobs command: PS C:\Program Files\Domo\Workbench> .\Wb.exe help Workbench Console Tool Copyright (C) 2017 Domo Version 5.0.6996.33056 Usage: wb [command] [option...] check-jobs Causes the service to check for jobs that need to be run…

What data type is the column stored as on the dataset within Domo?

Do you have some example data you can provide (that's either safe to share or make your own obfuscated dataset as an example)? I'm still a little perplexed with how your data is structured and what exactly you're asking about. If you're doing a pie chart for just B then are you filtering for only B data on your card?. Is Y…

The Pie Chart automatically calculates the percentage based on the category label. Are you able to determine if a value is to be included in your X bucket or not? If so you can use that logic in a case statement to split out the X values into 'Other' and 'Not Other' buckets to graph how you're wanting. Your math simplifies…

@user064197 What are your X and Y? Is Y constant across the entire dataset? You could utilize a new beastmode to define a new category with a CASE statement and then use that as the Pie Name field CASE WHEN `dayName` = 'Monday' THEN `dayName` ELSE 'Other' END

You could try the Dojo Job Boards: https://dojo.domo.com/t5/Job-Board/bd-p/Jobs

@user13799 - Can you post a screen shot of your ETL to see what you're doing so we can help diagnose (making sure not to include any propietary data/PII/PHI etc)? The data type shouldn't matter when doing an uncollapse column.

Hi @user13374 Yes, you can go to the data center and list all of your datasets. You can then mutli-select the datasets by clicking the checkbox on the left side of the row (you can hover over the icon on the left side to reveal the checkbox). Once you finish selecting the datasets you want to delete you can select the gear…

The CASE statement I mentioned above should handle this scenario which will combine the metric into the same column if the stat types are different. What does your CASE statement look like? It should look something like: CASE WHEN `Line Item / Metric / Stat` IN ('DISCHARGES', 'Adjusted Adm/Disch') THEN `Line Item / Metric…