1 2 Previous Next 19 Replies Latest reply on Apr 20, 2016 9:35 PM by G Marc Turner

# MAX Value across dates

I need a MAX value of the example:

 ID Capacity Measure 4/5/2016 4/6/2016 4/7/2016 A 404.847 404.847 404.847 404.646 404.646

The values for A are already a MAX LOD, for the dates:  WINDOW_MAX(SUM([capacity measure]),0,0) / COUNT([File Creation Date]).

The Capacity Measure is a Dimension to validate that I have the correct values and the MAX LOD did it's job, for each day.

When I take the date field out of the Columns and the capacity Measure out of the Rows, it doesn't take the MAX value of 404.847, rather it averages the 404.84 and the 404.646 to 404.780.  I need the value to be the MAX value of all the numbers for ID A, which should be 404.847.

How do I do this?  I have tried all sorts of calculations and nothing is preventing the averaging of the numbers.

Thanks!

• ###### 1. Re: MAX Value across dates

Not sure exactly what you expect because your data is not aligned in the post.

A screenshot could be better than simple text here.

You can't take the date dimension off the view. Otherwise, you don't get the Max.

Put it in the Details shelf, if you don't want it to be on the row/column shelf.

• ###### 2. Re: MAX Value across dates

Hard to tell from the description you gave.  A sample workbook would help me help you.

But if my assumptions of what you are doing are correct, the first thing I would try is WINDOW_MAX([whatever field you are displaying there])

• ###### 3. Re: MAX Value across dates

Hi Alex.

It should look like this:

If I took out the date field, it looks like this:

If I took out the Capacity Measure next, it looks like this:

• ###### 4. Re: MAX Value across dates

Hi joe.

Thanks for the reply.  Already did that.  I even tried RUNNING_MAX to look at both rows. Still averages.

• ###### 5. Re: MAX Value across dates

The screenshot is not from Tableau.

I would like to see how it look like in Tableau.

• ###### 6. Re: MAX Value across dates

What MAX are you looking to find?  MAX for each Capacity measure?  Or MAX for the entire sheet?

The WINDOW_MAX function is a table calc.  By default Tableau will guess what makes most sense (usually picking TABLE(down) or TABLE(across)), but you can tell it to evaluate that table calc in all sorts of different ways.  And if you want the max for the whole sheet, you'll almost certainly need to override what Tableau picked.

• ###### 7. Re: MAX Value across dates

Really, a packaged workbook will help a lot here.

• ###### 8. Re: MAX Value across dates

Hi Alex.

I can't take a screen shot from Tableau as this is private info.  I re-created as it appears, in Excel.

• ###### 9. Re: MAX Value across dates

Hack up whatever it takes to put those few numbers onto a simple tableau sheet.

Check out this video:

• ###### 10. Re: MAX Value across dates

Load the mockup data to Tableau and take a screenshot.

• ###### 11. Re: MAX Value across dates

the data you show is not in relational format, thus hard to understand.

• ###### 12. Re: MAX Value across dates

Just created this.

Thanks!

• ###### 13. Re: MAX Value across dates

Packaged workbook

• ###### 14. Re: MAX Value across dates

Do FILE -> "Extract Packaged Workbook" to get a TWBX file.  You need a TWBX to share a workbook.

1 2 Previous Next