en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
John Swanson  
#1 Posted : Tuesday, August 6, 2013 9:31:22 PM(UTC)
John Swanson
Rank: Member

Groups: extranet\Customer
Joined: 3/8/2013(UTC)
Posts: 5

I have used Targit 2K11 for almost 1 year and are currently using it for this question.

I have a simple chart I wish to create. Time in Months across the bottom and Top 5 Customers on the side and Order Amount as a Measure. How can I accomplish this?

I can create a crosstab with time across the top and Top 5 sorted Customers on the side. When I change it to a line chart the time values are in the ledgend and a line for every month.

If I switch the axises, I cannot sort the customers across the top or get the Top 5.

Is there a method to get my chart?
Páll Bjarkason  
#2 Posted : Wednesday, August 7, 2013 10:52:04 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Customer
Joined: 1/13/2012(UTC)
Posts: 154

Hi John

Could you please take a look at this post and see if this solves your problem?
http://www.targit.com/en/youtargit?g=posts&t=221
Best regards

Páll, CTS
John Swanson  
#3 Posted : Thursday, August 8, 2013 9:49:01 PM(UTC)
John Swanson
Rank: Member

Groups: extranet\Customer
Joined: 3/8/2013(UTC)
Posts: 5

Thank you Páll for answering so quickly. I do not see how the example will help me, which is my lack of vision. I need the top 5 Customers as columns in the crosstab. I the only method is see is to create a Customer by Prior 12 Months crosstab, write down top 5, and return to my Top 5 Customers by Month and add a global criteria with the Customers I copied.

All of the crosstab manipulation is done on the vertical axis. How can I get around it?

John Swanson
Páll Bjarkason  
#4 Posted : Friday, August 9, 2013 10:01:17 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Customer
Joined: 1/13/2012(UTC)
Posts: 154

Hi John

I’m still not quite sure what you want to acheve, but here is my best guess.

1) Sort the table
2) Hide all members except the top 5 (You can see then visibility agent condition in the blue box on the top left hand side)
3) In the properties tab you can then change the object type from cross tabluation to (vertical) bar

UserPostedImage

Edited by user Friday, August 9, 2013 2:50:01 PM(UTC)  | Reason: New image

Best regards

Páll, CTS
John Swanson  
#5 Posted : Friday, August 9, 2013 5:27:05 PM(UTC)
John Swanson
Rank: Member

Groups: extranet\Customer
Joined: 3/8/2013(UTC)
Posts: 5

I finialy discovered how to download an image. I hope you can read this. Time on the X axes & Money on the Y axis. I did this by creating a Criteria with the 5 Customers.

Thanks again,
John

UserPostedImage
Niels Thomsen  
#6 Posted : Friday, August 16, 2013 2:00:32 PM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Customer
Joined: 4/5/2011(UTC)
Posts: 103

Hi John

There is a way to do this without applying criteria, however you are quite right that setting up a toplist on the horizontal axis is not possible using the built-in toplist tool in the TARGIT Client.

As I understand you your initial crosstab might look something like this:
UserPostedImage

Now I will add a calculated row with totals of each column:
UserPostedImage

And then 3 more calculations - each picking out the max value and transfering the rest of the values discarding this max value.

Top1:
UserPostedImage

Finds the max value in the total row (c1) and transfers this value as -1000000000 and the rest of the values unchanged

Top2:
UserPostedImage

Finds the max value of the transfered values (max will be the second highest value since we changed the original max value previously

Top3:
UserPostedImage

Repeats the trick...

Finally a visibility agent with this condition:
UserPostedImage

and this action:
UserPostedImage

...Which basically means hide everything but top 3.

Will get you this linechart:
UserPostedImage

You will also need to go into properties - visibilty and hide your calculations.

Hope it makes sense.


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