Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement:
I need facility name filter should not affect month dimension in a bar graph. I am using below expression:
Aggr(only({<FACILITY_NAME=>}month),month)
but the data still changes with the FACILITY_NAME filter. Any suggestions on how to make FACILITY_NAME inactive here?
Try this
Aggr(Only({1<FACILITY_NAME=>}month),month)
Try this as well in case, didn't test it so not sure -
Aggr({<FACILITY_NAME=>}only({<FACILITY_NAME=>}month),month)