Forum Discussion

GerlofVisser's avatar
GerlofVisser
Helper I
6 years ago
Solved

YTD uptime using measures

Hi,   I have several equipment (wells) which should run 24hrs per day on various facilities. To define the overall uptime for each facility, I'd like to know if at least 1 one of them has been run...
Need Help
  • GerlofVisser's avatar
    GerlofVisser
    6 years ago

    For anyone following this topic, I have solved it myself.

     

    I added a column to my table which finds the maximum uptime of the wells based on a facility filter.

    Then with the calculate function I create an average over this value.

    Using the filter for the current year only, it shows the average YTD.

    Not sure if this is the most robust solution, but it works.

     

    If anyone is interested in more details of these explanation, just let me know.

     

GerlofVisser's avatar
GerlofVisser
Helper I
6 years ago

Hi, 

 

I have created a quick excel example, but this is what I want to achieve.

amitchandak 

OwenAuger , I have seen your posts, maybe you can help as well?

Hope that this helps.

 

Thanks!

Gerlof

 

GerlofVisser's avatar
GerlofVisser
Helper I
6 years ago

Ok, I have created some additional measures and am trying to get it right, but I think the issue lies with summing up measures.

I have also tried to summarize the column I am creating in mutiple steps in one formula, this looks something like:

 

 

Uptime_Field = SUMX(
SUMMARIZE(energy_unit_data_fdc_value, Facility_Lookup[Facility_ID],"Max Hours", if((CALCULATE(max(energy_unit_data_fdc_value[hrs_online]),Facility_Lookup[Facility_ID]))=24 , 1 , (CALCULATE(max(energy_unit_data_fdc_value[hrs_online]),Facility_Lookup[Facility_ID]))/24)),[Max Hours])

 

 

My original approach was the following:

 

With this measure, I am finding the max of all the wells which belong to a certain facility ID, this gives me a good result.

 

max hrs well = CALCULATE(max(energy_unit_data_fdc_value[hrs_online]),flowID_Lookup[FACILITY_ID])

 

 

With the following measure I am normalizing the data on a daily basis

 

Uptime_Field_day = if([max hrs well]=24,1,[max hrs well]/24)

 

 

And this measure "Uptime_Field_Day" gives exactly the same results as the "Uptime_Field" measure.

 

When I then use the YTD function to calculate the cumulative, the results are the same.

 

Cumulative hrs online = CALCULATE([Uptime_Field_day], DATESYTD(Rolling_Calendar[Date]))

 

 

 

  • GerlofVisser's avatar
    GerlofVisser
    Helper I
    6 years ago

    For anyone following this topic, I have solved it myself.

     

    I added a column to my table which finds the maximum uptime of the wells based on a facility filter.

    Then with the calculate function I create an average over this value.

    Using the filter for the current year only, it shows the average YTD.

    Not sure if this is the most robust solution, but it works.

     

    If anyone is interested in more details of these explanation, just let me know.