C#•2y ago

❔ 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•2y 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.

Gaming

Programming

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