Stu5677 Member

Comments

  • @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.