GrantSmith Coach

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

Hi @user023716 Have you looked at a Bar + Line graph? That'll allow you to have two separate scales on the same graph although one set would be bars while the other set are lines.

@user09600 Mine was a bit different since I was only looking at a single record however you might try and remove the MAX function.

Hi @user09600 I used a beast mode like this: CASE WHEN MAX(`Date`) = CURRENT_DATE() THEN 1 ELSE 0 END Then I used that beast mode as the summary number on a card. You then click the alert (bell) icon and set it to alert you if a certain criteria is met (in this case the summary number = 0). My beast mode was named "Up To…

Your link should be enclosed in double quotes and the target needs a space before it try this. CONCAT('<a href="https://www.research.net/r/',`Survey Collector - Current`,'?c=',`Ops Sup Region`,'&PFC=',`PFC Name - Survey Link`,'&PCN=',`PCN`,'" target="new"> Activity Link </a>')

Hi @Jessica Admins have the ability to delete pages under More > Admin > Pages and then searching for the page, selecting it and then going to Edit > Delete Pages.

Hi @Hulachic5 You're missing a few commas. Try this: CONCAT('<a href= https://www.research.net/r/',`column header name`,'_',`column header name1`,'_',`column header name2`,'?c=',`column header name4`,'&PFC=',`column header name5`,',',`column header name6`,'&PCN=',`column header name7`,'target = new> name of link on card…

@user09600 Are you saying that your datasets run and you're able to detect that but if it happens to run and doesn't pull in any data then you don't have an alert for this case? What I've done in the past for those cases is to check the latest date that my dataset had within it's data. If it wasn't yesterday (I run this…

@user055735 You'd need four separate beast modes to create 4 new columns to count each of the 4 individual answers. If you include the `Why did you decide to not enrol?` value itself on your chart then it will only work for that specific answer and not the entire set of answers for the question. Can't afford example: SUM(…

@user000051 Beast modes are really just a smaller subset of SQL commands. You can look up training on different SQL commands or functions online. One resource I like is https://www.sqltutorial.org/sql-functions/ or https://www.sqltutorial.org/sql-case/. You could also look up some online classes like Coursera or Udemity or…

Also based on your current logic if the timestamp fell exactly on 8:00:00 AM your code would cause it to always fall within the 7-8AM bucket and not the 8-9am bucket. You might want to change your BETWEEN to use '07:59:59' instead of '08:00:00' since BETWEEN is inclusive.

No, you'd have two separate beast modes. One for your values and another for your sorting. Bucket: case when timestamp_var::time between '07:00:00' and '08:00:00' then '7-8 AM' Sort: case when timestamp_var::time between '07:00:00' and '08:00:00' then 1 Although now seeing your beastmode - are you just breaking it down…

Hi @user084060 If you want to do some custom sorting you can utilize the same methodology you're using to create your buckets by assigining values via a case statement (such that your first bucket would be 1, second is 2 etc) and then use that beast mode as a sort on your card.

You can use windowed functions (talk to your CSM to get them enabled if you don't have them in your instance). I'm basing these on your example document but if you're wanting to see the running total you'd want to change OVER () to OVER (ORDER BY `Year`) - Cumulative Amount Current Year-2020 SUM(CASE WHEN YEAR(CURDATE()) -…

@Benjamin - DataFusions are a lot quicker than an ETL. I try to use them first if at all possible. The one current downside is that you can't use the fustion dataset as an input into a future ETL (Magic or MySQL) but I believe there might be a beta which will allow just that (along with DataSet Views / another beta).

Does your raw data have that unique identifier? How is your data being infested into the system? If you don't have the unique identifier and using SQL try adding the DISTINCT clause to ignore duplicates before investing into the system a beast mode isn't really the right tool in this cas as it analyzes each row…