SUM of a value within a max date range

[McCloudPT]

Hello all

I'm currently struggling to get a final SUM value of a given max date, when we select a date range with Date Picker.

I have values per day that I want to show in a Map, but the sum adds the values from all days in the date range.

I need to show the sum of one day only. I can choose the max day of a range with: "Date(Max(Floor(DateDay), 1)) " but the final expression does not provide me the values I need.

Not working: =sum({<TvPlatform = {'VTV'},DateDay={'=$(Date(Max(Floor(DateDay),1)))'}>} Value)

[McCloudPT · Accepted solution]

Since the set analysis was not cooperating, one of my colleagues found a weird but working solution:

=Sum({<TvPlatform = {'VTV'}>}Value * if(DateDay=RangeMin('$(=date(max(aggr(nodistinct max(DateDay), Distrito))))',Today()-1),1,0))

Every date but the max one is discarded by the * if expression!