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

[Tessa Tuteleers]

Hi @Ann-marie Dillon , 

...  AND created > 2020-07-01 AND created < 2020-09-30 AND ...

in your JQL should work. Could you show the JQL you tried that gave an error? 

Tessa

[Tessa Tuteleers]

@Jack Brickey beat me to it :D 

[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"

[Jack Brickey]

BTW... you should use ">=" in the first created if you wish to include 7/1

[Ann-marie Dillon]

Hi Jack,

Thank you for help with this issue. It's worked!