Summarize data

[Anonymous]

Hi, I need output from my table like mentioned in the image. Kindly help me to get the solution.

[santiagomur · Accepted solution]

hi, 

try creating 3 calculate column.

30 days=if(datediff(today();I-94 Valid To;DAY)>30&&datediff(today();I-94 Valid To;DAY)<=180;1;0)

180 days=if(datediff(today();I-94 Valid To;DAY)>180&&datediff(today();I-94 Valid To;DAY)<=230;1;0)

230days=if(datediff(today();I-94 Valid To;day)>230;1;0)

I don't know the structure of your table, but this can give you an idea of ​​what to do.