GrantSmith Coach

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…

Thanks @jaeW_at_Onyx I was aware of the 60 second limit, it was just odd to me that I've had wider and deeper tables in fusions return instantaneously. These together only had 69 columns so they weren't wide by any means. It's a one to many relationship so I didn't need to worry about a cartesian product. For whatever…

Hi @LLucinski Were you able to get this to work?

Is this a magic ETL or MySQL data flow?

@imelendez The knowledgebase has a good article outlining dealing with Time Zones: https://knowledge.domo.com/Administer/Specifying_Company_Settings/033Time_Zone_Issues_FAQ. It outlines several different options to switch timezones with your data.

Hi @texas , You could utilize the Date Dimension dataset provided by Domo and utilize a join to explode your dataset to populate for each day. Something like (this is untested back of the napkin): select * from `dates` d join `my_table` t on d.`date` BETWEEN t.open_date and t.close_date This will list each record ID for…