lb1234

Comments

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

in How would I pull the highest rate over the last 12 months in a beastmode? Comment by lb1234 April 2023
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.

in Is there a way to exclude dates from outside months in the MoM comparison? Comment by lb1234 March 2023
and is the table chart the only chart in which this beast mode will work?

in Why is my beastmode to bring in Salesforce Profile Photos not working? Comment by lb1234 March 2023
@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,'">','')

in Why is my beastmode to bring in Salesforce Profile Photos not working? Comment by lb1234 March 2023
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,…

in Fixed Beast Mode for Percent of Category Comment by lb1234 March 2023
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…

in Top Sales Week by Closer Comment by lb1234 March 2023
@MarkSnodgrass is there a way to show the percent of the category instead of the total percentage of the subcategory in the subtotal?

in How to Include Subtotal Percent in Pivot Table? Comment by lb1234 February 2023
@MarkSnodgrass what would this beastmode look like if you were to only get the business hours for Monday - Friday, not every day?

in Difference in Business Hours Comment by lb1234 December 2022
@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…

in How to count distinct based on the sum of another column? Comment by lb1234 November 2022
@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…

in How to count distinct based on the sum of another column? Comment by lb1234 October 2022
@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?

in How to count distinct based on the sum of another column? Comment by lb1234 October 2022
Thank you so much!!!!

in How to count distinct based on the sum of another column? Comment by lb1234 October 2022
@CBlandon Did you ever find out how to do this? I'm struggling with a similar situation.

in Combining two data sets Comment by lb1234 October 2022
@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.

in How do I get my subtotal and total rows in Table card to show the avg of % rather than the sum of %? Comment by lb1234 October 2022
@RobSomers this didn't work.

in How do I get my subtotal and total rows in Table card to show the avg of % rather than the sum of %? Comment by lb1234 October 2022
@zcameron thank you for your help!

in Business Days in the month Comment by lb1234 October 2022
@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.

in Business Days in the month Comment by lb1234 October 2022
@zcameron that worked perfectly, thank you! Now I just need to figure out how to do this for current quarter and current year.

in Business Days in the month Comment by lb1234 October 2022
@zcameron is it also possible to get this same formula but for days in the current week, quarter and year?

in Business Days in the month Comment by lb1234 October 2022
@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?

in Business Days in the month Comment by lb1234 October 2022

lb1234 Member

Comments