Report , Modify displayed date

Ignition
1

Hello All,

I have a report that is running fine except for the displayed time stamp.
I have a transaction group the triggers at 02:00 AM. The transaction actually logs all of the metered total from the prior day. It then clears the totals to zero.. All of that works fine. The issue I have is when running the report query based on "t_Stamp" all of the data displayed is from the prior day. Can I apply math to the @t_stamp@ so it shows -1day? So for a report run on Oct 2nd, it would display as Oct 1st...

2

Post a screenshot of your report parameters and data sources configuration, for the best answer; however, it sounds like you would just do it in your query. The syntax is dependent on your db flavor (mysql, postgres...)

3

dkhayes117,
Sorry for the delay.. Field work..
I am using MySQL as the database.
Data is collected using a triggered transaction group. Issue is that we activate the trigger at 2:00AM instead of midnight in case production runs past midnight. This makes the data's "T-Stamp" value a "day ahead" of the production values.

image
image1402×374 72.5 KB

Report is basic to say the least.

image
image1318×635 110 KB

I am hoping for a way to modify the @t_stamp@ value to read as the prior day.

Thanks for your help..

4

Modify it in the query,

select 
   ...,
   ...,
    ADD_DATE(t_stamp, INTERVAL -1 DAY) as production_date
from IngSkid_Totals
...

EDIT:
Another method could be to add another field that gets captured in the transaction group called production_date which would log an expression value addDays(now(0),-1)

Then t_stamp would be when data was captured and production_date is the workday it represents.

5

I will try them individually.
The transaction group version sounds to be the best approach..