Becoming a super hero in TellStory is a fairly straight forward process, just learn how to tame our 3 headed dragon called widgets ;)
Get yourself started by watching this video:
You can change the chart type among compatible charts - such as line chart to bar chart.
Map the relevant colums to the widget you have added. E.g. in the Categories (the x-axis) of a line chart you will often want to map the Date column. In the Metrics (the y-axis) of a line chart you will want a countable value such as Items sold.
The operation depends on the data type of the column. For example a data type such as "Date" will allow you to either Extract or Bucket. Both these operations allow you to look at the data via Years, Months, Weeks, Days, Hours, Minutes or Seconds. Extract will look at all data on e.g. a 7th day in a month if you extract by day. Bucketing by day will bucket any intra-day data into a single day view.
On Numeric values you can perform SUM, COUNT, AVG, MAX and MIN.
On String values you can perform COUNT.
Use the sorting tool to sort your data ascending (ASC) or descending (DESC). You can also use the Metric to sort the data. Simply type in:
You can filter the data of the column you are visualzing. You can either use the pre-built logical expressions or write your own filters. In the "Data" tab, click on the Filer icon. Here is an example:
To filter dates use the format YYYY-MM-DD as shown below.
Date > '2020-05-20'
For more filtering tips on the entire chart and multiple filters scroll down to the section on Filters in this article.
The Time machine alows you to bring a new dimension to your graph - so that you can animate the development of a metric over time in a country.
Name your chart, rename enums & aliases.
Here you will find further formating & configuration options depending on what the given widget supports. These include:
"Stacked" chart - if you have a multiseries chart rather than showing each line / bar individually you and set them on each other
"Average line" - add an avg line to the chart to see an average between the multiple lines
"Global average line" - displays an average from all the metric data
"Replace undefined values with zero"
"Connect points" - connect a discontinuous graph into a continous even if values are left out
"Switch to ln()" - changes the y-axis scale to a logarithmic scale
Allows you to filter the entire chart either with pre-built filters or using custom ones.
If you want to combine several filters you can write your own filter expression. To do so, toggle the switch "Custom filter" Here is an example using both date (use the format YYYY-MM-DD for dates) and country to filter.
Country = 'Austria' AND Date > '2020-05-20'