MAX COLLECT with IF?

LJK

Hi everyone

I would like to feed a graph as follows:

Please show me the last 5 days in the yellow assigned cells in sequence of date, that had a value in column 1, so I can display the value in a graph.

Any suggestions?

Mike TV

@LJK

Are you building your graph off of a report or a sheet? If you're using a sheet, you should build a report from that sheet and in the filters of the report you can specify to only include results with greater than 0 in any specific column.

LJK

to clarify I want to exclude the ones that show 0

Mike TV

@LJK

Are you building your graph off of a report or a sheet? If you're using a sheet, you should build a report from that sheet and in the filters of the report you can specify to only include results with greater than 0 in any specific column.