Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 data tables, using this code to find values. and find the percentage
Now I want to plot the values. by making a percentage and the total values are plotted like this, what should I do?
@Paknanarn23 Could you please post some sample data and also elaborate a bit more on your expected output.
I have graphed it now. But the graph doesn't turn out the way I want. Details are already in the post
In my graph there are KCe_Date and layer_no, the code fragment is as follows.This is the code used to make the bar graph
sum({<OP_WorkCenter = {'MAOI'}>}CQ_PNL_OUTPUT_MAOI) / sum(total <KCE_Date> {$<OP_WorkCenter={'MAOI'}>} CQ_PNL_OUTPUT_MAOI)*100
This is the line graph code.
sum(total <KCE_Date> {<OP_WorkCenter = {'MAOI'}, LAYER_No={'04','06','08','10','12','14','87'}>}CQ_PNL_OUTPUT_MAOI)