user056243

When I do as you suggested 350k shows 200 300k shows 110 250k shows 95 Ideally 250k should shows 95+110+200 300k should show 110+200

in Bucketing Comment by user056243 August 2020

Cool. It works now. You are a rockstar!!

in Filtering a dashboard across multiple datasets Comment by user056243 February 2020

No. Removing and adding also doesn't allow to select the dataset

in Filtering a dashboard across multiple datasets Comment by user056243 February 2020

It doesn't work for me. I use the data from 4 different Salesforce reports and it doesn't give an option to pick multiple. Please see below

in Filtering a dashboard across multiple datasets Comment by user056243 February 2020

I tried the below to convert from IST to EST, not sure if this is correct case when (HOUR(`Date/Time Opened`)+10)<24 then (HOUR(`Date/Time Opened`)+10) else (HOUR(`Date/Time Opened`)-15) end

in Time Zones Comment by user056243 February 2020

Thank you. It worked. I have one more question can we use two different conditions for the same output. Example: CASE WHEN `Case Owner Manager` IN ('a', 'b,'c') THEN 'Tier 1' WHEN `Case Owner Manager` IN ('d','e','f','g') Then 'Tier 2' WHEN `Case Owner Manager` IN ('h', 'i') Then 'Strategic' ELSE 'Others' END also 'Case…

in Multiple Nested Case Statements Help Comment by user056243 February 2020

Similar issue but solution doesnot work CASE WHEN `Case Owner Manager` IN ('a', 'b,'c') THEN 'Tier 1' Else CASE WHEN `Case Owner Manager` IN ('d','e','f','g') Then 'Tier 2' Else CASE WHEN `Case Owner Manager` IN ('h', 'i') Then 'Strategic' ELSE 'Others' END Tried without else CASE WHEN `Case Owner Manager` IN ('a', 'b,'c')…

in Multiple Nested Case Statements Help Comment by user056243 February 2020

user056243 Member

Comments