Jump to content

A question about Configuration Block.

Abhishek Singh 7

Recommended Posts

Hi Everyone ,

A question about Configuration Block. Can we only pass values in the setFilter or we can also pass expressions.

like i am trying the below and its not working

SetFilter(columnName = "BUSINESS_DATE", lowValue = Max([bUSINESS_DATE]), highValue =Max([bUSINESS_DATE]));

what if i want to select the max value in the filter as the default value for the initial state of analysis

Any other idea to achieve this , please share.


Link to comment
Share on other sites

Thanks for replying jots, Yes i tried the same,i created a calculated column with two fields , 'max date' and 'other dates' , but in this case user will have to look for the calculated column and check 'other dates' to see the data for other dates.

the requirement is to set the initial state of the analysis with the max date(default), and then if user wants to see other dates , he can use the range in filter panel . With calculated column the original date filter will also be greyed out.

that was the reason i was looking into conf block , trying to set the max date as the default filter value as the initial state of the analysis.

Link to comment
Share on other sites

  • 4 weeks later...

I couldn't get that to work but how bout creating a calculated column Which checks the max business_date and sets those rows to true or false. And use that column in the config block

Not sure how complex integration you are having with these config blocks, may be if you could share some context around it, we can think of more ideas.

Link to comment
Share on other sites

  • 4 years 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...