Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
Could you share the expressions you used in the script and in the front end for KPI calculation, please?
It would probably be best if you could also share a small sample file that demonstrates what you are observing.
the formula :
count (distinct if(CALL_DIRECTION='O',A_NUMBER,if(PARTNER_CODE<>'PAH',B_NUMBER))) as NBR_Abonnées_ACtifs,
Hi,
It is obvious that it will give you different result.If you do it at front end it will give you distinct value on the base of your selection. but if you do it at back end (script) it will be base on the group by condition.
Hope this will help.
Also if you can let us know on what dimension you want to see the distinct count thenit will help us to understand more.
Maybe you have script modifiers like NullAsValue or NullDisplay that changes the value between the script and the chart ?