Date range in set expression

[yoganantha321]

Hi all,

I have a column called month_date with list of dates which report should be generated and another column called report date which contains the date on which the reports are generated.

My expected output:

If i select a particular Report_Dates, the month_date less than the report_dates must be viewed in the bar chart.

Output I am getting:

Now, If i select  a particular date that particular date's bar is showing.

Anybody can help in this!!!!!

Regards,

Yoganantha Prakash G P  

[sunny_talwar · Accepted solution]

Try using these expressions

Only({<Report_Dates = {"<=$(=Max(Report_Dates))"}>}[Assessment Goal Curve])

and

Only({<Report_Dates = {"<=$(=Max(Report_Dates))"}>}Total_Compliance)

[yoganantha321]

Thanks Sunny.