
1. Re: Time series  scatter plot of daily sums and averages
Peter Gilks Dec 31, 2013 10:33 AM (in response to Jan Siroky)Hi Jan,
you can probably* skip the line chart stage by doing the scatter plot and then place DAY(your_datetime_field) on the Details shelf. If that doesn't work, please post the workbook and I will take a look.
Peter
*probably, depending on how your original data is arrnged

2. Re: Time series  scatter plot of daily sums and averages
Jan Siroky Jan 1, 2014 3:17 AM (in response to Peter Gilks)Hi Peter,
you solution works, thank you!
Jan

3. Re: Time series  scatter plot of daily sums and averages
Jan Siroky Jan 2, 2014 12:42 AM (in response to Peter Gilks)Hi Peter,
I see that data arrangement is very important.
Lest investigate a simple example. I have two energy meters with the following data:
energy A
10:00, 10 kW
10:10, 10 kW
10:20, 10 kW
10:30, 10 kW
10:40, 10 kW
10:50, 10 kW
11:00, 10 kW
energy B
10:00, 10 kW
10:30, 10 kW
11:00, 10 kW
When I compute hourly sums I will get 600 for A and for 20 B. However, both energy meters shall have the same hourly sum (10 kWh).
Is there any way how to compute sum based on integral, not only sum of elements?
Jan

4. Re: Time series  scatter plot of daily sums and averages
Peter Gilks Jan 2, 2014 6:50 AM (in response to Jan Siroky)Hi Jan,
I'm happy to hear the solution worked.
In answer to your follow up I think you have two choices. One option is to just keep the data at the hour mark, e.g. 10:00, 11:00 etc....
The other option, which I think will suit you well, is to change the aggregation from SUM to AVG (mean average). You do this by right clicking on the 'pill' and changing to average, as below. As you can see you can also select max or min as aggregations too.

5. Re: Time series  scatter plot of daily sums and averages
Jan Siroky Jan 2, 2014 7:10 AM (in response to Peter Gilks)Hi Peter,
thank you for the answer.
Average solves this problem. However, in practice I cannot guarantee that data will be equidistantly sampled. What if I have the following data
10:00, 10 kW
10:09, 10 kW
10:11, 0 kW
11:00, 0 kW
Then the average consumption is in reality 10/6 however I will get 6.6667. In this case I need integration with respect to time domain. Can this be handled in Tableau?
Jan

6. Re: Time series  scatter plot of daily sums and averages
Peter Gilks Jan 2, 2014 7:53 AM (in response to Jan Siroky)I suggest you open up a new thread with this question, that way you are more likely to catch someone with the correct expertise.
It should be possible using table calculations.

7. Re: Time series  scatter plot of daily sums and averages
Jan Siroky Jan 3, 2014 2:36 AM (in response to Peter Gilks)Hi Peter,
thank you.
Here is a link to the thread http://community.tableau.com/message/247282#247282
J.