Need Help

[qv_testing]

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...

[jonathandienst]

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.

[marcus_sommer]

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

[petter]

Is it something like this you are looking for:

[qv_testing]

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...

[qv_testing]

Please anyone help me.............

[petter]

More like this perhaps?

[qv_testing]

HI Petter,

PFA,

[petter]

What does the data in your table mean? What is Mtng_Time_Bucket and what is TIME_Bucket?

[petter · Accepted solution]

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: