The chart can't display the data

[#1]

Hi~Guys:

This week expression = Max (aggr (sum ({< week = {$(= Max (week))} >} peak flow rate), time, total business)), there is data display;

Last week the expression = Max (aggr (sum ({< week = {$(= Max (week) - 1)} >} peak flow rate), time, total business)), suggests that unable to display the data;The problem how to solve;

Only one table data source, and extract data every day, week this field according to the time field points out;Inside the expression means: find out this week maximum peak flow rate;

[sunny_talwar]

Try this may be:

=Max(Aggr(Sum({<week = {"$(=Max(week))"}>} peak flow rate), time, total business)) and

=Max(Aggr(Sum({<week = {"$(=Max(week) - 1)"}>} peak flow rate), time, total business))

Best,

Sunny

[#3 · Accepted solution]

=Max({<week=>}Aggr(Sum({<week = {$(=Max(week) - 1)}>} peak flow rate), time, total business));

{<week=>},I  am so careless;