expression to sync with calendar.

[riishabhz]

first image is of my dashboard

second image is of barchart on store wise and its sync with calendar with expression as =Sum({<SalesDate={'>=$(=Date(start))<=$(=Date(end))'}>}RealisedSale)/100000

third image is of barchart with discount but its expression is  =(InvoiceQuantity)*Replace(ETPMRP,'-','')-(RealisedSale) but i dont know how to sync with calendar.

please help me.

thanx

[Arthur_Fong]

Hi,

Does the budget data has date column?

Thanks and regards,

Arthur Fong

[riishabhz · Accepted solution]

its fixed now by this expression.

=Sum({<SalesDate={'>=$(=Date(start))<=$(=Date(end))'}>}RealisedSale)/100000