I am new to tableau and having trouble plotting a line depicting a daily aggregation of a group of (devices) max values. From my research thus far, I believ the solution would be using the table calculation but data returned is the max of a single device (dimension). My erroneous formula is [TOTAL(MAX([Load]]))]. Any help would be greatly appreciated.
The desired data can be shown in a text table thru "Analysis" and showing row totals when set up accordingly.
Phil,
Welcome to the Forum.
I may not have full caught the gist, but I think there are ways
to calculate it by table calculations or by level of detail calcs.
In the workbook v10.3 attached in the Forum thread,
I used the Superstote Dateset as an example.
I have days along the x axis, and sales along the y axis.
For each day, there is a dimension ([Segment]) with three possible values
and then there are multiple values within each Segment.
What I understood the goal to be was to look at each Segment,
find its max value, then for a given day sum up all the max values.
By table calculations
[TC Max per Segment]:
IF FIRST()=0 // because of multiple rows per segment, need only the first one
THEN WINDOW_MAX(SUM([Sales]))
END
[TC Sum Maxes]:
WINDOW_SUM([TC Max Per Segment])
By LOD
[LOD Max per Segment]:
{ FIXED [Order Date (Days)],[Segment]:MAX(
{ FIXED [Order Date (Days)],[Segment],[Product Name]:SUM([Sales] ) } ) }
[LOD Sum Maxes]:
{ FIXED [Order Date (Days)]:SUM([LOD Max Per Segment] ) }
Of note, for the table calculation method with its need for all dimensions on a shelf,
it became difficult to plot the sum of the maxes as a line.
