Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I notice that after doing my Count Distinct and concatenate some values when I use in graph others Dimensions the result that i obtain is always the same in all dimensions result.
For example:
The formula I use is:
=count( DISTINCT {< Resultado={"Qualificado"}, Requalificacao={"0"}>} IdentificadorCandidatura & IdSubCategoria & ManufacturerNIF)
Some ideas whats is happening, the concatenate don't be able to use this kind of formula?
Thank in advance.
Would you be able to share a sample to show the issue?
What exactly do you want to count? and what exactly do you want to concatenate?
Hi Vineeth,
I have this concatenate in the formula above "IdentificadorCandidatura & IdSubCategoria & ManufacturerNIF".
This formula is my expression, "=count( DISTINCT {< Resultado={"Qualificado"}, Requalificacao={"0"}>} IdentificadorCandidatura & IdSubCategoria & ManufacturerNIF)"
I put a dimension do "sort" the data by, for example [Nivel], like in the image above.
But the result for each [Nivel] is the same "212" for each category.
I don't get why there is a need to count on 3 fields? also are these fields from the same table or associated tableS
I need to do a Distinct with this 3 fields. The 3 are from the same table.
This will never work, create a new concatenated field during load to count on
example
LOAD *,
IdentificadorCandidatura &'_'& IdSubCategoria&'_'&ManufacturerNIF as NEWFIELD
and use this field in your expressions
Same result.
Sunny,
What you need to view a sample?
Thanks
I was hoping for a qvw file with the desired output
Preparing examples for Upload - Reduction and Data Scrambling