0.8.8

Features

• Support transculsion with params:

  // first create a query with slot
  select * from test.order_x limit {{limit}}
  // this query can be used in another query like this:
  select * from {{lYQZVPExSyRMbKb7lICsY(limit="20")}}
  // multiple slot is supported, use comma to sperate
  select * from {{lYQZVPExSyRMbKb7lICsY(limit="20",end="2021-02")}}
  // params also can be filled with context variable value:
  select * from {{lYQZVPExSyRMbKb7lICsY(limit=limit)}}

• Support date input block.

Enhancements

• Improve table image detecting and better displaying.

Bugfixs

• Initial password was not set.
• Fix dupliacted SQL query.

Screenshots

0.8.7

Features

• Variable state are included in URL, share draft variable state with others.
• Support filter stories those owned by you.

Bugfixes

• Chart legend content position.
• SQL Editor running state icon is not showing.
• Improve connection stability.

0.8.6

Redesigned control block, enhanced Table Chart, OAuth2.0 support, and more.

Features & Enhancements

• Redesigned control block.
• Control block temp value will be stored in URL for easy sharing.
• Table Chart now supports sorting on a column, displaying links or images, and search record.
• Support OAuth2.0.
• Support downloading up to 10000 records in download as CSV sub-menu.
• Add copy compiled SQL button in the Question Block submenu.
• Add a new shortcut to input inline formula, command/control + shift + e.
• Add a new shortcut to close SQL Editor tab, alt + w.
• Change chart tooltip display.
• Adjust sidebar popup logic.
• Add new variable types: macro and float.
• Increase default SQL query record limit to 5000.
• Increase transaction body size limit to 10mb.

Bugfixes

• Fix block placeholder overflow issue.
• Fix SQL Editor tab title overflow issue.
• Fix Table displays nothing when scrolling.

Screenshots

0.8.4

We created a dedicated page for metric exploration. It allows you to ask any questions on existing metrics for your business! Just drag and drop to start!

After exploring it, you can either move the visualization to a story or copy it into your clipboard. Yes! We've supported "Move to story" to move your block from one story to another. Click ⋮⋮ on a block and select "Move to story". You can search for the name of your target story or create a new one.

Enhancements

• Data asset can be canceled without affecting the downstream Smart Query
• between operator is supported for specifying a time period in Filters
• Add a Save button in the Filter form
• Add syntax highlighting and validation for SQL expression in SQL metric form
• Performance improvements to the SQL editor

Fixed

• Fix a data conflict issue in multiplayer mode
• Fix a bug when copy and paste text within a block
• Match default web port and default protocol
• Fix some minor issues for visualization
• Fix an issue when initializing the config of a chart

0.8.3

Another month has passed; here's a quick update on what's changed since October. We've been working on a lot of little details.

We finally have Filter for metric explorations! This feature lets you explore a metric against one specific segmentation combined with a series of conditions, such as (Version=2.3.0 AND OS=Android AND event=Login).

Enhancements

• It's now possible to see more information about data assets when selecting them from the right sidebar
• Added 4 type icons for dimensions when querying Data Asset
• Optimized the dropdown menu for choosing dimensions
• Onboarding page of docker-compose deployment

Fixed

• Fixed an issue of adding LIMIT into a non-select clause of SQL query (e.g., SHOW TABLES)
• Fixed an issue of importing a CSV file with null fields
• Fixed an issue of copy-pasting question's URLs in the SQL editor
• Error message will be cleared after one successful execution
• Referenced questions will now be refreshed in the "Refresh on open" story
• Fixed an issue of syncing data and visualization in Pie chart

0.8.2

For the last two weeks, we've been focused on polishing the interaction of metrics exploration and visualization settings.

We'll soon be working on adding filters to allow segmenting data and comparing measures across different dimensions.

💎Enhancements

• Redesign the icon for data asset🧱🧱🧱
• The left side menu has a new appearance when triggered
• File could be imported into the data warehouse if it uploaded to Postgres storage
• Data assets can be navigated to their block in the original stories
• The right-hand sidebar can be optionally closed by clicking the X at the top right of the tab

🐞Fixed

• Fixed a bug of refreshing data in a visualization
• Fixed a bug of scrolling to query block
• Correct the argument of importing from CSV
• Fixed an overflow issue when hovering code block

0.8.1

We've been hard at work on improvements to the whole experience of metric exploration.

We create a brand new sidebar in this release. Not only is this more excellent to look at, but it also makes metrics exploration and visualization settings more convenient! The sidebar will be displayed if you select a question block. It contains three parts:

