GrantSmith Coach

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

@jaeW_at_Onyx - Yes. UNIX_TIMESTAMP will convert the date to the number of seconds since 1970-01-01 00:00:00 so subtracting those two together will get you the total elapsed seconds between two date times. If you're wanting to display it as MInutes : Seconds you'd need to do some additional math. The following beast modes…

Hi @user095063 It sounds like your use case is perfect for the LAG windowing function withing a beast mode (you may need to talk to your CSM to get this feature switched on). @jaeW_at_Onyx has a really nice video outlining this…

If you have window functions enabled in your instance you could do this via a windowed function in a Beast Mode instead of a running total card: SUM(SUM(1)) OVER (ORDER BY `Date`) And then utilize @MarkSnodgrass 's solution about adding a month to the date for display purposes via another beast mode.

Another option if you have an existing data flow you want to transfer a subsection of a different data flow to you can highlight the section you want and then select copy to clipboard where you can then paste it into the separate existing data flow but if you're starting from scratch @MarkSnodgrass 's method is best.

Hi @WorldWarHulk It sounds like you could use the Pivot Table chart (Under Chart Types > Tables and Textboxes > Pivot Table) with the Account Numbers being your rows, Dates being your columns and Sales being the value.

Hi @sdarmody The closest chart would be the Flex Table however it doesn't support the heatmap banding that you're wanting. You'll likely need to create a customer chart for this specific use case.

Hi @user054650 @jaeW_at_Onyx has had several writeups about this specific problem but it boils down to you want a new table which has an actual date, a report date and an offset/period type. (Read more about it here: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Calculating-index-vs-Year-Ago/m-p/48952) So you'd have |…

Hi @user046353 Which SDK / language are you using?

@SLam If this is already a part of a magic ETL data flow you could use a value Mapper tile to convert that column to textual representations by overwriting the original value. It should look something like this (make sure you select your isActive field is selected for "Select a column to search")

Hi @SLam You can use a beast mode with a case statement to solve you problem. CASE WHEN `isActive` = 1 THEN 'True' ELSE 'False' END The above is assuming that You only have values of 0 and 1 (anything other than 1 is considered False) If you want to be alerterd if you get a value other than 0 and 1 you could do something…

Hi @user037867 You could utilize a ROUND(number, <decimal places>) function in a mysql dataflow to force it to do the rounding to the precision you want instead of having to truncate your numbers on input. If the percentage is calculated in your initial query you can use ROUND there instead of a MySQL data flow as well.…

Hi @user06979 . You'll want to utilize a recursive data flow. There's a good Knowledge Base article outlining the steps here: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_ETL_DataFlow. You'll utilize your e-mail dataset as the input.

Hi @user007486 - Welcome to the Dojo! Have you tried dragging your fields from the Columns section to the Rows section in Analyzer?

@Jessica - How are you not able to access it? Is it a matter that you're not able to see it you'd need to filter the pages by clicking the the three dots next to the page name to do the filtering.

@user18178 Currently I don't beleive Domo supports a table wide NULL mapping but it requires multiple mappings - one for each column. This would be a great idea for the idea exchange. I'd definitely vote for it.