7 Replies Latest reply: Jun 22, 2015 11:39 AM by Mark Graham

Grouping dimensions in Chart table

Hi,

I'm trying to group SKU, SUm(Units Packed), and Count(Locations) by Warehouse.

Aggr(Count(Distinct(SKU#)), [Warehouse])

Aggr(Sum([Units Packed]), [Warehouse])

Aggr(Count(LBCD), [Warehouse])

I'm not sure, whether this is right.

On the other hand, i'm trying to group SKU, SUm(Units Packed), and Count(Locations) by Warehouse

whose 360-day velocity Weeks on Hand is less than 8 and greater than 0.

If(\$(v360-day Velocity WOH)>=0 and \$(v360-day Velocity WOH)<=8, Aggr(Count(DISTINCT(SKU#)), Warehouse))

If(\$(v360-day Velocity WOH)>=0 and \$(v360-day Velocity WOH)<=8, Aggr(Sum([Sum of Units packed in recent 30 days]), Warehouse))

If(\$(v360-day Velocity WOH)>=0 and \$(v360-day Velocity WOH)<=8, Aggr(Count(LBCD),Warehouse))

Please lemme knw the expressions accuracy.

• Re: Grouping dimensions in Chart table

Is v360-day Velocity WOH a field name or is it a variable? It seems like a field to me, is that true?

• Re: Grouping dimensions in Chart table

Hi Sunny,

Its a variable.

v360-day Velocity WOH=(Sum([Qty On Hand])/([360-day Velocity]/52))

• Re: Grouping dimensions in Chart table

Its difficult to imagine what you are trying to do before looking at an example? Do you have a sample we can look at?

• Re: Grouping dimensions in Chart table

I'm trying to use the above conditions.

I wanna check with you guys, whether the condition syntax is fine.

Regarding the sample, its around 2 GB file and hence its difficult to upload.

• Re: Grouping dimensions in Chart table

If the output you are getting is what you expect to see, I don't see a reason why you would think that the syntax is incorrect. Are you seeing any discrepancies in the results you are seeing? Make some filters and check it against your database to make sure that you are getting what you expect to see.

Best,

Sunny

• Re: Grouping dimensions in Chart table

Hi Sunny,

Can i please know the SET Analysis expression for the expresison:

If(\$(v360-day Velocity WOH)>=0 and \$(v360-day Velocity WOH)<=8, Aggr(Count(DISTINCT(SKU#)), Warehouse))

• Re: Grouping dimensions in Chart table

by using aggr() is used for this requirement for group the column list,,it works like a group By clause in SQL