Hello everyone,
we are currently trying to compare a measure for a certain week with the same measure of the weeks before. To make a condition such as: "If number of alerts in the 3 previous weeks > 100 then 1 else 0 [for this specific week]".
However we are struggling because it seems that Measures and Dimensions are strictly separated from each other. "number of alerts" would be a measure, "week" would be a dimension. When creating a measure only other measures are available in the formula creator, when creating a dimension only other dimensions are available. In our understanding we would have a formula with both measures and dimensions in it.
Any suggestions?
Thanks in advance!
Marvin