GrantSmith Coach

@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.

@user016969 - This is because how the Sub Total option works. It doesn't know anything about your beast mode but rather it's just adding up all of the previous row values. This is why you're getting 13% + 36% = 49% rather than 529 / 1546 = 34%. It's because of the order of operations used to calculate your percentage. Put…

Drag your beast mode to the filter section of the card and then select "is not" and set 0 as the value and click apply.

Hi @user023694 Have you tried using a Beast Mode to set a value when your data is null and then use that Beast Mode in a filter to ignore those null values in your chart?

Hi @eriena Have you tried sorting by Page Name on the card in Descending order?

@user06209 - What dataset permissions do you have? You might be limited based on your role.