CODEWITHSUNDEEP
tableau-api
JohnRambo
JohnRambo

Reputation: 23

Tableau - Monthly Date to Quarterly affecting Calculations

I'm creating a basic line graph with the following data:

Jan 2015    $1
Feb 2015    $2 
Mar 2015    $3

My monthly data is all inclusive of prior months, so it basically represents everything that has happened in the past as well as the current month results.

In Tableau, when I set the dates to Quarterly it shows up as Q1 2015 ($1 + $2 + $3) where as I just want $3 (March 2015).

How do I do this?

Thanks!

Upvotes: 0

Views: 214

Answers (2)

JohnRambo
JohnRambo

Reputation: 23

Right now, the rows doesn't say SUM but rather AGG. I'm not sure how to proceed...am I able to filter out only Quarterly Dates?

Perhaps, I can just show March 2015 and relabel as Q1 2015?

Upvotes: 0

S. User18
S. User18

Reputation: 712

Right now, on the rows (I assume) shelf, you have SUM(whatever your field is). Click the drop-down on that pill and change the calculation instead to Maximum. It would then be MAX(whatever your field is).

Upvotes: 1

Related Questions