Group filter?

[Anonymous]

Hi,

I have a field called days, that count the number of days passed since the beginning of the request to the end.

I need to create a group filter, this is what I did:

- have a field expression with

=If (Days <=30, '1 to 30 Days',
If (Days >90,'90 + Days',
If (Days >60, '60 + Days',
If (Days>45, '45 + Days',
If (Days>30, '30 + Days')))))

The problem is that when you select '45 + Days' should include '60 + Days' and '90 + Days', or if I select '60' should include 90, and 30 should include 45, 60 and 90.

Can you please help me to do this?

[sunny_talwar]

Seems like you are looking to get accumulation of your expression? Is that right? If it is, then use RangeSum(Above()) or use Full accumulation in your chart

[vinieme12]

Try with IntervalMatch()

Days:

Load * inline [

Days

10

11

20

25

30

45

50

51

59

61

65

68

70

71

72

80

82

85

89

90

100

];

Intervals:

Load * Inline [

FromDay,ToDay,DayGroup

0,29,<30

30,1000,>30

45,1000,>45

90,1000,>90

];

IntervalMatch:

IntervalMatch (Days)

Load distinct FromDay, ToDay resident Intervals;

[Anonymous]

How can I use that in an easy expression as what I did before?

[sunny_talwar]

Not sure I understand your comment?

[Anonymous]

I need the accumulation, how can I use the RangeSum in my expression?