Applying filters on a chart in web report studio

[jb9977]

Hi Everyone,

I want to know if we can apply two filters on a single chart in web report studio. for example if i am creating a bar chart based on number of sales and total revenue of sales. can i apply filters so that my graph shows number of sales>50 and revene of sales >50000?

Thanks,

jay

[FredrikE]

What if you create the the combined filter in the information map and then use it as a section filter in WRS?

//Fredrik

[jb9977]

Hi Fredrik,
There are other charts that need the entire data.

Thanks,
Jay

[FredrikE]

Hmm, then I would split them into different sections, with different section filters 🙂

I don't know any other way to solve this :0 since you can only have one filter on the objects at the samt time...

//Fredrik

[Madelyn_SAS]

You could put a category filter and a measure filter on the same bar chart, but you cannot create a combination filter for multiple measures from the Filter & Rank dialog box.

Applied filters: Country equal to CANADA AND Actual Sales greater than $245,000.00