Yes you can use sparklines and a text table, but only by utilizing a dashboard view and carefully aligning rows. See an example here: http://www.datadrivenconsulting.com/2011/01/tableau-as-a-dashboard-take-two/
EDIT: Appears the viz is down - I would guess I need to update it to newer versions. But yes, you can do it.
Does the trend line need to be to the left of the numbers? If not you can do what's shown below (and attached). To do this:
- Create a sparkline of SUM(sale) for the period you want.
- Edit the axis to make it independent for each row
- Hide the axis (right-click and untick Show Header)
- Then create a couple of table calcs to find most recent value of each measure. For example, [Most Recent Sales] is LOOKUP(SUM(Sales),LAST()). What this does is get the value of SUM(Sales) for the value at the end of the sparkline.
- Drop those onto the Row Shelf, then right-click and choose Discrete.
Sparkline showing trend.twbx.zip 225.9 KB