how to create two conditions in set analysis expression for bar chart

[#1]

Hi i have two conditions in set analysis

first one - to filter not fixed first time records

second one - to get last 3 months of data in a data load which has last 12 months of data .

the last image i am using expression to filter "not fixed first time" , but i also need to filter last 3 months in this expression now.

thanks in advance

[Gysbert_Wassenaar]

You can use the + operator to AND two set modifiers. Something like count({<B={'abcd'}>+<MyDate={'>=$(=floor(addmonths(max(MyDate),-3)))'}>}A).

[rubenmarin · Accepted solution]

Hi Aditya, you can use:

Count({<[dfft_Fix Time]={'Not fixed first time'}, [dfft_Closing Date]={'>=$(=MonthStart(Max({1} [dfft_Closing Date]), -3))'}>} [dfft_Enterprise System]) / Count({<[dfft_Closing Date]={'>=$(=MonthStart(Max({1} [dfft_Closing Date]), -3))'}>} [dfft_Enterprise System])

This will return data since 01/11/2014, if you want data since 16/11/2014 you can use:

Count({<[dfft_Fix Time]={'Not fixed first time'}, [dfft_Closing Date]={'>=$(=Floor(AddMonths(Max({1} [dfft_Closing Date]), -3)))'}>} [dfft_Enterprise System]) / Count({<[dfft_Closing Date]={'>=$(=Floor(AddMonths(Max({1} [dfft_Closing Date]), -3)))'}>} [dfft_Enterprise System])