Count number of records before date selected

[julruiz123]

Hi!

In the image there's a master calendar and a detail table, what I need is once a date is selected, it shows a chart with the number of records that have an earlier date.

Thanks!

[jagan · Accepted solution]

Hi,

Use the expression in straight table and hide this expression column in Presentation tab.

=Sum({<DateFieldName = {'<=$(=Max(DateFieldName))'}>} ColumnName)

Hope this helps you.

Regards,

Jagan.