I am assuming you want to display the assignments based on the assignment creation date. You can create a section with different table layouts per your need and invoke the corresponding report definitions(Assignment Class) as the source and with the filter as the pxCreateDateTime as Today/Yesterday/Last 7 Days/Last 30 Days
@NagarjunaS16644648 you can have 4 Report Definitions and make use of the Time periods in the select values-> Year wise, month wise, Days wise etc. You can use 4 different RDs in 4 different tables.
Or Create a data page, sourced with 4 of these RDs. When user selects any 1 option, use that option as the when condition to decide which RD to run and give results. And use this dpage with list structure as source to the table layout. This is for reuse purpose.
Above 2 approaches are for displaying records in the table layout in the UI. Below one just mentioning for you to know we have this approach also.
If you are enabling report definition to the user in the report browser using Shortcut, then just add .pxcreatedatetime as the filter with a parameter. End users can filter the results with Time periods at run time.
@NagarjunaS16644648 In the Report definition itself, you have chart option. You can make any column to Summarize-> Count in the query tab. Then you can see many charts there. You can play with those charts and use those charts. Here you will see the count and chart together.
If you want to use charts in section, you have chart control and you can use that in section.