learnDomo Member

Comments

  • @nmizzell , Thanks for the idea, I shall look into that too .
    in Help Comment by learnDomo October 25
  • @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.
    in Help Comment by learnDomo October 25
  • 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