socialanalyticsblog
database and the tweet_sentiments
table.SocialAnalyticsBlogQuery
)Put in this query:
SELECT s.*,
e.entity,
e.type,
e.score,
t.lang as language,
coordinates.coordinates[1] AS lon,
coordinates.coordinates[2] AS lat ,
place.name,
place.country,
t.timestamp_ms / 1000 AS timestamp_in_seconds,
regexp_replace(source,
'\<.+?\>', '') AS src
FROM socialanalyticsblog.tweets t
JOIN socialanalyticsblog.tweet_sentiments s
ON (s.tweetid = t.id)
JOIN socialanalyticsblog.tweet_entities e
ON (e.tweetid = t.id)
timestamp_in_seconds
to be a date:
Now we’ll step through creating a dashboard.
type
and tweetid
from the field list onto the visual.tweetid
to the value.Now let’s add another visual.
sentiment
and timestamp_in_seconds
.Under the field wells, or the chart itself, you can zoom in/out of the time. Let’s zoom into hours:
Suppose on the timeline, we only want to see positive/negative/mixed sentiments. The Neutral line, at least for my Twitter terms, is causing the rest not to be seen easily.
Just click the Neutral line and in the box that appears choose to Exclude Neutral.
You can build multiple dashboards, zoom in and out of them, and see the data in different ways. Use the remaining time in this lab to try to build the dashboard below: