Jump to content
We've recently updated our Privacy Statement, available here. ×

Count() function does not work when filtered by data.

Abhishek Patil

Recommended Posts

Hi All.

I am new for spotfire is there any way can i create Measures in spotfire bcz calculated coloum will not dynmic it all custom expression and I have input data [year],[pwk_w_sal] so i just want group by year and I've created a calculated column called TOTAL=sum([pwk_w_sal])/count([year]).But count() is taking the entire table number of rows count of year. I need yearwise calculation total. Please suggest me with a few solutions.

Thank you

Link to comment
Share on other sites

  • 2 weeks later...

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...