❔ Datalust Seq Graph - How do I show a percentage by dividing two Counts?

AAuger1/7/2023
I'm not very proficient with Seq queries, but my goal is to display a percentage based on dividing the result of two queries. I'd like to create a graphic on my dashboard that represents: JoinedCount / JoinedCount + LeftCount.

The first is:
select count(*) as count
from stream 
where @Message like '%Joined new guild%' ci
group by guildId, time(1d)
limit 10000


The second is:
select count(*) as count
from stream 
where @Message like '%Left guild%' ci
group by guildId, time(1d)
limit 10000
Image
AAccord1/8/2023
Was this issue resolved? If so, run /close - otherwise I will mark this as stale and this post will be archived until there is new activity.