Hi all,
i have a datasets with several records including timestamp. The requirement is to have a filter to be able to select
1). Current Shift (6:00-14:00, 14:00-22:00, 22:00-6:00)
2). Today Overview
3). Current Week
4). Current Month
With possibility to see previous period for some visuals. What is the best approach? I have tried to use Field Parameters with calcualtions Current and Previous Periods. But the issue is to do proper Switch for the previous week and shift.
Structure of the input json:
{“timestamp”:“2024-03-06T10:40:36”,“resource_name”:“dmg_ctx_beta_1250_tc_1”,“datamodel_version”:“general_v_1_0_0”,“resource”:“101”,“active_program_current_state_number”:“0”,“active_program_last_transition_number”:“2”,“active_program_name”:“_N_CH12_ROBOTER_SPF”,“errorcode”:“0”,“message”:“”,“production_desired_parts”:“410”,“production_part_counter”:“”}
{“timestamp”:“2024-03-06T10:40:37”,“resource_name”:“dmg_ctx_beta_1250_tc_1”,“datamodel_version”:“general_v_1_0_0”,“resource”:“101”,“active_program_current_state_number”:“1”,“active_program_last_transition_number”:“0”,“active_program_name”:“_N_CM100GE000010_MPF”,“errorcode”:“0”,“message”:“”,“production_desired_parts”:“410”,“production_part_counter”:“”}