Funny Line Graph Results

[#1]

Hi i am trying to plot a line graph for two different vendors and how there unit prices for the same part varied over time. However, when the unit price is the same, the data points are plotted on the same date on the graph, thus showing incorrect interpretation of the pivot table data.

I inserted this screen shot with highlighted figures to better explain what the problem is. The highlighted dates on the pivot table are missing from the line graph.

Does someone know what this is happening?

Thanks

[tresesco]

I suggest to share a demonstrative sample. Have a look here: Preparing examples for Upload - Reduction and Data Scrambling

[sunny_talwar]

I guess what is the expression that you are using in your chart?

[#4]

Thanks Amit for that great post. I can now attach my QVW ! !

Would be great if someone can help!

[sunny_talwar · Accepted solution]

I think you need to fix your first dimension here.

You currently have

=Aggr(Max(Date([PO Date])), UnitPrice)

and need to change it to

=Aggr(Max(Date([PO Date])), VendorID, PartID, UnitPrice)

[tresesco]

This is because you calculated the max date aggregating against the Unit Price. What is expected output?

[#7]

Thanks Sammy Sunny ()!

That was the problem.

[#8]

Your are right Amit. The aggr function was incorrect and is now working perfectly fine.

[sunny_talwar]

No problem

Name is Sunny