1 of 1 people found this helpful
You could create a Parameter to choose the period then have a calculated field that determines if the data date is within the paremeter.
Create the Parameter:
Data type: String
Allowable values: List
List of values:
7 Last 7 Days
30 Last 30 Days
Now create the Calculated Field:
Name: In Period
Calculation: DATE(SPLIT([SLA Date Time], " ", 1))<DATEADD('day',1,TODAY()) and DATE(SPLIT([SLA Date Time], " ", 1))>=DATEADD('day',-int([Period]),TODAY())
Now drag the In Period field to your filters & choose TRUE as the filter.
And Show the Period Paremeter...
Thank you for your reply Adrian. I will try this.
I tried and it works fine . Thanks for that.
I now have to display it like :
1- if I am displaying today(0) then i should display number of 'Error', 'Waiting','Completed' Jobs
2-else if its 7 or 30 days I should show only 'Error' and ' Waiting'
I have used SETS for this like :
- I created 2 sets one with E,W,and C another with E,W
- Then i wrote a calculated filed like if period='TODAY' (0r our case 0) then SET1 else SET2.
- Then i have dragged it to the pane and filtered only true.
Do you think any better way to do this?? (tried group too but , one value used in a group cant be used in another group is what i encountered).
If it works then go with it. That doesn't sound dissimilar to how i would do it.