It is unclear if a zero reading
and an absence of reading
is the same or not.
There is a gap for NY from 8:18 till 8:23 (incl).
How could one interpret this gap?
As for LA, if one would count together
the boundary zero points at 8:23 and 8:27 --
and the 3 missing points in between --
it would give a total of 5 minute points, not 4.
So the counts would depend on rules (implied or articulated).
With that in mind, please find the attached.
Example data_YF.twbx 154.3 KB
Thanks for the help so far..
Good point and thanks for the clarifying question.
Yes... a reading of 0 is a reading.
And a missing point of the data set is not the same as 0.
Let's set up a rule this way... All values once measured are assumed to be constant until measured again. So if a temp is 80 at 8:01, and the next reading happens to be at 8:06, we assume (due to our rule) that the temperature was 80 for 8:02, 8:03, 8:04, 8:05 until we got another reading at 8:06. The reading that came in at 8:06 may also be 80 or another value. But until we get another value we assume things are as they were at our last measurement.
FIRST()==0 is a Table Calculation filter.
When TRUE it leaves only one (first) Cell per Addressing window
(the addressing window includes only [Time] in this case).
As a result, only one value is left on a view for each [Name].
If one removes the filter, more Marks are drawn
on top of each other, hence blurring a view.
How do you create a table calculation filter directly?
I achieved the same result by creating a calculated field and then added that measure to my filters card, but it looks like you created the table calculation filter directly (with no name even?). Can you explain the mechanics of how you created it?
This is called "in-place calculation editor".
You just double-click on an empty space
somewhere on a view (on Rows, Columns or Details)
and start typing your calculation, then hit Enter.
If calc syntax is right Tableau makes a pill on-the-fly.
Hope this helps.
PS I prefer typing on Details :-)