Last 4 weeks data in bar chart

[#1]

Hi all,

I need to display weekly count bars for client specific.

Each bar for one week so i need to display total 16 bars 4 for one client.

I have attached the sample .qvf anyone help on this.

Thanks,

Kumar

[#2]

no semi colon is there,i have copied the same line below.

any how i got the count but now, i am struggling to get the  custom colour can you help on it.

Dimension:

1. ValueList('15','12','13','19','6')

2. Week_group

Measure:

if(ValueList('15','12','13','19','6')='15',

count({<weekstart={">=$(=date(max(weekstart)-35))<$(=date(max(weekstart)-7))"},DateType={'invitation'},client_id={'15'}>}invitation_id),

if(ValueList('15','12','13','19','6')='12',

count({<weekstart={">=$(=date(max(weekstart)-35))<$(=date(max(weekstart)-7))"},DateType={'invitation'},client_name={'12'}>}invitation_id),

if(ValueList('15','12','13','19','6')='13',

count({<weekstart={">=$(=date(max(weekstart)-35))<$(=date(max(weekstart)-7))"},DateType={'invitation'},client_name={'13'}>}invitation_id),

if(ValueList('15','12','13','19','6')='19',

count({<weekstart={">=$(=date(max(weekstart)-35))<$(=date(max(weekstart)-7))"},DateType={'invitation'},client_name={'19'}>}invitation_id),

if(ValueList('15','12','13','19','6')='6',

count({<weekstart={">=$(=date(max(weekstart)-35))<$(=date(max(weekstart)-7))"},DateType={'invitation'},client_name={'6'}>}invitation_id))))))

As data is confidential i have added the sample data, and i am working on server.

The data i working and attached is same but not original data.

Please help how can i add custom colour for above expression?

[reddy-s]

Hi Pramod,

pick your rgb code from Color Picker - ColorPicker.com

Use this to colour code:(as colour expression)

if( ValueList('15','12','13,'19','6') = '15', RGB(r,g,b),

if( ValueList('15','12','13,'19','6') = '12', RGB(r,g,b),

if( ValueList('15','12','13,'19','6') = '13', RGB(r,g,b),

if( ValueList('15','12','13,'19','6') = '19', RGB(r,g,b),

if( ValueList('15','12','13,'19','6') = '6', RGB(r,g,b)

)))))

[#4]

I think this for client, i need the colors for week...

[Anonymous · Accepted solution]

Hii,

PFA the resulted output.

Hope this is what you required.

Thanks,

Vignesh

[#6]

Hi vignesh,

That's fine.

As you are taking the max of week it is displaying the data of last year because the week number of 2015 is less than 2014.

Can you please check with it

[Anonymous]

Hi

Yes irrespective of any years i have considered. So it will take the maximum week data.

If required , mention the specific year in set analysis.

Regards,

Vignesh