Comments
-
@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