Comments
-
Its not working.
-
@MichelleH, have tried changing to a blank but no change.
-
Hi MichelleH, Thanks for reaching out. Here are my beast modes; IFNULL(CASE WHEN Metric IN ('All Calls','Calls Time') AND Level = 'Stage 1' THEN SEC_TO_TIME(Total) ELSE ROUND(SUM(CASE WHEN Level = 'Stage 1' THEN Total END),0)END,0) IFNULL(CASE WHEN Metric IN ('All Calls','Calls Time') AND Level = 'Stage 2' THEN…
-
@nmizzell , Thanks for the idea, I shall look into that too .
-
@ColemenWilson ,thank you so much for the idea, though I was just trying to run away from this presentation. I guess I shall maintain the same idea as your suggestion.
-
So,I have a frequency count of the total, grouped by compokey and total. For the dynamic rank table, I took a unique count of each compokey & increment by 1 for ranking.
-
I'm generating the rank directly from the dataflow. SELECT a.`Rank`, a.`CompoKey`, a.`Total`, (SELECT COUNT(b.`CompoKey`) FROM `totalFfreqData` b WHERE a.`CompoKey` = b.`CompoKey`) AS 'Sample Size' FROM `dynamicRank` a
