Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one requirement..
I have 3 bucket in my table,
Field1 Field2 Field3
0-10 - 0-10
10-20 10-20 10-20
20-30 20-30 20-30
30-40 - 30-40
- 40-50 -
- 50-60 -
I want to show bucket wise count in Stacked bars...
Suppose i have 0-10 i want show in stacked bar only related 0-10 for three fields count(Field1, Field2 and Field3).
My X-Axis should be 0-10, 10-20, 20-30, 30-40,40-50,50-60
and stacked BAR (Suppose 0-10, here i have to show only Filed1 and Field3 count in my Bar.. because Field2 0-10 i don't have in my bucket )
My output should be like this...and so on .... like 30-40,40-50,50-60
Thanks in Advance...
I think I finally got it ... have a look:
Had do do a CROSSTABLE(....) LOAD to get the data in a table format that would work for me:
I have no idea what you are trying to do. I suggest that you post a sample qvw with representative data and more detail about exactly what you want to create. Screenshots are of very limited value.
I think you will rather need another data-structure which looks like:
ClusterSize Amount
0-10 n
0-10 n
10-20 n
....
transformed per crosstable-load: The Crosstable Load
- Marcus
Is it something like this you are looking for:
Hi Petter,
I am sorry, I am confusing with how to explain my requirement..
Example:
I have one table, 2 buckets.
Like Bucket1 and Bucket2
Suppose Bucket1=0-10, 10-20, 30-40
Bucket2=10-20,20-30,30-40,50-60
Now, Barchart dimension should be in X-Axis
i want to show 0-10,10-20,20-30,30-40,50-60
I want to show Stacked bar..
Suppose 0-10 bar i want to show count only (0-10 Bucket1 count and 0-10 Bucket2 count)
Now Hope you Understand...
Please anyone help me.............
More like this perhaps?
HI Petter,
PFA,
What does the data in your table mean? What is Mtng_Time_Bucket and what is TIME_Bucket?
I think I finally got it ... have a look:
Had do do a CROSSTABLE(....) LOAD to get the data in a table format that would work for me: