en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
SO  
#1 Posted : Monday, February 2, 2015 8:59:01 AM(UTC)
SO
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/19/2014(UTC)
Posts: 72

Is it possible to have dynamic time "Previous two months"?

Edited by user Friday, February 13, 2015 11:38:45 AM(UTC)  | Reason: Not specified

Páll Bjarkason  
#2 Posted : Monday, February 2, 2015 2:01:05 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 156

On the Criteria pane you can access the criteria “pop-up” box and check the “Use dynamic periods” checkbox.
Then you can choose the desired dynamic period.

UserPostedImage
Best regards

Páll, CTS
Ole  
#3 Posted : Tuesday, February 3, 2015 8:35:27 AM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 320

Páll,

I think your screenshot is a little misleading for a "Previous two months" dynamic criteria. The attached screenshot here will produce the desired Previous Two Months dynamic criteria.

If you have a newer version of TARGIT, the easiest way to define this, is to use the predefined "Previous 12 completed months" dynamic criteria, and the modify the "-12" to "-2".

BR / Ole

UserPostedImage
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
SO  
#4 Posted : Tuesday, February 3, 2015 8:39:28 AM(UTC)
SO
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/19/2014(UTC)
Posts: 72

Thanks for the replies.

Your suggestion works great Ole, I didn't think of the previous 12 completed months and change it to -2.
Páll Bjarkason  
#5 Posted : Wednesday, February 4, 2015 11:54:14 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 156

True Ole, was only giving then general direction ;)
To get more insight into the offset option using dynamic periods check the TARGIT BI tutorial: Using Dynamic Criteria

Best regards

Páll, CTS
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error