Month to date and month end numbers on same report

tableaucommunity@tableau.com — Mon, 05 Mar 2012 13:19:20 GMT

I need to report month to date sales as well as month end customer numbers on one report? Is this possible?

My data is by week so for month to date results I can just filter for the weeks in the month and for month end numbers I can just filter on the last week in the month. Not sure how to do both on one report/table though?

Creating a dashboard with two separate reports is possible of course but ideally I want to show both numbers in one table.

Help appreciated.

KPI based on performance for one period compared to a previous period?

tableaucommunity@tableau.com — Thu, 23 Feb 2012 16:19:02 GMT

I am comfortable creating KPI's based on a specific value ie If Sales are greater than $1000 then "Good" else "Bad"

How would you go about creating a KPI where if Sales in Feb are higher than Sales in Jan then it's "Good" else "Bad"

Jan and Feb are date dimensions and Sales is a measure. Dates are showing as columns in my table and Sales (and other measures) are rows. Would like to have a tick if the latest month is higher than the previous month and a cross if not.

Help much appreciated.

Content in Tableau Community Forums

Month to date and month end numbers on same report

KPI based on performance for one period compared to a previous period?