Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
=Max({<week=>}Aggr(Sum({<week = {$(=Max(week) - 1)}>} peak flow rate), time, total business));
{<week=>},I am so careless;
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
=Max({<week=>}Aggr(Sum({<week = {$(=Max(week) - 1)}>} peak flow rate), time, total business));
{<week=>},I am so careless;