I need to create a straight table with a timestamp as dimension.
The catch is that the table gets extremely large if I report on every timestamp.
I spoke to my users and they asked for 2 tables based on a variable called vInterval which is the timeinterval in seconds
The 1st table must only report on the 1st possible value after the time specified in the interval and ignore all results in between
The 2nd report must do the same but also report the values in between.
I must do this in the frontend and not the load script.
The expression in the report just check for a value and the prints a 'X' if found else blank
See the attached example where the interval is set to 60 minutes