GrantSmith Coach

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…

Hi @PandianS , Are you unable to use the new Lineage tab on the dataset? That'll show you the upstream and downstream datasets that are impacted without having to utilize the Domo Governance Dataset connector.

Hi @user11590 , You have three options. MagicETL, MySQL ETL or calculate in your query that pulls the data into domo. Beast mode won't allow you to show that calculated field on another dataflow (it will appear on another card if you select "Share Calculation on DataSet" when creating the beast mode) Magic ETL isn't very…

It might not be exactly what you want to do but MySQL DataFlows support the UPPER function you could perform your ETL work in MySQL instead of Magic ETL. Alternatively you have the MySQL Dataflow just do the upper conversion and then use that MySQL dataflow as your input into your current Magic ETL. You'd think they'd have…

@user045760 You can actually use a windowed function beast mode assuming your have unique identifiers in each row. This example is using the Date Dimension but you could change `Date` to your key field(s) SUM(SUM(1)) OVER(ORDER BY `Date`) You may need to have your CSM enable windowing functions as I believe it's still in…

Hi @user019875 You can explicitly state which cards interact with others via their filters. It'd be better if we could just state don't affect this card with filters but we have to do the inverse and define which other cards are affected by the filter for each card on your dashboard. Essentially you'd have to edit each…

@user067938 What type of file are you attempting to retrieve? If it's a CSV and the repository is public you could use the CSV Advanced connected and just put in the URL to the file from github. It might also work if it's a private repository if you supply the username / password or key when configuring the account (you…

I was incorrect and was thinking of sharing datasets rather than dataflows. Right now you can't share data flows (but I did post an idea exchange for just that: https://dojo.domo.com/t5/Ideas-Exchange/Share-DataFlow-like-sharing-DataSet/idi-p/47867). Essentially you'd need to give the user "Manage Dataflows" permissions to…

@user14700 You'll need to have admin priveleges to do this or work with your instance's Domo Admin to set this up. You'd need to either give all Privileged users the "Edit Dataflow" permission for that specific role (More > Admin > Roles) or create a new role for this specific user which has the "Edit Dataflow" permission…

@jaeW_at_Onyx I recommended this method in case there were any advertisers which didn't have any revenue in 2019 or 2020 whereas the LEFT + RIGHT JOIN union method would only include advertisers which had revenue in 2019 or 2020. Your method is preferred if we're only looking for advertisers with revenue but from what I…

@user02319 Correct, you'd need to read the data into a dataframe but you're essentially doing that right now anyway with your dataset pull - it's pulling all of the data into the file object you'd just need to convert it to a dataframe. I don't see a way to filter the dataset using the Python SDK currently. It's just…

@user095063 A quick version would be SELECT a.`Week`, a.`Advertiser`, a.`2019 Revenue` b.`2020 Revenue` from `2019` as a left join `2020` as b on a.`Week` = b.`Week` and a.`Advertiser` = b.`Advertiser` This requires an advertiser to have appeared in 2019 first to be displayed in your final table. If you want to make sure…

@hamza_123 How are your data label settings defined? Did you change it to reference %TOOLTIP1 instead of leaving it blank? What do you mean by empty thread?

Hi @user02319 A highly popular python package for analytics and processing data is called pandas. It allows you to read CSV files (and other sources) into a DataFrame (essentially a data table) with columns and rows. This allows you to then filter specific rows or columns based on specific criteria and then export the data…

Hi @user02319 A highly popular python package for analytics and processing data is called pandas (https://pandas.pydata.org). It allows you to read CSV files (and other sources) into a DataFrame (essentially a data table) with columns and rows. This allows you to then filter specific rows or columns based on specific…

Hi @user02319 A highly popular python package for analytics and processing data is called pandas (https://pandas.pydata.org). It allows you to read CSV files (and other sources) into a DataFrame (essentially a data table) with columns and rows. This allows you to then filter specific rows or columns based on specific…