Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to display a name by a ID, so i can identify if have 2 same names but with 2 different keys (ID)
I got this expression
=if(DWID_Medarbejder <> 1888, DWID_Medarbejder)
This shows all my workers ID except 1888. How can i comebine a name on this?
So i would get for an example
"Thomas Jensen 454"
"Michael Hansen 455"
"Thomas Jensen 456"
"Peter Pedersen 457"
and so on
And how do i do it in a bar chart? Is that just a calculated dimension?
Something like this maybe if the name is in field MedarbejderName:
=if(DWID_Medarbejder <> 1888, MedarbejderName & ' ' & DWID_Medarbejder)
In a (bar)chart you'd probably use this in a calculated dimension. It doesn't make much sense to use it as an expression.
Something like this maybe if the name is in field MedarbejderName:
=if(DWID_Medarbejder <> 1888, MedarbejderName & ' ' & DWID_Medarbejder)
In a (bar)chart you'd probably use this in a calculated dimension. It doesn't make much sense to use it as an expression.
And how do i remove a certain name in my barchart..
EG.
I see top 10 names in my bar chart, but one of the names is a Dummy
I do not want to show the Dummy because it mess up my barchart. Can i exclude that somehow???
Cause when i do like this
=if(DWID_Medarbejder <> 'Dummy', DWID_Medarbejder)
it gives me - in the barcharat
Ahh yes ofc! Can you make help me with the solution on what i wrote underneath ?
How to remove an value in barchart?
Write some like
=if(DWID_Medarbejder <> 1888 and DWID_Medarbejder <> 'Dummy', Medarbejder_Name & ' ' & DWID_Medarbejder)
HTH
Regards,
Anand
I actually just did before you wrote!
=if(Medarbejder.Navn <> 'Dummy', count(DISTINCT DWID_skaffetsagen))
Thank you both for the fast answers!