Maybe. But you'll need to post a sample workbook so we can tinker with it. Sounds like you may be able to do it with a set sort. But can't really tell without the workbook.
Like Shawn said, a sample workbook would be super-helpful. As you've seen, table calculations are tricky to work with and settings have a lot of variation based on your desired outcome(s).
If your case is simple, the following might work: Tableau doesn't offer a custom default sort on dimensions based on table calcs. However, you can take advantage of Tableau's default alphanumeric sort, by creating a discrete field that would sort the way you want and using that as the left-most field in the view. In your case, you could create a calculated field with the formula: -[your quarterly average field]. Drag that to the Rows shelf, set it to Discrete, and put it as the left most column, then turn off Show Header.
I can definitely put together a sanitized workbook for you to review. I'm using version 6.0.8. Is that going to be okay?
It won't be an issue for me!
Thank you for providing a workbook.
As for sorting the view by the result of a table calculation, that can be achieved by placing the table calc pill as a discrete pill. If you would like to sort descending, place a negative sign in from of it, likely as another calc field.
I made a few other adjustments, using some different methods, that will help with performance as your data grows larger. As with anything in Tableau there are multiple ways to accomplish the same results, the attached route would be my preference for this situation, and likely different if there were other constraints.
Here is the link to it on Tableau Public:
Here are the steps to reproduce:
1. change the formula for "Forecast Accuracy (Window Avg)" to:
IF LAST()==0 THEN
2. change the formula for "Latest FW" to:
LOOKUP(MIN([Fiscal Week]),0)=[Latest Fiscal Week]
3. add a calc field, "Sort" with the formula (once created, right-click and "Convert to Discrete"):
-[Forecast Accuracy Window Avg)]
4. remove the pill "Latest FW" from the rows shelf (it likely has a red exclamation mark)
5. place "Latest FW" on the filter shelf, keeping only when True (set the compute using to "Fiscal Week" for the pill, may need to set filter twice)
6. set the compute using for the two "Forecast Accuracy (Window Avg)" pills to "Fiscal Week"
7. you can move the pill for "Fiscal Week" on to the Level of Detail shelf (not necessary, just makes for less clutter on the Rows shelf)
8. place "Sort" as the first pill on the Rows shelf, and from its context menu, un-check "Show Header"
your result will look something like:
Message was edited by: Joe Mako - edited step 5 - published to Public
Thanks for the thorough reply. I was able to re-create some of your steps, but ran into some issues (e.g. the new Latest FW field, when placed on the filter shelf, only gives me the value of False as a selection option). However, when I tried opening the workbook in Tableau Public to see under the hood, I got the following error:
The requested workbook does not exist on Tableau Public. Only workbooks that are currently available on Tableau Public may be opened.
edited the steps to include what I left out, and published to Public
This might be a stupid question, but where would I find it?
find what? If you mean what I published to Public, you can find the link in my comment above.
Ahh...I'm blind. I missed the link in your earlier post. I'll take a look at it tomorrow. Thanks again.
Cool. This worked. I swear I tried this before and it didn't work. I guess it just needed the Mako touch. :-) Thanks again, Joe.