GrantSmith Coach

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…

I figured out the reason was that the windowed function beast mode won't work if the date is being graphed by anything other than "None". This is likely because it's trying to slice / window the data twice or two different ways.

Didn't work as a table card. No chance of it being null. Just doesn't make sense to me because I've done this a bunch of times before and it's a very simplistic beast mode. If I take out the ORDER BY `dated` section it'll work just fine (and of course not give me a running total). I've even tried filtering the date on the…

Hi @AJ2020 Since Domo doesn't support formatting strings yet you'll need to do it manually. You can utilize a beastmode with CONCAT and a bunch of substring manipulation like this to solve it (this is up to 12 digits / Billions but can be modified to go higher) (Untested but should give you the general framework)…

You'll want to do this utilizing an ETL. It's possible to do it in a Beast Mode with window functions however it would start on the first date that is filtered and not going back entirely in time to the start of your ledger. For example if you only displayed this year the beast mode variant would have $0 to start the year…

Are you and admin or card owner? Do you own the underlying dataset?

Here's an attached screenshot of a card in Analyzer highlighting the trash can icon to delete an annotation.

What the behavior it's currently displaying? What's it doing wrong?

Hi @Jessica You should be able to click on the annotation icon on the top of your graph and then click the trash can icon to delete the annotation when you're editing your card.

Hi @TylerMarshall It appears that Domo only supports the http or https protocol when attempting to make dynamic links. Likely for security reasons but that's a guess. When it generates the page it completely removes any link information and you're left with a stand alone anchor tag with no href property if it's not one of…

Hi @user084060 You could set the Value Scale (Y) > Max Gridlines to 0 which will remove most of the grid lines, it'll keep the 0 axis but also display the max y-axis line. There doesn't appear to be a way to remove the upper line.