Spotfire- calculated column with row ratios based on condition -


i’m having trouble understanding if spotfire allows conditional computations between arbitrary rows containing numerical data repeated on data groups. not find cue me onto right solution.

context (simplified): have data sensor reporting state of process , data grouped bursts/groups representing measurement taking several minutes each. within each burst sensor measuring signal , if predefined feature (signal shape) detected sensor outputs calculated value, v quantifying feature , reports runtime @ happened.

so in essence have 3 columns: burst number, set of rts within burst , values associated these rts. need add calculated column ratio of values rows rt equal specific number, let’s 1.89 , 2.76.

example of data table

the high level logic be:

if value exists @ 1.89 run time , value exists @ 2.76 run time compute ratio of these values. repeat every burst. understand can repeat computation on groups using on operator i’m struggling logic within each group... tips appreciated. many thanks!

the first thing need here apply order dataset. assume sample data complete , encompasses cases in real data, thus, create calculated column:

rowid() [rowid]

once done, can create calculated column compute ratio on it's respective groups. note, b4 example incorrect compared other groups. is, have numerator , denominator reversed.

if(([rt]=1.89) or ([rt]=2.76),[value] / max([value]) on (intersect([burst],previous([rowid]))))

breaking down...

  • if(([rt]=1.89) or ([rt]=2.76), limits rows rt = 1.89 or 2.76.
  • next comes evaluation if above condition true
  • [value] / max([value]) on (intersect([burst],previous([rowid])))) takes value row , divides max([value]) on grouping of [burst] , allprevious([rowid]). noted intersect() function. so, denominator previous value grouping. note max() simple aggregate used, should case since expecting single value. over() functions require , aggregate limit result set single row.

results

results


Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more