Limit data in graph to last date

[stekol61]

Hi!

In the enclosed report I have data for around the previous 30 days.

I have on line graph that should show data for every date.

The other graph should only show data for the previous day.

How to do this?

/Stefan

[Gysbert_Wassenaar]

Which other graph? The bar chart?

[stekol61]

Hi!

Yes, the bar chart on Sheet1

/Stefan

[vinieme12]

add the following Set to all your expressions

Sum ( {<Date = {"$(=DATE(Max(Date)-1,'YYYY-MM-DD'))"}>}lat_dis_0_10_ms)

[vinieme12]

or use the following calculated Dimension

= if(num(Date) = Max( TOTAL Date)-1 ,Date,null())

and check Supress when value is null for this dimension

[stekol61]

Hi!

This solved the problem.

Thank You

/Stefan