Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a chart visualization that I need to add a column to. I have a column that has part numbers and I need to add a new column that assigns a % value to each distinct part number.
For Example.
part number A = 2%
part number B=4%
Can any help me figure this out? Thanks!
@Drece-gkn
Do you want to bring how much (%) the number of pieces represents?
Imagining that's it, try the expression with the total qualifier adapted to your model.
Count(distinct [field-parts])
/
Count (distinct total [field-parts])
Att,
Matheus