Line chart between two dates

[razvan_brais]

Hy guys.

I would like to create a line chart for a KPI that shows values between two dates.
Those dates are the first day of the month selected and the selected date.

I have tried something like this but it didn`t work

Sum({<DATE={">=$(vMonthStartCS)<=DATE"}>}VALUE/Divider)

vMonthStartCS = date(monthstart(date(DATE,'DD-MM-YY')),'DD-MM-YY')

Do you have other suggestions?

Please help.

Thank you

[sunny_talwar · Accepted solution]

Try this

Sum({<DATE={"$(='>=' & Date(MonthStart(Max(DATE)), 'DD-MM-YY') & '<=' & Date(Max(DATE), 'DD-MM-YY'))"}>} VALUE/Divider)

[razvan_brais]

Thank a lot , this is what I needed.