Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Thank you for your time in answering this question. I want to create an object (not doing it in script) that has a dimension that groups the Date field in certain values (like the Range and SumValue field at the bottom of image 1). How can I accomplish this?
Kind regards.
Hi Julio,
You get this straight table with the calculated dimension Range =
=Aggr(Pick(Match(Date,
'01/07/2017',
'02/07/2017',
'03/07/2017',
'04/07/2017',
'05/07/2017'),
'R1','R1','R2','R2','R2'),Date)
Range | Sum(Value) |
---|---|
65 | |
R1 | 24 |
R2 | 41 |
Regards
Andrew
May be this?
Create Straight Table and use
Dimension
=ValueList('R1','R2')
Expression
If(ValueList('R1','R2')='R1',sum({<Date = {'01/07/2017','02/07/2017'}>}Value),
If(ValueList('R1','R2')='R2',sum({<Date = {'03/07/2017','04/07/2017', '05/07/2017'}>}Value)))
Hi Julio,
You get this straight table with the calculated dimension Range =
=Aggr(Pick(Match(Date,
'01/07/2017',
'02/07/2017',
'03/07/2017',
'04/07/2017',
'05/07/2017'),
'R1','R1','R2','R2','R2'),Date)
Range | Sum(Value) |
---|---|
65 | |
R1 | 24 |
R2 | 41 |
Regards
Andrew
Hello Julio,
Try this ,
dimension:
If(Date=makedate(2017,07,01) or Date=makedate(2017,07,02) ,'R1','R2')
Expression:
Sum(Value)
OR
Dimension:
If(Date=makedate(2017,07,01) or Date=makedate(2017,07,02) ,'R1',
if(Date=makedate(2017,07,03) or Date=makedate(2017,07,04) or Date=makedate(2017,07,05),'R2'))
Hope this help!