user3783676
user3783676

Reputation: 539

Tableau sum by condition

I have a data like this

Date Temperature Load 2017-08-05 7:45:00 PM 10 5 2017-08-05 7:46:00 PM 10 4 2017-08-05 7:47:00 PM 10 2 2017-08-05 7:48:00 PM 10 1 2017-08-05 7:49:00 PM 10 5 .........

In Tableau, how can I sum the Load by hours and plot scatters?

Upvotes: 0

Views: 250

Answers (1)

myers_co
myers_co

Reputation: 106

I would drag SUM(Load) onto Rows and AVG(Temperature) onto columns and discrete hour of Date onto Details. That would give you a scatter plot like

enter image description here

Upvotes: 2

Related Questions