Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
new day, new question - a quite simple one this time.
I need to count the unique values within a ROW. Currently I'm using RangeCount(<Column1>, <Column2>, <etc.>) in my load script and use this later on as a field in a diagram. I would need it to count only distinct values [RangeCount(DISTINCT <Column1>, <Column2>, <etc.>)]. How can I achieve this?
Thanks for your advice in advance again!
Could do a cross table load in back end and a count distinct?
Yes could help but I feel like due to ressource restrictions afterwards not helpful to my problem.
EDIT: Since it only works on 2 arguments its to less for my purpose. No way to count directly within rows? Or a way to count distinct values of a row within a table diagram?