6th insight: Discourse soft-votes
Assign
Data Source
Priority
Status
Description
Engage other DAO members on what should be the 6th insight that we should build
Estimated Completion
Tags
Property
Category: governance health (primary), community health (secondary)
Objective: get a high-level “snapshot” of soft-votes submitted through Discourse over a time period.
Returns: a breakdown of the votes for each post in the time period containing a vote
Data set(s) required: Discourse
Visualization type: horizontal stacked bar chart. Each bar is a decision nominated to a soft vote (ordered by the date the blog post was created). Each bar is broken down/consists of the different vote option. The length of each bar reflects the number of votes that option received. The total length of the stacked bar reflects the total number of votes on that decision.
Syntax: !soft_votes [start-date] [end-date]
[start-date] - the earliest post creation date that should be included in the results in yyyy-mm-dd format.
[end-date] - the latest post creation data that should be included in the results in yyyy-mm-dd format.
If no parameters are entered the default values should be:
[start-date] = today() - 30 days
[end-date] = today()
select
dt.title as topic,
date(dt.created_at) as date,
dpl.title as poll_name,
dpv.vote_option,
dpv.votes_count
from discourse_topics dt
join discourse_posts dp on