explorers: slack-analytics

{
    "blocks": [
        {
            "args": [],
            "type": "graphers",
            "block": [
                {
                    "type": "StackedArea",
                    "title": "Messages per day",
                    "ySlugs": "messages_in_public_channels_smooth messages_in_private_channels_smooth messages_in_shared_channels_smooth messages_in_dms_smooth",
                    "subtitle": "14-day average",
                    "stackMode": "absolute",
                    "tableSlug": "messages",
                    "Metric Radio": "Messages",
                    "Stacked Checkbox": "false"
                },
                {
                    "type": "StackedArea",
                    "title": "Messages per day",
                    "ySlugs": "messages_in_public_channels_smooth messages_in_private_channels_smooth messages_in_shared_channels_smooth messages_in_dms_smooth",
                    "subtitle": "14-day average",
                    "stackMode": "relative",
                    "tableSlug": "messages",
                    "Metric Radio": "Messages",
                    "Stacked Checkbox": "true"
                }
            ]
        },
        {
            "args": [
                "https://owid-public.nyc3.digitaloceanspaces.com/owid-slack-analytics-2022-05-05.csv",
                "messages"
            ],
            "type": "table",
            "block": null
        },
        {
            "args": [
                "messages"
            ],
            "type": "columns",
            "block": [
                {
                    "name": "Date",
                    "slug": "date",
                    "type": "Date"
                },
                {
                    "name": "Entity",
                    "slug": "entity",
                    "type": "EntityName"
                },
                {
                    "name": "Total enabled membership",
                    "slug": "total_enabled_membership",
                    "type": "Integer"
                },
                {
                    "name": "Enabled full members",
                    "slug": "enabled_full_members",
                    "type": "Integer"
                },
                {
                    "name": "Enabled guests",
                    "slug": "enabled_guests",
                    "type": "Integer"
                },
                {
                    "name": "Daily active members",
                    "slug": "daily_active_members",
                    "type": "Integer"
                },
                {
                    "name": "Daily members posting messages",
                    "slug": "daily_members_posting_messages",
                    "type": "Integer"
                },
                {
                    "name": "Weekly active members",
                    "slug": "weekly_active_members",
                    "type": "Integer"
                },
                {
                    "name": "Weekly members posting messages",
                    "slug": "weekly_members_posting_messages",
                    "type": "Integer"
                },
                {
                    "name": "Messages in public channels",
                    "slug": "messages_in_public_channels",
                    "type": "Integer"
                },
                {
                    "name": "Messages in private channels",
                    "slug": "messages_in_private_channels",
                    "type": "Integer"
                },
                {
                    "name": "Messages in shared channels",
                    "slug": "messages_in_shared_channels",
                    "type": "Integer"
                },
                {
                    "name": "Messages in DMs",
                    "slug": "messages_in_dms",
                    "type": "Integer"
                },
                {
                    "name": "Messages in public channels",
                    "slug": "messages_in_public_channels_smooth",
                    "type": "Numeric",
                    "transform": "rollingAverage date entity messages_in_public_channels 14"
                },
                {
                    "name": "Messages in private channels",
                    "slug": "messages_in_private_channels_smooth",
                    "type": "Numeric",
                    "transform": "rollingAverage date entity messages_in_private_channels 14"
                },
                {
                    "name": "Messages in shared channels",
                    "slug": "messages_in_shared_channels_smooth",
                    "type": "Numeric",
                    "transform": "rollingAverage date entity messages_in_shared_channels 14"
                },
                {
                    "name": "Messages in DMs",
                    "slug": "messages_in_dms_smooth",
                    "type": "Numeric",
                    "transform": "rollingAverage date entity messages_in_dms 14"
                },
                {
                    "name": "Percentage of messages, public channels",
                    "slug": "percentage_of_messages_public_channels",
                    "type": "Numeric"
                },
                {
                    "name": "Percentage of messages, private channels",
                    "slug": "percentage_of_messages_private_channels",
                    "type": "Numeric"
                },
                {
                    "name": "Percentage of messages, DMs",
                    "slug": "percentage_of_messages_dms",
                    "type": "Numeric"
                },
                {
                    "name": "Percentage of views, public channels",
                    "slug": "percentage_of_views_public_channels",
                    "type": "Numeric"
                },
                {
                    "name": "Percentage of views, private channels",
                    "slug": "percentage_of_views_private_channels",
                    "type": "Numeric"
                },
                {
                    "name": "Percentage of views, DMs",
                    "slug": "percentage_of_views_dms",
                    "type": "Numeric"
                },
                {
                    "name": "Total full members",
                    "slug": "total_full_members",
                    "type": "Integer"
                },
                {
                    "name": "Total guests",
                    "slug": "total_guests",
                    "type": "Integer"
                },
                {
                    "name": "Total claimed full members",
                    "slug": "total_claimed_full_members",
                    "type": "Integer"
                },
                {
                    "name": "Total claimed guests",
                    "slug": "total_claimed_guests",
                    "type": "Integer"
                },
                {
                    "name": "Total members",
                    "slug": "total_members",
                    "type": "Integer"
                },
                {
                    "name": "Total claimed members",
                    "slug": "total_claimed_members",
                    "type": "Integer"
                },
                {
                    "name": "Files uploaded",
                    "slug": "files_uploaded",
                    "type": "Integer"
                },
                {
                    "name": "Messages posted by members",
                    "slug": "messages_posted_by_members",
                    "type": "Integer"
                },
                {
                    "name": "Public channels, single-workspace",
                    "slug": "public_channels_single-workspace",
                    "type": "Integer"
                },
                {
                    "name": "Messages posted",
                    "slug": "messages_posted",
                    "type": "Integer"
                },
                {
                    "name": "Messages posted by app",
                    "slug": "messages_posted_by_apps",
                    "type": "Integer"
                }
            ]
        }
    ],
    "_version": 1,
    "yAxisMin": "0",
    "selection": [
        "All"
    ],
    "explorerTitle": "Slack Analytics",
    "explorerSubtitle": "Collected from Slack Admin Dashboard"
}