Function Match()

[pgalvezt]

Hello, I have a table created like this:

Sect               Com1   Com2

Today               23        45

61-80 Days       12        45

3-5 Days          13         23

Sect is dimenssion Calculated like:

=if(aggr(sum(date(vDate)-Field1),Field2)= vDate, 'Today',

if(aggr(sum(date(vDate)-Field1),Field2)>=1 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=30, '3 - 5 Days',

if(aggr(sum(date(vDate)-Field1),Field2)>=31 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=60, 23-45 Days,

if(aggr(sum(date(vDate)-Field1),Field2)>=61 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=90, '61-90 Días'))))

I know the fuction Match() I can sorter like

Today

3-5 Days

61-80 Days

But How can should be when is dimenssion calculated?

Thank You!

[pgalvezt]

Any Help?

Thank You

[pgalvezt]

Any Help?

Thank You

[swuehl · Accepted solution]

You can create duals in your calculated dimension and then just sort by number:

=if(aggr(sum(date(vDate)-Field1),Field2)= vDate, dual('Today',1) ,

if(aggr(sum(date(vDate)-Field1),Field2)>=1 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=30, dual('3 - 5 Days',2),

if(aggr(sum(date(vDate)-Field1),Field2)>=31 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=60,dual(' 23-45 Days',3),

if(aggr(sum(date(vDate)-Field1),Field2)>=61 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=90, dual('61-90 Días',4)))))

Regards,

Stefan

P.S: This is a forum mostly run by volunteers, so you shouldn't expect an answer within minutes...

[pgalvezt]

Perfect!!

Thanks