Regarding the filtering, there's ongoing work for generalizing filters and bringing more capability for Canvas, for an upcoming release. In the meantime, filtering could be done with Canvas Functions which used to be here, due to bringing Canvas into the Kibana repository this link seems not to go to the proper place but there are some examples. Using a SQL subset is another option, some examples are here.