Show Duplicate items in Bar chart

[amanjain57]

Hello,

I want to show the duplicate item on the bar chart. As an example below their are two line in table. But when i try to convert it into a bar chart only one line items shows up. Reason is because its one Component PN but in reality i want to show the metric for the two line items on bar chart . Can someone guide ?

 

[y_grynechko]

Hey, use the dual function to assign different number values to the same name, it will show you 2 bars. 

In the load script do something like this:

on the end of the table add:

dual(Component PN, RowNo()) as Component PN

After doing that your barchar is going to have hidden value to group by.