Report Grouping Based on Time Interval

Samn265 · February 17, 2015, 10:50pm

I am using Ignition 7.7.2

In the report designer how do you group data based on time interval? I would like to make selectable criteria based on the “DownTime Start” column, so I can say I need this date (or date range) and also this shift (or time range)

Attached are my report designer screenshot and the SQL Script for my data, and exported project.
DownTimeGrouping_2015-02-17_1620_partial.proj (73.5 KB)

CPowell · February 18, 2015, 9:53pm

Try this:

Add this code to the SQL Query

,CONVERT(VARCHAR,(b.t_stamp - (convert(char(8),dateadd(ss, b.Uptime,0),108))),101) as StartDownTimegroup

I am just wanting to return the month/day/year so we can group that.

Then in the report designer, then add the new key ‘StartDownTimegroup’ to the grouping. Check Header. Make sure it is the top Grouping Key. Click the grey square next to it to add a top page icon. Here is a pic.

Also, here is a test report I made using an Audit log. So you can see how I am grouping the date and the action.

Let me know how that works.
Cheers,
Chris
Test Report.proj (46.6 KB)

Samn265 · February 20, 2015, 11:07am

Thank you Chris for taking the time and help me on this. It worked beautifully. You are awesome.