Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to develop a table with a text dimension (called CD_INDICE_M) that doesn't have to keep into consideration the filter for this field.
This is my dashboard:
I try to write the Dimension using this syntax : =Only({1}CD_INDICE_M), but it doesn't work.
(Ora1,Ora2....Ora24 are expressions)
Someone could you help me?
Thank you in advance.
Try this
=Avg({<DT_DATA_M={">=$(=Date(vDataDA,'DD/MM/YYYY'))<=$(=Date(vDataA,'DD/MM/YYYY'))"}, CD_INDICE_M>} N_VALORE_1_MGP-N_VALORE_1_MI1)
May be add {1} or {<CD_INDICE_M>} to all your expression's set analysis
I'm sorry, but I don't understand, could you write the formula I should insert into the calculated Dimension?
Thanks
You mentioned Ora1... Ora2.. Ora.... are expression what exactly is the expression? Can you share the expression behind one of them?
Yes, sure, this is the formula of the Expression Ora1:
=Avg({<DT_DATA_M={">=$(=Date(vDataDA,'DD/MM/YYYY'))<=$(=Date(vDataA,'DD/MM/YYYY'))"}>}N_VALORE_1_MGP-N_VALORE_1_MI1)
vDataA and vDataDA are variables of input.
Anywhere, if I don't filter the field CD_INDICE_M my table is :
This is the result I would like to have.
Try this
=Avg({<DT_DATA_M={">=$(=Date(vDataDA,'DD/MM/YYYY'))<=$(=Date(vDataA,'DD/MM/YYYY'))"}, CD_INDICE_M>} N_VALORE_1_MGP-N_VALORE_1_MI1)
Great!
It works!
Thank you very much Sunny!
You are the number one.