11 Replies Latest reply: Apr 17, 2016 3:15 AM by Jing Yang RSS

    Missing Dimension values

    Jing Yang

      Hi Experts,

       

      I have data like below:

         

      IDGradeScore
      11273
      21275
      31279
      41311
      51325
      61330
      71332
      81333
      91345
      101346
      111347
      121348
      131349

       

         

      GradeLowHigh
      1250360
      2265400

       

      As the qvf file attached, I can build a bar chart,

       

      However, there are two things I want to have here:

      1. I don't want to miss any score range even it is 0 count, such as 280-300

      2. I need the all the score ranges from Low to High(Data should read from LowHigh table at run time) with interval 20 in my bar chart:

         

      Score RangeIDCount
      250-2690
      270-2893
      290-3090
      310-3292
      330-3498
      350-3600

       

       

      How can I achieve these?

      Thanks for you help in advance!

       

      Jing