Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have one simple Requirement. But any how i am not able to do. kinldy Help me to resolve this.
I want to Put One Check Box On Screen.. so If Cust Select Today it get select to Max(Date) and
if Yesterday so Max(Date)-1. and Dashboad will show data based on the selection ..
I am Trying with Inline but .. Its not Happening.... Kindly Help me ...
I suggest you define a new field in the script, e.g.
If(Date=Today(), 'Today',
If(Date=Today()-1, 'Yesterday', 'Older')) as MyDate
Then the user can click in this new field and the behaviour will be exactly what you describe.
HIC
Would you be able to share of what you have? It would help understand what you are trying to do.
I suggest you define a new field in the script, e.g.
If(Date=Today(), 'Today',
If(Date=Today()-1, 'Yesterday', 'Older')) as MyDate
Then the user can click in this new field and the behaviour will be exactly what you describe.
HIC
Create the listbox, select one of the two values and then go to Properties > Always one Value Selected.
From there a simple set analysis (or if clause if you dont care about performance) will do the trick on your expressions.
Thanks for Ur Reply Henric and Sunny,
I Want Today as My Max(Date) and Yesterday as Max(Date)-1 .....
I have a Date as Field in my Master Calander . So when i select Today in List ...in Date field Max Date get select..
so that my Dashboard will that Date data only.
Thanks Henric , And Thanks for Your Time
I Used ur Suggestion :
If(Date=$(vDateMax), 'Today',
If(Date=$(vDateMax)-1, 'Yesterday', 'Older')) as MyDate