BOXI reporting filters for 'Last Week', 'Last Quarter'

Idea created by tzadell on Jun 23, 2014

Comment • 10

Delivered

Score15

+6 more

PdmToday functionality should be expanded for both Last Quarter (The True Last Quarter) and Last Week (The true Last week).

Last Week - Running a weekly report on the 'Past 7 days' only shows data that is relative to the date/time the report is run. It would be better to run weekly reports for teams that are all based on the same static work week. If a weekly report doesn't run right and has to be re-run the next day, then you lose 1 day of data in that weekly report. Having a static 'Last Week' would also allow you to better space out your weekly scheduled reports and not have to try to run them all right after midnight.

Last Quarter - Businesses do many things based on quarters. I would think that the ability to run quarterly reports is something that many customers would also want.

10 Comments

avinash.kande Jan 18, 2015 6:01 PM
I truly agree on this..
Like • Show 0 Likes0
Actions
Gale_Bacon Sep 22, 2015 10:29 PM
Yes, excellent idea!
Like • Show 0 Likes0
Actions
Chi_Chen Mar 10, 2016 4:25 PM
take a look at this tech doc:
How do you use the CA Business Intelligence (CABI) Week() Function to filter tickets opened in the past week
Like • Show 0 Likes0
Actions
- tzadell @ Chi_Chen on Mar 11, 2016 4:49 AM
  Hi Chi.... I looked at the document, but unless I'm missing something, I'm not seeing where you are defining what 'last week' is? I want last week to be a static time period -- for example, the beginning of the day on Monday to the end of the day on Sunday. I would like to be able to run a report on any day of the week if needed, that will include data in that static time period for what we see as 'last week', rather than it being the past 7 days. And the same thing for 'last quarter' etc.
  
  Thanks,
  Tammy
  Like • Show 0 Likes0
  Actions
  - JussiValkonen @ tzadell on Mar 11, 2016 7:30 AM
    Tammy, the variable "Last Week" should actually be called "Week Difference" or something, it takes the difference in the current week number and the week number of the open date of each tickets and shows the diff as an integer. You can then use this as a filter like mentioned on step 5.
    The problem with that solution might be that as far as I know it is a view-time filter instead of run-time filter, so you can't really automate the delivery of that report.
    Like • Show 0 Likes0
    Actions
    - Raghu.Rudraraju @ JussiValkonen on Mar 11, 2016 2:48 PM
      Hi Jussi/Tammy,
      
      As the Query itself is not being changed, providing values into the report parameters (Query Filters) during scheduling would not cause an issue. The report would always show only what the Report Filters were coded to, which is hard coded in the report and can't be changed during the Schedule. That's the restriction of the solution discussed above.
      
      So, I think we could still use an enhancement on the creation of PDM functions for Last Week etc.,
      
      _R
      Like • Show 0 Likes0
      Actions
jhapr01 Mar 27, 2017 6:57 AM
This idea is being Wish-Listed for potential inclusion in a future release.

tzadell It will be great if you can list out the metrics which are important to you.

Before this idea moves to the next stage (Currently Planned or Not Planned), I would like to invite community members to please provide additional input and/or vote. Please note that Wish-listed ideas are selected for inclusion in a release based on multiple factors including - number of votes from community members, alignment of idea with a release's themes and goals, complexities and risks involved in implementing the idea, so a timeframe for availability of the idea as a product feature/functionality cannot be provided. Additionally, the implementation of your idea may not be exactly as requested and/or may be delivered in a new user experience.
Like • Show 0 Likes0
Actions
- tzadell @ jhapr01 on Mar 27, 2017 11:02 AM
  Hi Pravesh,
  
  It will be great if you can list out the metrics which are important to you.
  
  Rather than providing this functionality just for certain metrics, I would instead like to see PdmLastWeek and PdmLastQuarter added (like the PdmToday functionality), so that these can be used for any report.
  
  Thanks.
  Tammy
  Like • Show 0 Likes0
  Actions
jhapr01 May 21, 2018 11:41 AM
We are moving from BOXI to Jasper reporting. Filter for DAY, WEEK, MONTH, QUARTER & YEAR will available once we release transactional reporting in Jasper report.
Like • Show 0 Likes0
Actions
ambsh01 Mar 21, 2019 5:42 AM
Jaspersoft provides inbuilt functionality to use relative dates apart from fixed date time. For example, I can use "In Between" function on Incident Open Date to find out all incidents that were created between the current week and the last week by using relative time stamp (Week & Week-1) from the date chooser. It is present in the 17.2 release.
Like • Show 0 Likes0
Actions

BOXI reporting filters for 'Last Week', 'Last Quarter'

Related Content

Recommended Content