Comments
-
@MichelleH - I have tried to take the record Id counts of all active employees by the total separations (which worked in the opposite way, as the date filter was limiting the TOTAL active). I have also tried a few beast modes "CASE WHEN SUM(CASE WHEN User - Active = 'true' AND YEAR(Official_Termination_Date__c) =…
-
@ColinHaze - I appreciate your response, but even adding the date wont work as I am trying to still separate the 2 call types. So the column just puts NH over Existing and I have to click on one or the other to drill down, but I am trying to find a way to click on "both" essentially.
-
@MichelleH Thank you! So simple! Do you know if there is a way to change the subtotal format, to add up the time rather than the count of each row? etg. 00:14:01 + 00:11:58+ 00:05:07…
-
@ColemenWilson - That is leaving all columns blank. Could it be a decimal issue?
-
@MichelleH - it does, I am going to try to rebuild the entire dataset/etl and see what happens.
-
@MichelleH - sure! Here is a full table overview - filters are just removing account names, sorting is by account-date-half hour. The beast modes just turn the percentage values into actual percentages 'ABANDONED (%)* 100'. I have another card just like this one without the half hour field that has no duplicate issues.. so…
-
@MichelleH - No subtotals or aggregated but there are a few beast modes
-
@MichelleH - Question for this one is there a way to rework this formula to only show when ‘Session_Date’ is this month and ‘X12_Month_Scheduled_Review__c’ IS NOT BLANK?
-
@MichelleH - thank you for that information! Unfortunately the formula is not pulling in the correct count - its pulling in 0.. they are both date fields so I wonder if that has something to do with it?
-
@MichelleH - its the beast mode that i get the error. I cant even save a basic beast mode - so I wasnt sure if there was something I was doing wrong.