• Data: You can configure the measures and dimensions of a smart query. Changing the measures and dimensions of the smart query will immediately refresh its data and reflect on the story block. We will bring the data configuration of a custom SQL query to this tab in the following release.

• Visualization: In this tab, you can pick a visualization type to represent the data returned by the question. Tellery gives a variety of choices: Table/Line/Bar/Area/Scatter/Number/Combo. The changes will take immediate action and sync to the story block.

• Modeling: This tab is for data producers. We now display the metrics and the downstream in this tab.

✨New

• Changing the measures and dimensions of the smart query will refresh its data
• The SQL editor has a new appearance
• All available data assets are now displayed in the sidebar
• Display visualization arrangements, data asset settings, and downstream n the sidebar
• Pasting a link to a question will automatically create a linked question
• Pasting an URL will automatically generate a hyperlink
• Code block supported a few more languages syntax highlighting

💎Enhancements

• Change the cursor of dragging blocks within a story
• Improve the performance when scrolled in a story
• Images are now cached for stories
• Images are now deformed after resizing

🐞Fixed

• Fixed an issue that set cookies expiration by mistake
• Fixed a visualization issue in the chart
• Fixed a display issue of error message when it's too long

0.8.0

Last week brings some great improvements to data assets. A business user now can extract metrics from a data asset without the assist of analysts.

1. First, drag and drop a data asset from the left side of your story.
2. Second, choose at least one Metric as well as a couple of Dimensions to summarize.
3. Bang! All metrics you wanted will be there for you.

To achieve that, you need to add metrics to the data asset first. Currently, Tellery supports two types of metric:

• Aggregated metric: calculate the metric by aggregating values within a column
• Custom SQL metric: calculate the metric by a custom SQL

We've also rolled out a number of UI improvements including visualization block menu, Thoughts preview in the past couple of weeks.

Enhancements

• Tooltips will open instantly if you have another tooltip open
• Generate random avatars for anonymous users
• Optimized the responsive layout for small screens
• Redirect user to the original page where he landed after he logged in
• Inline formula can be modified by clicking it
• Optimized the navigation logic for references in editor
• Hyperlinks/inline formulas have tooltips now

Fixed

• Fixed an issue of the popover menu when editing text
• Fixed an bug when moving the cursor in the nested block
• Fixed an issue when displaying the title of thoughts in the downstream list
• Fixed an bug of calculating width for the line/bar/area charts
• Fixed an bug of cursor when hitting an enter within a paragraph

0.7.0

Wow, half month has passed, here's a quick update on what's changed since last version.

Dbt integration

We've added dbt integration this version to make the modelling process more smooth. Set up your dbt repository, Tellery now imports all your dbt sources and models as data assets. You can inspect their dbt metadata while editing SQL in Tellery.

Inline formula

We add inline formula to reference a single number in your story. Inline formula allows you mention important numbers in charts/tables. It connects your data and words more tightly. It also supports simple arithmetic.

Enhancements

• Metric is renamed to Data asset
• Introduce two new block types: Code block/Math equation block
• Improve the appearance & styles of visualization blocks
• A visualization block can be configured to "frozen" to avoid its data being refreshed by mistake
• Optimize the position of tooltip when hovering over data points in visualizations
• Add linear display mode to X-axis for line/bar/area chart

Fixed

• Fixed an issue when copying data within visualization block
• Fixed a mouse/keyboard navigation conflict issue in slash command popup
• Resizing visualization block width will not affect its height now
• Fixed an bug when typing asterisk before a bi-directional link
• Fixed an issue when pressing backspace key (will delete two blocks)

0.6.0

We’re excited to introduce Metric in Tellery. A metric is essentially a wrapper that lets you embed a piece of SQL from one question into other questions. It's based on the mechanism of referencing question.

You can convert any question into Metric and explore it in any stories with drag-and-drop ease. All available metrics in the system will be listed on the left side of your story. 🕶

Last but not least, we shipped an online demo at https://demo.tellery.io/ this week!

Enhancements

• Improve the appearance of scrollbar in multiple places
• Support anonymous login mode
• Better error messages for saving transactions
• Optimize the inserting experience of toggle list
• Discard the reminder for slash commands after start typing
• Avatars of recent visitors now have tooltips
• Open thoughts from left sidebar

Fixed

• Resolved alias conflicts when constructing SQL
• Fixed an issue when there are too many tabs in SQL editor
• Fixed an issue when undoing/redoing operations
• Fixed an issue when opening story in right sidebar
• Fixed several text styling issues
• Fixed an collaboration issue when serval ppl editing the same story