Skip to Content
avatar image
Former Member

Dimension for a bar chart

Hi all,

I have got a dimension Categories with values A, B, C and D and I need to show in the categories axis of a bar chart the values: A, B, C, D, A+B, C+D.

Could I create a new dimension which contains A, B, C, D and two new values A+B and C+D?

Thanks,

Jonás

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 12, 2016 at 01:59 AM

    Former Member

    Well, Is it possible without creating additional Queries. Yes. Is it a neat approach, may be not 😊

    See the steps below. The approach works best when you have minimum number of categories.


    1.jpg (94.5 kB)
    2.jpg (103.7 kB)
    3.jpg (248.9 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2016 at 09:09 AM

    Hi,

    Can you give some sample data and the output required

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You can try having multiple queries one for individual values and 2 more for your aggregated values. merge dimensions from all these queries and use in the report.

      there are some workarounds people suggests like having like overlapping charts one for individual values and one for summarized values.

      but all these are workarounds using formatting not straightaway solutions.

      So choose the one optimum for you

      refer Stacked chart with totals