I am struggling with the advanced mode for a trellis with two dimensions. The working original formula to create a single chart would be something like this:
count( distinct {$<week={'Previous Week'},day={'Sun'}>} id))
I cannot, for the life of me, get any combination of vDim, vDimSet, vDimSetFull, etc. to work. I've also tried without advanced mode and that was unsuccessful as well as the values were not being populated correctly.
For example, the same calculation above would show correctly, but when shown in the non-advanced mode Trellis with the day and week dimensions from the set expression above, and the measure as:
count(distinct id)
the values were grossly incorrect, or not present.
I'd like to avoid making 21 individual charts if possible (one for each DoW, for three Weeks), so any assistance here is welcome.
