C
Join ServerC#
help
❔ 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:
The first is:
The second is:
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

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.