1. TARGIT Community
  2. Community
  3. Frontend, Designer and Consumer

Percentage shown in line chart

Avatar
Michael Skals

I have this cross table with turnover per month in different groups. I have added a calculation showing the percentage of each group per month.

I want a line chart showing the percentages.for each month, so 1 line for excel, 1 for WEB etc, but when I try to make the chart this happens: 

Apparently with the months on the wrong axis.

I tried switching the Time measure to the right axis, but then the result is this

It looks right at first, but is not. Now the percentage calculation is spread across the months for each group, ie. total for excel is 100% from January to October. I guess this happens because I switched the measures on the axes....

How do I do this correct?

0

Comments

2 comments
Sort by Date Votes
  • Avatar
    Ole Dyring

    Hi Michael,

    I presume you used the predefined 'Percentage' calculation...?

    The syntax of that calculation is this:

    Val:(sum(0, 0, m1)) % if T:(sum(0, all, m1, 0)) <> 0 then T else if Val <> 0 then Val else 1

    You might try to change the syntax to this:

    Val:(sum(0, 0, m1)) % if T:(sum(all, 0, m1, 0)) <> 0 then T else if Val <> 0 then Val else 1

    BR / Ole

    0
  • Avatar
    Michael Skals

    Hi Ole

    That was all I needed. Thank you!

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post