C
C#•3y ago
Auger

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

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
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
select count(*) as count
from stream 
where @Message like '%Left guild%' ci
group by guildId, time(1d)
limit 10000
1 Reply
Accord
Accord•3y ago
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.

Did you find this page helpful?