In my application I have to show status changes. I receive the changes in a message which can capture multiple status changes within the last minute. The status field is a bitset an can contain up to 32 different statuses.
In order to display the data it would be convenient to lookup this status field and create for each changed bit a copy of the message with the according status and the on/off flag.
Use a ValueLoop (1,32) as a dimension, and using that, create your multiple rows.
so, If you have DATE_TIME as Dimension and STATUS as corresponding status, use ValueLoop(1,32) as a additional dimension, and in Expression put If(pick(ValueLoop(1,32),Filter1,...Filter32)&Status=1,'Status '&ValueLoop(1,32)&' is on','Status '&ValueLoop(1,32)& ' is Off')