Error while fetching larger amount of data

Hello All,

I'm having a column chart report with View as a source. My base table has more than 1.5 Lakh rows and query entity is failing at Appian end.

First time when I'm loading the report, I'm trying to show only current month completed records. 

View:

select Type, ID, Status, System from Table T where system= "xyz" group by ID, Status

View taking 11 seconds to return 1.18 L rows from the base table.

Please suggest.

Thanks in advance.