I have created two dropdown list
1. start date
2. end date
I am using MySQL database as a source and I have a table called generation
having columns like (date , generation, turbine_id
).
After selecting the start date
and end date
, I need to sum the corresponding values that lie between the two dates:
sum({<Date= {"<=$(=vStartDate)>=$(=vEndDate)"}> } Target)