Histogram quesry

[delbooth]

Hi.

I am trying to create a histogram of collection days using 

sum({<[All Orders.Material Type]-={"other"}, [Collection Code]-={"Z","T","C","D"}>}(Date_Collected-[Planned From Date]))

It says it is an invalid dimension, I want a histogram of the outputs of the set analysis above.

Thanks

Del

[tresesco]

Invalid dimension ! What are your dimension and expression? Could you share the screenshot of the error message?

[sunny_talwar · Accepted solution]

From the last time I tried this out, it seemed that Histogram object cannot really take a calculated dimension. May be you need to create a new field with these restrictions in the script?

[sunny_talwar]

More on this here

Histogram