Display Repeated Numbers in Dimension

[manideep78]

Dear Community,

I have different lot numbers with repeated frequency. Lot numbers will repeat any number of times.

When I use Lot number as dimension, in line chart it shows lot number only once but I need to display repeated lot numbers.

For this I used RowNo() for every lot and concatenated to lot number as a calculated dimension. But what I want is I need to display only Lot numbers and not concatenated rowno.

Please find the sample file attached

Any help will be appreciated.

Thanks a ton in advance.

Regards

Manideep

[#2]

hi,

If you need repeated lot no, then they must be distinguished by some attribute (like you use row no).

May be you can improve the UI, how it should be displayed to user.

Please find the attached file.

[sudeepkm · Accepted solution]

Please try Dual(LOT,RCount) in your dimension.

[#4]

Its working,...great

[maxgro]

try with this dimension

=dual(LOT, RCount)

ops i'm late....

[manideep78]

Thanks Sudeep. That is what I need. Thank you guys for your contribution.

Regards,

Manideep