Not able join on the same timestamp

i have a data coming from a measurment like
time,comp,comptotal
1, a, 20
1, b, 30
1. c, 50

i nee to calculate percentange of comp/comptotal.
I summed over comptotal and got the node with below data
time,total
1,100
Now while joining both the node i dont get any data/measurement. I wanted to join so as to include total sum in all the rowset of same timestamp

I wanted the data in this format
time,comp,comptotal,total,percentage
1,a,20,100,.20
1,b,30,100,.30
1.c.50,100,.5

Start by reproducing the reported join with multiple rows sharing timestamp 1, including the aggregated total stream. Investigate how the join handles identical timestamps and verify whether the result includes total and percentage for each comp row. Done means the example produces the requested five-column output or the issue documents the limitation clearly.

Written by the indexing model from the issue text.