Bucket wise trending

[sridhar_sigired]

Hello,

I have day wise call length (in seconds) data with different call types.

I need to show day wise average call length for call type wise, which is available in attachment.

However i need to show same trend information bucket wise. Buckets are created in sample QVW. The requirements looks like in requirement.png snapshot.

Since line chart will accept only two dimension, i am confused how to include bucket information. Any suggestions pls?

Thanks alot.

Sridhar. S

[Anonymous]

Nothing in your attachment, also what exactly you want??

what issue you are facing?

You want to show Bucket wise Trend?

[Anonymous]

check these as well?

Buckets

Creating Aging Buckets within QlikView

Creating Buckets in the Load Script

[sridhar_sigired]

Attached reloaded QVW. Sorry for inconvenience.

There are two charts i need to create.

1. Trend - Average call time in minutes call type wise

2. Trend - Average call time in minutes call type wise in bucket size.

First one is available in QVW and second one how it looks like available in requirement jpg.

Just need a idea how can we show this information. Since date also need to show in dimension, i am confused how i have to show bucket information.

[Anonymous]

Which one is your Bucket field??

[Anonymous]

Why not try with Grid Chart??

You can plot Date as X axis and Bucket as Y Axis and then expression for same

[sridhar_sigired]

Cal_Duration_Range is my bucket field. Pls see script once. Grid chart i cannot show trend na.

[settu_periasamy]

May be like this?

[sridhar_sigired]

Look slimier, can you post your QVW file. Thanks.

[Anonymous]

Okay, I would suggest Keep your dimensions fields as it is...

Write 5 expression for this bucket in expression tab instead of your current expression...

Like :

For 5 : sum({<Call_Duration_Range={'5'}>} duration)

similarly for other values