lb1234 Member

Thank you for the attempt! Domo is still not liking it. I'll probably have to create it in an ETL.

What would make the most sense would be to show the actual days for each month. February's line would stop at day 28, January's line would stop at 31 and March's line would stop at 31. I know I could achieve this through an ETL but I'm betting I could also achieve this through a beast mode.

and is the table chart the only chart in which this beast mode will work?

@GrantSmith AMAZING! Thank you. Do you know if there is a way to display the photos in a circle rather than a square? I tried this beastmode but it's not changing the shape: CONCAT('<img style="border-radius:50%" height="20px" src="',Photo,'">','')

This wouldn't work for my use case but I did find a solution by wrapping the denominator with the fixed by function and adding the date being used as the filter on the card to the fixed by statement: COUNT(DISTINCT CASE WHEN Status = 'Unqualified' THEN Lead ID END) / (SUM(COUNT(DISTINCT Lead ID) FIXED(BY Company,…

I found a solution. I've used Row_Number to eliminate ties in the rank and I removed the week of year and year from the partition: Row_Number() over (PARTITION BY Closer.FullName ORDER BY COUNT(DISTINCT Opportunity Id) DESC, WEEKOFYEAR(Project.SaleDate), YEAR(Project.SaleDate)) I then filtered for weeks with a row number…

@MarkSnodgrass is there a way to show the percent of the category instead of the total percentage of the subcategory in the subtotal?

@MarkSnodgrass what would this beastmode look like if you were to only get the business hours for Monday - Friday, not every day?

@Aditya_Jain it still did not work. I've wrapped it in a case statement, please see below: Case when (COUNT(DISTINCT (CASE WHEN SUM(`Is Setter`) = 0 THEN `Setter.FullName` END)) OVER (PARTITION BY `Setter.FullName`)) = 0 then 0 else COUNT(DISTINCT `Task.ActivityID`) / COUNT(DISTINCT (CASE WHEN SUM(`Is Setter`) = 0 THEN…

@Aditya_Jain when I try and get an average of the number of tasks by setter using that calculation, I'm getting a divide by 0 error. How do I fix this? Here is my calculation: COUNT(DISTINCT `Task.ActivityID`) / (COUNT(DISTINCT (CASE WHEN SUM(`Is Setter`) = 0 THEN `Setter.FullName` END)) OVER (PARTITION BY…

@Aditya_Jain That worked when looking at a single value card but when I'm looking at the count for the last 13 weeks in a bar graph, I'm running into issues as it's not grouping the days into weeks. Do you know why this would be?

Thank you so much!!!!

@CBlandon Did you ever find out how to do this? I'm struggling with a similar situation.

@MichelleH this calculation is to calculate the team's current percentage of their monthly goal. The team monthly goals are ramped up each month from their first month as a team to their 4th month. So, those teams active 1 month or less will have a goal of 40, those with 2 months or less will have a goal of 80 etc.

@RobSomers this didn't work.

@zcameron thank you for your help!

@Billobi I contemplated using this in the ETL for the dataset that I'm using but I wanted a way to be able to calculate this on the card level for different date columns rather having to create these joins for each date column that I may want to use it on.

@zcameron that worked perfectly, thank you! Now I just need to figure out how to do this for current quarter and current year.

@zcameron is it also possible to get this same formula but for days in the current week, quarter and year?

@zcameron I'm trying to work through your total business days in the month calculation but I'm having some difficulty figuring out how I can include Saturdays in this calculation. Is this possible?