Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a working expression in my straight chart table.
I have data set of Batches with upto 12 sublots in each batch
For a selection of batches
my expression is =If(Avg(Total <[SubLot ID]> Opaque%) >= OpaqueAlert,[SubLot ID])
This displays the [SubLot ID] where the Opaque% >= OpaqueAlert,
I would like to display this as a concat text expression.
something along the lines of:
=Concat(If(Avg(Total <[SubLot ID]> Opaque%) >= OpaqueAlert,[SubLot ID]))
so my straight table gives me these sublots which meet the expression for the select batches.
I would like to display this as a text object like C28, B75 (Distinct from C28, B75, C28, B75, C28, B75)
struggling to get my head around what is required.
A nesting of aggregations is only possible by defining the appropriate dimensional context by an aggr() function, like:
Concat(aggr(If(Avg(Total <[SubLot ID]> Opaque%) >= OpaqueAlert,[SubLot ID]), Dim1, Dim2))
whereby Dim1 and Dim2 are just placeholder for needed dimensions - usually the ones used within the chart.
A nesting of aggregations is only possible by defining the appropriate dimensional context by an aggr() function, like:
Concat(aggr(If(Avg(Total <[SubLot ID]> Opaque%) >= OpaqueAlert,[SubLot ID]), Dim1, Dim2))
whereby Dim1 and Dim2 are just placeholder for needed dimensions - usually the ones used within the chart.
Many thanks,
works a treat