Cyclic in Bar Graph

[bohravanraj]

Dear Folk,

I am Facing a issue in creating a Bar Chart with Cyclic Expression, where there is no problem with showing month wise data, but when user want to see Quarter wise data in Bar graph then graph should show the data of Maximum of month(for example for Q1 it should show March Data,for Q2 it should Show Jun Data, And so on) similaly for Year wise it should show Dec Data in Cyclic Dimension.

Pleas see The following Excel for more Under Standing.

Year	Quarter	Month	Value
2014	Q1	jan	100
		feb	124
		mar	148
	Q2	apr	172
		may	196
		jun	220
	Q3	july	244
		aug	268
		sep	292
	Q4	oct	316
		nov	340
		dec	364

  Please See anybody can Help.

Thanx

[sunny_talwar]

You can use a if statement for expressions. Something like this:

If(GetCurrentField(Cycle_Group) = 'Month', expression1, If(GetCurrentField(Cycle_Group) = 'Quarter', expression2...and so on

HTH

Best,

S

[bohravanraj]

Dear Sunindia,

Thanks for immediate reply, Can you please send a small application of it, it would really be very helpfull

Thanks

[sunny_talwar]

PFA the sample application.

Best,

S

[bohravanraj]

But here how it is possible to find the value for Maximum of month

[sunny_talwar]

Oh you want to get the max value of the month. Let me fix my expression and get back to you.

Best,

S

[Anonymous]

Hi find attached app .

if(GetCurrentField(Group)='Year',sum({<Month={'dec'}>}Value),if(GetCurrentField(Group)='Quarter',sum({<Month={'mar','jun','sep','dec'}>}Value),Value))

[bohravanraj]

Here User want the value of Last Month

[sunny_talwar]

Here you go. See if this is what you want.

Best,

S

[nikhilgarg]

Hey,

tried small example with year hardcoded 2014. In DImension i put Quarter , Month and in expression as:

Sum({<Year = {'2014'} , Month = {"=aggr(Max(Month), Quarter)"}>}Value)

It is giving em values for 1st month of Q1 and 1st month of Q2.

cAn anybody tell me why is it so when i have used Max(Month) ??

Thanks