Selecting value based on multiple conditions

[VilmaB]

Hello experts,

I have a data table:

 

Could hepl me tyo find out,  what should be an expresion to select Saifi value, for each ID, where  duration is more then 0,05 and has  max customer number. Dimension is Time.

The result table should be like this:

Thanks, Vilma

[sunny_talwar]

This seems more easily doable if ID was the dimension and Time was one of the expression... would you be able to provide the Excel file with the data so that we can load that instead of hand typing everything to create a sample.

[VilmaB]

There is my file.

Ok, lets try if ID is dimension.

[sunny_talwar]

Not looking for an image file, but an Excel file

[VilmaB]

🙂

[ramasaisaksoft · Accepted solution]

Hello Vilma,

As per the expected output

Create a Pivot /Straight table

Dimensions are: Time,ID,Duration,Customer Number  

Expression =Aggr(Min(Saifi),ID)

check this once & correct me if i understood wrongly

[VilmaB]

Hello Ramasaisaksoft, 

as you suggestion works fine, but I still need to do not include Duration dimension where it is less then 0.05. 

Time dimension is created as calendar group (time, week, month...), so if I choose the month, it shows all rows separately, but I need the SAIFI sum for this time period.

could you help me 🙂

[sunny_talwar · Accepted solution]

Check attached

[VilmaB]

Thank you! It works.