I think to get the desired outcome, a table calculation should be used. Mostly likely using total(max([Value field]))
Then, you will want to make sure to compute this calculation using Pane(Across) or by Month. The following link provides further information on table calculations:
Hope this helps!
Assuming that you wanted to show sum of doses from a day in a month when the largest total quantity was dispensed (i.e. maximum daily sum of doses), instead of a maximum singe dose, then the attached sample workbook does that using table calculation, as suggested by tracy.fitzgerald.
Pretend that drugs are sub-categories, and doses are sales.
To understand the mechanism, you need to have some knowledge of how table calculation works, for which Tracy kindly provided the link.
If you wanted to show the largest single dose, then simple MAX() does the job.
That is not producing the desired result.
Here's a more detailed explanation...
I fill Viagra. Some patients get 4, some get 6. In February, the most that we gave out in one day was 12 - on Feb 6th. In January it was 16, and we did that on the 9th.
That is important to me, for ordering purposes. If i know the MOST i'd do in one day, i can set my minimum on hand quantity etc.
So my result set would look like this:
Viagra 16 12
Plavix 60 90
Lipitor 210 140
The original data would look like this:
Feb 6th Viagra Bob Jones #4
Feb 6th Viagra Gary Smith #6
Feb 7th Viagra Sam Sammy #9
Feb 6th Viagra Bill Clinton #6
and so on and so forth for each individual prescription filled.
I'm kind of thinking that this must be some sort of join i'd have to do. I dont know, you guys are smarter at this...
Thanks in advance!
This post is now in danger of being taken down as spam by auto spam filter because of the frequent use of "Viagra".
Yep, my table calculation method will produce the desired result for your case description. Table calculations could be a bit of 'rocket science' to understand, but, like the proverbial drug in your example, they work as advertised (not that I would know personally).
If you can de-sensitise (now the post will definitely be taken down) your data and post a workbook, I can do the table calculation like in the mock-up example. It didn't work in your case probably because the partitioning was too tricky, which is a hard (this would be the last straw) concept to master because it is not that easy to picture in one's mind.
Thanks a million. you guys are geniuses and tableau is magical.