Jump to content

There is a bar chart. If i select something from the filtering panel automatically one bar should get populated for the selected item and one more bar should appear that should sum all the non selected item.

Prateek Rawat

Recommended Posts

Here's an idea that uses a document property and a calculated column. This example is for plotting the Species column of the Iris dataset.

1- create a textarea with a multi-selection list for the unique values of the column you are interested. Say it is called selectedMulti

2-create a calculated column with this code, call it SelectedSpecies

case when Find([species],'$map("${selectedMulti}", ",")')>0 then [species] else 'Other' end

3 - set the bar chart to display SelectedSpecies rather than Species

The result is attached as an image.

P.s. if you have many similar entries in your column you will need to tweak the formula a bit to make sure it captures the entire value.

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