Spotfire: Calculated Column to find if a different event in same column occurs within 1 hour
The calculated column I am trying to create is the far right column in the below table:
In words: If a B event occurs in the specified City, does a C event occur within one hour of the B event, true or false.
I've tried a few different approaches with Over functions but just not having luck. I am struggling on how to reference a different event in the same column and then calculate a datetime difference between them..
Thanks!
You may try to take it in stages and define intermediate columns. Try this, assuming C is the max label for the events.
You did not post data so I generated something that seemed similar.
([event]="B") and (Max([event]) OVER (Intersect([city],AllNext([date])))="C") and ( DateDiff("hh",[date],ValueforMax([event],[date]) OVER (Intersect([city],AllNext([date]))))<=1)
- Fast & accurate atan/arctan approximation algorithm
- What's the difference between strtok_r and strtok_s in C?
- How memory address for pointer to arrays is same as an element in 2D array?
- Which is the best way to suppress "unused variable" warning
- How to use ellipsis in c's case statement?
- How can I exclude non-numeric keys? CS50 Caesar Pset2
- Fast ceiling of an integer division in C / C++
- Is there an invalid pthread_t id?
- How does SIMD (avx) processing work? for example, if I want 10 32 bit floats how do i fit in a 256 bit avx vector?
- FDCAN problems on STM32G4
- How does the call macro enable mutual recursion between functions f and g in this Hanoi Tower implementation?
- Running test on Rocket core CPU - global variable initialized to 0 is unsuccessful, output wrong value instead
- Interacting with C arrays without knowing the size
- Combination of two strings
- Avoiding strcpy overflow destination warning
- carriage return by fgets
- How to use special characters in C?
- Why does 1.0/100.0 == 0.1/10.0 give True?
- Is it correct to compare pointers in C?
- Force free() to return malloc memory back to OS
- How can I print to standard error in C with 'printf'?
- What is the standard behavior of fread in C on Windows?
- How is strtok removing lines it shouldn't have access to?
- Using array as smart point in C
- Assigning string to malloced 2d char array not working as intended
- How to refactor repetition inside a Makefile?
- Why does an empty preprocessor command still evaluate to something?
- How to implement variable sized array within C struct
- Character array typecasting to integer
- Handling HTTP Headers in a Minimal C HTTP Server