Here is the solution book for download:
Your densification table is quite good. Without it, I would not have
figured out the following table calculations. Yes, a lot of table
In all the table calculations, most are using Contract ID for compute. Fill
Status computes using Table Across.
Let me know if you have questions.
On Wed, Apr 22, 2015 at 11:14 AM, Nicolas Steinbach <
Thank you for your answer. It is exactly what I am looking for.
I can't seem to be able to open your file when I download it though.. would you mind re uploading it please?
It's in tableau 9. Download tableau public and use it to view the details.
On Thursday, April 23, 2015, nicolas.steinbach <
Added a little color to it.
Somehow, can't make the drill down to work.
For anyone who happens to see this: Is it possible to use aggregates as
On Thu, Apr 23, 2015 at 8:19 AM, nicolas.steinbach <
Alexander had posted about this on another thread, I got curious and checked it out. I came up with a couple of alternatives, one is a simplification and the other uses a different route to get the count. See http://drawingwithnumbers.artisart.org/counting-from-nothing-a-double-remix/ for details.