Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Bobi
Partner - Contributor II
Partner - Contributor II

Sum values from different Max(dates) depending on Country.

Hi. I have accumulated data from a table and need to display the sum of the latest captured date.

Formula is like below:

sum({<Date={"$(=Max({<Transactions={'Orders}>}Date))"}>} Counter)

This works fine beside the fact that I have Countries with different Max-Date. Meaning if latest Data for Germany is 24 of march and French is 25 of March I will only capture French. I need to capture max(date) since it is accumulated data.

Is there any way I can solve this (get the maxdate depending on which country it is and then sum it up), tried some variants with aggr and so on but without solving it..

Labels (1)
1 Solution

Accepted Solutions
MadiF
Contributor III
Contributor III

@Bobi  Try adding this general logic to your load script, after the initial load of your table (which I here call 'Table1'):

 

Left join (Table 1) Load

     CountryField,

     max(DateField) as MaxDateByCountry

Resident Table1 Group by CountryField;

View solution in original post

1 Reply
MadiF
Contributor III
Contributor III

@Bobi  Try adding this general logic to your load script, after the initial load of your table (which I here call 'Table1'):

 

Left join (Table 1) Load

     CountryField,

     max(DateField) as MaxDateByCountry

Resident Table1 Group by CountryField;