DataSet - formula count

Hello,

I have a dataset with 2 columns:

  • dtLastIncident : a date
  • dSinceLast : a formula that count the days between CURRENT_DATE and dtLastIncident

This was created from a tutorial and work great. I can see all the rows that I have created and sort them to display the data in template.

I want to add the number of incident since the beginning of current year and maybe total number of incident, so I created 2 others columns:

  • dCountInYear : COUNT(CASE WHEN YEAR(dtLastIncident)=YEAR(CURRENT_DATE) THEN 1 ELSE NULL END)
  • dCountTotal: COUNT(*)

But with these columns (or one of these), the columns are right calculated, but the dataset is only showing the first row. When I add a row, I can only see the counts update, but still one row with dtLastIncident and dSinceLast of the first row. If I remove these columns, I can see all the rows, even the rows created with actives count columns.

Since column dSinceLast is a formula, it is not a problem with formula column, but is there a problem with count statement in a formula column?

Before column creation:
image

After column creation:
image

After adding a new row:
image

After removing the count columns:

Thanks in advance

CMS Version

4.2.3

Player Type

Android players