GrantSmith Coach

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…

What are you attempting to alert on?

Do you have the time stamp for the hours you're wanting to graph? Domo now supports hour granularity in the time slicer so you could graph by hour. You could also possibly use the HOUR function in a beast mode might work as well

@user052734 Have you looked into using the Java CLI tool - https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool That may be an easier way to update the beast modes rather than going through each card.

@MartinB I don't think there's a preset value for "Just the week 2 weeks ago" but you can do that last 2 weeks which would include both weeks which isn't what you're wanting. It could just be a simple beast mode though with a bit of gymnastics (date subtraction) CASE WHEN `Date` > DATE_SUB(DATE_SUB(CURRENT_DATE(),…

Hi @hamza_123 Have you thought about using a beast mode shifting the dates either ahead 2 days or back 5 days (depending on how you want to calculate the week number) and then graphing by week using the new shifted date? DATE_ADD(`Date`, 2) DATE_ADD(`Date`, -5) If you have your Domo settings to be displaying the week with…

Hi @WizardOz If you're wanting a separate copy of these cards you can utilize the Save As option instead of Move / Copy. This will allow you to make changes to these cards without affecting the original versions. When you do a Save As you can also specify the parent page you want them saved to so you don't have to move…

Hi @user01052 A couple issues with your beast mode. The first being you're comparing a date to a string which doesn't always work well. The second and most imporatantly is that your beast mode runs on a row by row basis so your denominator would always be null for dates after the first snice the dates aren't the first and…

Hi @domo_card Currently the Pivot table card doesn't support HTML markup like the normal or mega tables do. You could sort of create your own pivot table within a MySQL or Magic ETL however you have to maintain the columns yourself and is a prohibitive hassle to attempt to keep it up to date (especially with dates) so it's…

Hi @LLucinski , You could utilize a beast mode with a case statement to calculate the outpatient discharges For example: CASE WHEN `Filter Field` IN ('DISCHARGE VALUE1', 'DISCHARGE VALUE2') THEN `Metric Field` END That will then only contain the metric you're utilizing if it's a discharge record. You'll also want to make…

Hi @Stefano , I've done some things similarly in terms of attribution modeling using a Markov chain / probability matrix pivot table but it depends on how many different pages you're attempting to display in your pathing report. The more different pages you have the wider and larger your table / matrix becomes. The…