GrantSmith Coach

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…

Hi @WizardOz Currently I don't think there's a way to do this but there are a few posts in the Idea Exchange which relate directly to your request: https://dojo.domo.com/t5/Ideas-Exchange/Jump-Sections/idi-p/42789 https://dojo.domo.com/t5/Ideas-Exchange/Dashboard-Page-Anchor/idi-p/47452 Perhaps you can give those a like to…

Hi @user003911 It appears you have duplicate rows in your dataset. The main reason this happens is because of how you're joining tables together. You have a few options: * Change your query to make sure you're joining on a one to one relationship (most ideal) * Add a DISTINCT keyword to your select statement (quickest) *…

You could write a custom connector if you've got the technical resources for it. The process is outlined here: https://developer.domo.com/docs/custom-connectors/connector-dev-studio

Hi @Hulachic5 You've got a sum inside a sum function which won't work. You should be able to utilize something like (untested but should work): SUM( CASE WHEN `Specify type of PFC activity:` LIKE '%Video Teleconference Client Contact%' THEN `Enter the number of minutes in direct service for this client contact activity (1…

Typically the way to to parameterize a dataflow is to utilize a separate webform dataset with your value you want to filter on. You'll also include a second column in your parameter dataset called "Join Column" and set it to a constant value like 1. You then can utilize the dataflow to add the same constant to the data set…