GrantSmith Coach

Hi @KJRowe6 If you have one incident per row then you don't need to have the MAX in your beast mode - It's always returning the highest date with your incidents. Try this: CASE WHEN DATEDIFF( CURDATE(), `created_at`) > 30 THEN 'Aged' ELSE 'Not Aged' end

Hi @user095063 How many input data sets do you have? Do you only have the one data set? Are you attempting to do a recursive appending data flow?

Hi @user022825 Domo currently can't handle sending alerts to a dynamic e-mail address. You'd likely need some external process (like a python script) to pull the data and send the emails based on the list.

Hi @user017636 You need to drag it from the data section not the data table section from either the dimensions or measures sub sections. Click on Data to display this section.

Hi @user046467 Short version: I used a python script interacting with the Google Ads API and then used the Domo API to upload a dataset. Long Version: I've had the same problems and ended up not using Google sheets entirely as the timing of the Google script to populate the Google sheets and the Domo job to pull in the…

@mynameisyannis - To follow up on @jaeW_at_Onyx 's dealing with UNIX_TIMESTAMP I've outlined usage and math to get days, hours, minutes and seconds in another post here: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Date-Calculations-minutes-and-seconds/m-p/49259/highlight/true#M8465 

@jaeW_at_Onyx - Right, that's why I suggested to talk to the CSM to possibly having both the windowing function and the aggregate / windowing filters enabled. You are correct in that it might not have the expected results at times and is still sort of use at your own risk.

Using row limit, no, pfilters won't affect that setting. You might be able to use a windowing function to calculate the row number and then use a pfilter to filter the beast mode (this requires two feature switches on your instance, one for the windowing functions and another for filtering aggregates - talk with your CSM).…

@user055758 Are you wanting to remove the column from the table or reorder the columns? If you want to remove it from showing up in the table just click the X when you hover over the column in analyzer. If you want to reorder it you can click and drag the column around in the order of the other columns to reorder it. If…

Hi @user006513 Have you tried applying a row limit to your table to be 50? (Data Table > Row Limit - Just below the Add Calculated Field button on the column list)

@DP_DynamicData Facebook / Instagram recently redid some of their security / authentication with the API. They disabled their legacy API on June 29th, 2020. (See https://www.instagram.com/developer/). Likely Domo was using the old API and thus no longer works. You'll need to reach out to your CSM or Domo Support…

@Simon_King Assuming you're doing this in JavaScript you can utilize the getTime function: var ts = Math.round((new Date()).getTime() / 1000); The above example uses the current timestamp but you can swap out the new Date() call with a different date if necessary.

@nat040711, Have you tried just the denominator (second part) and see what that returns? Based on your formula I'm assuming you have another row in your table which has the overall total, is that correct? You could also attempt to do a windowed function (assuming you have them enabled in your instance - if not talk to your…

Hi @kacy If you have a contract start date and end date and you're looking at the dates in between you'll need to join your usage table to a date dimension table. Domo has a dataset of Dates (Cloud App > Domo Dimensions > calendar.csv). You can select the date from the date dimension table and left join it to your usage…

If you want to utilize PDP then yes. Those users would need to have a Domo license. The other, not as clean option would be to create separate filtered cards with the view you want users to have and then schedule the report to email an email address which shouldn't require them to have a license but will be very difficult…

Hi @user045611 Have you tried looking under the activity log (Admin > Activity log) and filtering the events there? I'm not sure if you're referring to user accounts or API accounts but start there.

@pprice11 CASE statements are your friend. CASEWHEN I8121="Total SS" THEN M8121*12WHEN I8121="Total PODZ" THEN M8121*12WHEN I8121="Total 5+1 " THEN M8121*2WHEN I8121="Total 3 Pack" THEN M8121*4WHEN I8121="Club Pack" THEN M8121*360END

Hi @user045611 If you only want users to have access to specific records within your data you'd want to look into PDP. This would allow the scheduled reports being sent to those people so they'd only have that information a part of the report. Again, this is assuming Jane should only be able to see Indiana data and John…

Hi @Steffi You might be interested in the Beast Mode Manager beta which would be an easier option for changing your beast modes in a single place rather than having to worry about using the CLI. Talk to your CSM to see if they can get that setup for you.

@JasonAltenburg I'll typically do a comparison to 364 (364 / 7 = 52) days ago so that the same days are compared against each other (Sunday - Sunday, Monday - Monday etc) which tends to get around this issue.

@user024906 - Public means anyone who has the link can see your data either inside or outside of your company. If you have sensitive company data you don't want accessible outside of your company then I wouldn't recommend using the Public option. If you're looking to create a dashboard without requiring a Domo login you…

Hi @user046467 This is because how SQL works. When you add null to something the result is NULL. A couple of options: Beast Mode COALESCE(`Total 1`, 0) + COALESCE(`Total 2`, 0) MySQL ETL: Same code above in your select statement Magic ETL: Use a Value Mapper tile. Under step 4 - 'Enter a value to search for' click the gear…

Hi @user084060 It's indeed possible. First you'll need to sort your date in descending fashion. This will cuase the most recent records to be put first. The next step is to then limit the number of records being displayed within the data table. In Analyzer click the Data Table to show it on the analyzer. You can then enter…

Hi @user17569 Last I checked the Amazon Vendor Central doesn't offer an API to interact with their data but rather utilizes an EDI interface exchange which isn't capable of being ingested in Domo at this time. There are other companies which may offer an API interface (where they then do the EDI data exchange on the…

@grimmers - Fusions should be able to easily handle 23M records. It should handle up to hunders of millions of rows just fine. Plus with the benefit of fusions updating near instantaneously they're a really great tool for the large data sets.

Hi @user046467 Have you tried using the Facebook Ads Advanced connector using the 'Custom Insights' report type? This should allow you to select the FB Ad Account and should automatically include all new campaigns. With the other connector they aren't designed to automatically include any new campaigns so you have to…

Hi @DMJerry , What you're looking for is a windowing function in a beast mode. This isn't enabled by default so you may need to talk to your CSM to get it enabled in your instance but you can get a running total utilizing a window function like: SUM(SUM(`Total`)) OVER (ORDER BY `Day`) You can also utilize a window function…

@user17569 - Have you tried one of the Amazon connectors in the Domo app store to connect to your data directly instead of relying on the email being sent? I'm not sure specifically which information you're pulling but you can get Marketplace Data, Advertising Data and others utilizing their connectors.

Hi @user084060 That number is called the summary number. If you click on the number you can select different options for it's display. What you'd specifically want to select is "No Summary Number" and make sure you click apply. This will hide the summary number for you. You can also select a different field to display…

Hi @Java You could utilize a fiscal calendar: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/KPI_Card_Building_Part_2%3A_The_Analyzer/Using_A_Fiscal_Calendar Keep in mind, using a fiscal calendar DOES NOT change how DATE functions in Beast modes evaluate. It only implacts the Date filters in cards.