Tom Tang 2 Posted September 19, 2019 Share Posted September 19, 2019 hi there I have a question regarding below custom expression in Y axis, in my visualization, 1) X axis has OrderNumber column 2) and each OrderNumber has 'Setup' and 'Packaging'( they are side by side bars) I want to get e.g. the avg of TimeSpan for all 'Setup' of all OrderNumber if I code like below it will return avg of TimeSpan for'Setup' and 'Packaging'of all OrderNumber sinceAxis.X represents all nodes Max([TimeSpan]) then Avg([Value]) OVER (All([Axis.X])) is there any way like below Max([TimeSpan]) then Avg([Value]) OVER (All([Axis.X.'Setup'])) thanks! Link to comment Share on other sites More sharing options...
Tom Tang 2 Posted September 20, 2019 Author Share Posted September 20, 2019 up Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now