nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Table gropus that count values from group and show only table group header

minthril

Hello!

I have Data Set with:- Date Time value - DateFrom- Date Time value - DateTo- Decimal value - Productivity I would like to create table that...- has hour intervals based on TimeFrom and TimeTo - for example 10:00 - 11:00, 11:00 - 12:00- adds Productivity values from this time interval I do not know what would be better approach. I am not too good in js nor sql so I thought that some table groups magic could do this. I attach dummy report that uses car models db. At the start it prompts user for data (I entered there some default value) that will specify the maximum CLASSICMODELS.ORDERS.ORDERDATE. Next fills table with this data (with grouping - Group On: ORDERDATE -> Interval Day).Is there possibility to hide groupped records and show only Table Group - Headers that will contain some computed data based on other values from all records in group? 
 
Or I am wrong and not table grouping is the solution but better sql querry/js?If some js function is the solution I have additional question - how to get all records to have possibility to iterate through them? 
Best regards, 
minthril

Find more posts tagged with

Comments

GLO_FR

Hi, that's a lot of questions

So [color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]>> I do not know what would be better approach. I am not too good in js nor sql so I thought that some table groups magic could do this.[/color]The simpliest way do do it is a group on your DateTime values. In this case, you only have to choose interval Hour and range 2 (every 2 hours) [color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]>> Is there possibility to hide groupped records and show only Table Group [/color][color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]Yes, select the row of your table and either delete it (you will only keep the group header) or hide it by checking the "Hide Element" in the Properties > Viibility pannel[/color] [color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]>> Or I am wrong and not table grouping is the solution but better sql querry/js?[/color][color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]I don't know if is better with js or SQL, it depends on your case, but it very easy to do it with BIRT functionnality so maybe it's the best way to do it[/color] [color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]Here a small example join (I've put a parameter and some script to manage the detail visibility, but you can define it inside the BIRT designer).[/color]

micajblock

You can set the interval of the group if it is a date field like this:

minthril

Thanks a lot for advices and example!

Now I have problem with data (to be more precisely - I have no data, only views) and have to prepare something by myself for test. But yours advices are very helpful and after preparing data I will make use of them

In case of problems.. I will ask