The TIBCO Platform is a real-time, composable data platform that will bring together an evolving set of your TIBCO solutions - and it's available now!
A chart showing the TIBCO Platform vision
Jump to content
Forums
Ask questions and gain insight from discussions

Calculate a simple average with OVER function


Emma Hudson

Recommended Posts

Hi Everybody

I am trying to calculate an an average between two dates (01/01/2019 to 31/10/2019) which also takes account of the filter.

 

I know that I need to use AVG and the OVER funtion but I can't get get it to work. Mine either gives me an error or gives me some sort of average that I can't reconcile back to my data.

 

Can anyone help me please I have attached some sample data. I would like the bar chart on the right to contain the average while the chart on the left is a simple sum.

 

Thank you.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...