Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have scenario in which i have data like below
Field1 Value
asd-11 10
qwe-12 11
edc-43 12
Repeat 8
asd-11 11
qwe-12 12
qwe-13 11
You can see in this, asd-11 having two rows , by default if we put this in bar chart it will agrregate, so to overcome this and show it differently i used
dual( Field1, RowNo()) as Field1 and its working but issue is in this you can see one row is value Repeat, i m loosing that row
please suggest how i can get it?
I'm not sure, if I understand.
I tried the same and I didn't get missing anything. Please check the attachment.
It is working fine for me
I used below script:
t1:
LOAD * INLINE [
Field1, Value
asd-11, 10
qwe-12, 11
edc-43, 12
Repeat, 8
asd-11, 11
qwe-12, 12
qwe-13, 11
];
NoConcatenate
t2:
Load dual( Field1, RowNo()) as Field1,Value Resident t1;
Drop Table t1;
Bar chart with Dimention Field1 and expression as sum(Value)