11 Replies Latest reply: Jul 21, 2015 5:58 AM by Kumar Pramod RSS

    Changing the labels name in bar chart

    Kumar Pramod

      HI all,

       

      I want to change the labels name in the bar chart. so i have used the below query for dimensions.

       

      IF(match(question_id, '1'), Replace(question_id, '1', 'Q1'),

      IF(match(question_id, '2'), Replace(question_id, '2', 'Q2'),

      IF(match(question_id, '3'), Replace(question_id, '3', 'Q3'),

      IF(match(question_id, '4'), Replace(question_id, '4', 'Q4'),

      IF(match(question_id, '5'), Replace(question_id, '5', 'Q5'),

      IF(match(question_id, '6'), Replace(question_id, '6', 'Q6'),

      IF(match(question_id, '7'), Replace(question_id, '7', 'Q7'),

      IF(match(question_id, '8'), Replace(question_id, '8', 'Q8'),

      IF(match(question_id, '9'), Replace(question_id, '9', 'Q9'),

      IF(match(question_id, '10'), Replace(question_id, '10', 'Q10'),question_id))))))))))

       

      To restrict the data to 10 bars i have used Limitation to "Fixed number".

      But it is displaying some other question id's from the table.

       

      Please see the image i have attached.finaltest.png

       

       

      Thanks,

      Pramod