How to get chart with measure by two dates from one table

[Anonymous]

Hello,

     I have one table where is ticket id, receive_date, resolve_date. Now i want to make chart with

          X axis - period date from master calendar.

          Y axis -      1 line count of receive tickets

                            2 line count of resolve tickets

     How i can achieve it?

[sunny_talwar]

Look into creating a Canonical Date

[zebhashmi]

i don't think it will help but maybe you can find some way from it

if(ValueList('A','B','C')='A',Count({<rdate={'01/01/2018'}>}rdate),if(ValueList('A','B','C')='B',Count({<rdate={'01/15/2018'}>}rdate),Count({<rdate={'01/30/2018'}>}rdate)))