This looks like you have three dimensions, i.e., Index Product := ['Prod_A', 'Prod_B', 'Prod_C', 'Prod_d'] Index IsOverseas := ['Not Oversea...

Why does the arrow go up for Stock B? From the sparkline, it looks like the price dropped. Shouldn't that be a down arrow?

@patstevens That's a very different approach. Interesting, and thanks for sharing it. As you said, I'd still like to see another solution that uses a ...

Thanks Pat. You are right, I do have a bug where a null is missing when a group uses every event slot. My original definition just got even a bit mo...

Sorry, I forgot to attach my example model to my previous post. Here it is.  flatten-ragged-array.ana