4 Replies Latest reply: May 16, 2011 8:24 AM by carlgade RSS

    Chart Presentation

    Tresesco B

      Hi All,

      I have 100 values(1,2,3,...100) in bar chart to show. I want 10 out of them display like 91,92,93,...100. i want to do it at presentation level only. limitimg the presentation to max=10 would not solve my problem, because then i would get 100,99,...91 or 1,2,3,...10 depending on the sort order. i can't limit the calculation or use calculated dimension to limit it. so only way is at presentation level.

      Any idea?

      Thanks & regards,

      tresesco

        • Chart Presentation

          Hi,

          view attached file.

          I use two variables and set analysis.

          Alex

            • Chart Presentation
              Tresesco B

              Thank you Alex, for your attempt.

              But as i mentioned in my prev post, i cant limit it neither from calculation (expression) or from calculated dimension option, because my calculation is based on inter-row (Above()/Below() function). so if the calculation is limited, then my result will vary. so i need it merely at presentation level.

              Hi Subhu, this is why i can't use calculation limit or...

              regards, tresesco

            • Chart Presentation
              Shubhasheesh Chakraverty

              Tresesco,

              Alex's 3'rd and 4'th charts may be your solution.

              But, why can't you use calculated dimension. You can give if ( dim > 90 and dim < 101 , dim ) and check on the " suppress when value is null " for this calculated dimension.

              Reg,

              Shubhu

              • Chart Presentation

                Old question, but I bumped in to it by accident I guess.

                 

                You can use if statetments to calculate chart values.

                 

                Example:

                if(calculation is < 80, do calulation, 0)

                 

                then suppress 0 values not to be shown in the graph.Maybe that would solve your issuse?

                Also, remember 0 values is not the same as zero values

                 

                Carl