Creating a dashboard

Ann-marie Dillon

I want to create a pie chart for issues reported from 2020/07/01 to 2020/09/30 and using filters. The following work formula works, but when i try to add an end date it says there's an error.

project = TRK AND created > 2020-07-01 AND "Issue Jurisdiction[Select List (multiple choices)]" = MiFID AND issuetype = "Client Assets"

Could you please tell me how to add an end date?

 

Thanks

Jack Brickey

try this...

project = TRK AND created > 2020-07-01 and created <= 2020-09-30 AND "Issue Jurisdiction[Select List (multiple choices)]" = MiFID AND issuetype = "Client Assets"