
1. Re: How to Calculate Total per Day?
Love Tableau Sep 7, 2018 6:12 PM (in response to kevin sayet)Hi Kevin,
I played with your workbook and came up with the formula which gives the max number of houses for sale.
Just drag this on to your chart.
{ FIXED [City],DAY([Date Compiled]):MAX([Number of Homes For Sale])}
Hope this helps.

2. Re: How to Calculate Total per Day?
kevin sayet Sep 7, 2018 6:32 PM (in response to Love Tableau)Thanks, I'm not sure that dragging it is working. Can you please explain to me how to implement this formula into the workbook?

3. Re: How to Calculate Total per Day?
Love Tableau Sep 7, 2018 6:41 PM (in response to kevin sayet) 
4. Re: How to Calculate Total per Day?
kevin sayet Sep 7, 2018 7:05 PM (in response to Love Tableau)Thank you! I had to make one change to the data  the workbook is updated above. Some dates (date compiled) might have two or more lines of data. For example, Sept 7 20:43 has two lines that must be added up to determine the total number of listings. The total number of listings for Sep 20:43 is 24 (10+14). However, the graph shows Sep 7 for Atlanta show as 47 listings which is the sum of all listings from that date (10+14+23) but it should instead show the maximum listings of 24 which is for sep 7 20:43 (10+14) which is higher than the other one line from Sep 7 8:43am (23).

5. Re: How to Calculate Total per Day?
Ankit Bansal Sep 7, 2018 9:46 PM (in response to kevin sayet)Kevin,
This should work for you:
{fixed [City],day([Date Compiled]) : max(
{FIXED [City],[Date Compiled]:sum([Number of Homes For Sale])}
)
}
You need to use nested LOD. First u need to aggregate data at date compiled and then find max for each day.