Forum Discussion

Navaneetharaju_'s avatar
Navaneetharaju_
Icon for Helper II rankHelper II
2 years ago

Run Hours on Selected date

Hi All, 

 

I need a community help to guide me on this.

 

Task_name - Task x

Start_date : 01-Mar-2024

Start_time : 01:00:00 PM

Repeat_by - Hours

Repeat_every - 1

repeat_every 1 means from the start_date and start_time it should run the every 1 hours.

If i select 01-Mar-2024 in date slicer, it should show the runs in time_bucket.

Time_slotCount
1:00:00 PM1
2:00:00 PM1
3:00:00 PM1
4:00:00 PM1
5:00:00 PM1
6:00:00 PM1
7:00:00 PM1
8:00:00 PM1
9:00:00 PM1
10:00:00 PM1
11:00:00 PM1

 


if i select 02-Mar-2024 or upcoming days, i want a result should be like this 

Time_slotCount
12:00:00 AM1
1:00:00 AM1
2:00:00 AM1
3:00:00 AM1
4:00:00 AM1
5:00:00 AM1
6:00:00 AM1
7:00:00 AM1
8:00:00 AM1
9:00:00 AM1
10:00:00 AM1
11:00:00 AM1
12:00:00 PM1
1:00:00 PM1
2:00:00 PM1
3:00:00 PM1
4:00:00 PM1
5:00:00 PM1
6:00:00 PM1
7:00:00 PM1
8:00:00 PM1
9:00:00 PM1
10:00:00 PM1
11:00:00 PM1



I want to display the run count of tasks
Kindly provide the measure or calculated column to acheive this

"Show and tell"
Need Help

8 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Do you have an end date/time for each task or are they running in perpetuity?

    • Navaneetharaju_'s avatar
      Navaneetharaju_
      Icon for Helper II rankHelper II
      2 years ago

      Hi lbendlin , 

      Few tasks have end_date and end_time 26-dec-2024 12:00:00 AM (based on business needs),  and few tasks are never ending. End_date and and end time is null.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        fair enough.  Please provide sample data that fully covers your issue.  Multiple tasks, some overlapping some not etc. Various schedules.