Hello. I have two tables “successCount” and “errorCount” which each gives the total for each respective measurement. Having said that, I created the **“total”** which is the sum of these two previous tables. So far, the 3 results appear without any problems. However, I now want to understand the percentage of error compared to the total (error + success) and therefore I have the **final** where I do the join and the map but no results are presented. What am I missing?

successCount = from(bucket: “my_db”)

|> range(start: v.timeRangeStart, stop: v.timeRangeStop)

|> filter(fn: (r) => r._measurement == “success” and exists r.log_id)

|> group()

|> count()

|> yield(name: “success”)

errorCount = from(bucket: “my_db”)

|> range(start: v.timeRangeStart, stop: v.timeRangeStop)

|> filter(fn: (r) => r._measurement == “error” and exists r.log_id)

|> group()

|> count()

|> yield(name: “error”)

total = union(tables: [successCount, errorCount])

|> group()

|> sum()

|> yield(name: “totalResult”)

final =

join(

tables: {total: total, erros: errorCount},

on: [“_time”]

)

|> map(fn: (r) => ({ r with _value: float(v: r.erros._value) / float(v: r.total._value) * 100.0 }))

|> yield(name: “result”)