4 Replies Latest reply on Aug 28, 2018 1:58 AM by meenu choudhary

# How to make this table ?  Sentence in days

 2017 2018 Group Sentence in days 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 Goods 0-30d 29.39 154.970 100.548 28.229 66.744 31.265 19.407 201.413 104.443 55.854 96.100 86.508 270 307.397 305.116 31-60d 44.047 14.233 55.460 77.892 18.241 23.589 7.159 1.335 79.642 29.933 9.860 30.848 21.025 0 305.211 61-90d 22.353 13.162 1.577 39.831 17.709 9.229 4.452 4.032 0 29.394 70 8.299 9.048 0 0 91-180d 22.629 38.889 2.046 3.180 14.984 24.075 17.345 7.378 2.544 2.171 891 0 642 0 0 181-360d 0 0 0 0 961 634 0 4.891 4.477 2.720 2.266 3.157 0 0 0 more 360d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Sum of Sales 118.418 221.254 159.631 149.133 118.639 88.792 48.362 219.048 191.106 120.073 109.187 128.812 30.985 307.397 610.327
• ###### 1. Re: How to make this table ?  Sentence in days

It would be nice if you can share the underlying data.

• ###### 3. Re: How to make this table ?  Sentence in days

How make this 60 days ?

• ###### 4. Re: How to make this table ?  Sentence in days

You can create group based on below logic:

index = DATEDIFF('day', DATETRUNC('year', [Order Date]), [Order Date] )

Convert it to discrete measure.

Group =

if [index]>0 and [index]<=30 then "0-30D"

ELSEIF [index]>30 and [index]<=60 then "31-60D"

ELSEIF [index]>60 and [index]<=90 then "61-90D"

ELSEIF [index]>90 and [index]<=180 then "91-180D"

ELSEIF [index]>180 and [index]<=360 then "181-360D"

ELSEIF [index]>360 then " more 360D"

END

convert to discrete measure.