Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am trying to get count of using below expression
count({<[Date Closed] > $(VInputDate)> , <Status={'Closed'}>, <Severity= {'High'}>} Status)
The above expression was working fine without the date comparison "[Date Closed] > $(VInputDate)"
Date Closed is the database filed which has random dates and VinputDate is a variable which changes dynamically. I know this is simple but am struggle to get the total count of the status which Vinputdate is < Date closed.
It would be great if some one could help
Thanks
Goutham
Message was edited by: Goutham Kandukuri
try something like:
count({<[Date Closed] = {"> $(=VInputDate)"} , Status={'Closed'}, Severity= {'High'}} Status)
or
count({<[Date Closed] > {"$(=VInputDate)"} , Status={'Closed'}, Severity= {'High'}} Status)
Hello Goutham,
try if it helps:
Count({< [Date Closed] = {">$(VInputDate)"}, Status = {'Closed'}, Severity = {'High'} >} Status)
Greetings
Michael
Hi,
sorry it is not working, i am getting black values, Do i need to use total or aggr function since i am using this as expression in chart table.
try below
count({<[Date Closed] = {"> $(=VInputDate)"} , Status={'Closed'}, Severity= {'High'} >} Status)
Vinay
depends on how your setup is. count returns one value. so if you are trying to use it as a dimension, then you need aggr.
if it is an expression, it will depend on your dimensions in the straight table...can you take screenshots or upload your file with sample data?
ps: just fyi, use advanced editor on the top right side of this reply textbox to attach files. (link to attach will be at the bottom right corner of your reply box in advanced editor mode)
Hi I just added the table chart
Should be:
count({<[Date Closed] = {'>$(=VInputDate)'} , Status={'Closed'}, Severity= {'High'}>} Status)
like is stated in previous posts. I'm interested in the formula for VInputDate. How are you calculating this? Does this change for each [Date Closed]?
It might be that set analysis might not work in your situation, and must add an if statement.
Hope this helps!
Hi,
I tried you expression, i am getting all values 0
VInputdate is an Input variable entered randomly, but i did check the date formats, they are right