en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Guest  
#1 Posted : Wednesday, March 6, 2013 12:07:24 PM(UTC)
Guest
Rank: Guest

Groups: extranet\Forum
Joined: 3/9/2011(UTC)
Posts: 1

Hello Guys,

I'm fairly new to targit and totally new to this forum so thanks for reading my post.
Here is the issue i'm facing:
I've created a very simple bar chart to display the turnover for this year per month. Our turnover is segmented in 3 channels and stacked.
Now i would like to add a second measure with a comparison to last year.
The result should be per month 2 stacked bars with this year and previous year turnover. I can manage to create this without segmenting the turnover and just displaying the general turnover per bar, but as soon as i want to segment i get stuck. Is this even possible?

thanks for any usefull input.

regards,
Freek Rubens
Niels Thomsen  
#2 Posted : Wednesday, March 6, 2013 3:06:14 PM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 105

Hi!

If I understand you correctly I think it is possible using comparison elements.
This is an example which I've created in demo data: UserPostedImage

You would need a comparision with an element per bar.

Hope it makes sense.
Hope it makes sense.

Best Regards
Niels Thomsen

https://dk.linkedin.com/in/ncthomsen


Guest  
#3 Posted : Wednesday, March 6, 2013 3:13:52 PM(UTC)
Guest
Rank: Guest

Groups: extranet\Forum
Joined: 3/9/2011(UTC)
Posts: 1

Hello Niels,

Thanks for your reply. this is exactly what i need.
Is it possible for you to send me the design view of the analysis so i know where to put the comparisons?

Best regards,
Freek
Niels Thomsen  
#4 Posted : Thursday, March 7, 2013 8:16:34 AM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 105

This is the design view (the crosstab behind the barchart):
UserPostedImage

Notice on the left hand side you can see the design of the comparison on the vertical axis.
I just built 4 elements (January and February TY and LY). I guess you would need 24 elements - if you want to compare full years.
Hope it makes sense.

Best Regards
Niels Thomsen

https://dk.linkedin.com/in/ncthomsen


Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error