-
Converting Decimal Format to Days, Hour, minute format
I'm trying to convert these DATEDIF values from this format that outputs "3.36 days" to the format that reads "3 days, 8 hours, 38 minutes". I would need to be able to average them out too so I don't think a CONCAT function would work. Where should I start?
-
Date Filter to Omit Last 45 Days
Does anyone know if there's a way to set the date range filter to exclude the last 45 days but still give YTD numbers? For example, today is 8/19/2024 and the last 45 days is irrelevant to a certain set of data we have so I would want to look at July 5th and earlier. I know I could use the "Between" filter to just go…
-
NPS Calculation Through BeastMode
I'm trying to do an NPS Calculation through a beastmode and have already converted the "NPS-Value" column in another beast mode to Scores (9-10) = Promoter, (7,8) Passive, (0-6) Detractors. I'm trying to do the promoters - detractors / total *100 function in a separate beast mode but can't get it to work properly. What…
