Hi there,
I'm attaching my workbook. For every Half-hour i will get data i need to sort it out to maximum time interval Record and sort the data by 30min (Current time), 1 Hour, Current day,current week and Current month.
please suggest me a proper calculation and sort my issue.
thanks,
surya
You want to only show the service numbers and phase voltages for Service No's that fit into the Time Selection parameter, correct? If so, this should work.
You need to define each phase voltage bucket that you want to pass in from your parameter. Then, you can use these defined intervals within your case statement. See below:
I edited your CASE STATEMENT to utilize each of these calculations for each parameter choice:
I have a filter on the PHASE VOLTAGE CASE to hide null values, so you don't see a bunch of empty rows for the interval timestamps.
If this answered your question please mark it as correct so others can find it useful in the future. Thank you.
