2 Replies Latest reply: May 5, 2015 12:19 AM by Steven Tan

# The chart can't display the data

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;

• ###### Re: The chart can't display the data

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

• ###### Re: The chart can't display the data

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

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