Grouping dimensions in Chart table

[markgraham123]

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.

[sunny_talwar]

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

[markgraham123]

Hi Sunny,

Its a variable.

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

[sunny_talwar]

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

[pratap6699]

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

[markgraham123]

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.

[sunny_talwar]

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

[markgraham123]

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