Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

How to use date variable in set analysis

Hi,

I'm trying to use set analysis in a kpi formula.

I define the following variables:

vEndDate= max(enddate)

I have  to add this variable in below expression so that upon selection of  enddate the below measure expression value should also get change

count({<$(vEndDate),[flag]={'tag- 1','tag- 2','tag- 3','tag- 4',''},[tag]={'Extended Warranty','Service Contract'}
,[contract]={'Contract'}>}Business)

 

But it's giving me balnk value.

Labels (1)
1 Reply
Shubham_Deshmukh
Specialist
Specialist

Do you have any date filter? If selected date is max date then it should get apply, is it your requirement?