Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to create a Table in that
Dim: Workflow name, Sessionname
Measurea (Duration) : =Sum({<Duration = {">20"},Date={"$(=Date(Today()-3,'MM/DD/YYYY'))"}>}Duration)
Sum({<Duration = {">20"},Date={"$(=Date(Today()-2,'MM/DD/YYYY'))"}>}Duration)
Sum({<Duration = {">20"},Date={"$(=Date(Today(),'MM/DD/YYYY'))"}>}Duration)
displaying data for current and previous day and day before yesterday
but i am getting Zero(0) values for some columns
Please see below screenshots for reference
Need Out put like below
Kindly Can any one suggest how can i get this output.
Thanks,
Rajesh.
You can write your expressions like:
If(RangeMin(Exp1, Exp2, Exp3)>0, Exp1)
If(RangeMin(Exp1, Exp2, Exp3)>0, Exp2)
If(RangeMin(Exp1, Exp2, Exp3)>0, Exp3)
You can write your expressions like:
If(RangeMin(Exp1, Exp2, Exp3)>0, Exp1)
If(RangeMin(Exp1, Exp2, Exp3)>0, Exp2)
If(RangeMin(Exp1, Exp2, Exp3)>0, Exp3)
Thanks for reply Tresesco,
But my requirement is changed
Can you look in to another below thread for that.
Regards
Rajesh
Thank you Tresesco,
Can you look into mentioned another thread.
Regards
Rajesh