Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The following Set Analysis works.
Sum( {$<[login pass Last Access]={'Feb-17'}>} [login pass Total])
However, I create a variable for field [login pass Last Access] as vLoginPass,
when using the following Set Analysis with the above variable, not working any more
Sum( {$<[login pass Last Access]= {'$(=vLoginPass)'} >} [login pass Total]) , not working
Sum( {$<[login pass Last Access]= {'$(vLoginPass)'} >} [login pass Total]) , not working
Any suggestion is appreciated!
Hi Haikou
Maybe so
Sum( {$<[login pass Last Access]= {$(vLoginPass)} >} [login pass Total]) or
Sum( {$<[login pass Last Access]= {$(#vLoginPass)} >} [login pass Total])
Regards,
Andrey
Try
Sum( {$<[login pass Last Access]= {"=$(vLoginPass)"} >} [login pass Total])
Or
Sum( {$<[login pass Last Access]= {'$(vLoginPass)'} >} [login pass Total])
or
Sum( {$<[login pass Last Access]= {$(vLoginPass)} >} [login pass Total])
Variable in script
Set vLoginPass='Feb-17';
Expression
Sum( {$<[login pass Last Access]= {'$(vLoginPass)'} >} [login pass Total])
hth
Sasi
I doubt, Whether you have same format of index / Search / Selectors in your file list for [login pass Last Access]
Can you let us know the format of mentioned Values
create variable as vLoginpass=Feb-17
sum({<[login pass Last Access]={$(vLoginPass)}>}[login pass Total]))
i just want to know are you taking Feb-17 from any field or it is static.
if it is dynamic and you are taking the max i.e Feb-17 from the field then you must write
vLoginPass=max(mention the field from where Feb-17 is coming) and then use it in the above mentioned set analysis.