Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis in Bar Chart

Hey Guys,

What I'm trying to do is count the number of customers that have purchases greater than 3 dates in a bar chart. The problem is when I did that I had no dimension but I want the user to be able to lasso each bar to select that group of customers.

Any other ideas on how to accomplish this one?

There are three expressions

=Count (DISTINCT {$<[Invoice Date] = {"> 39400"}>} [Customer Number])

=Count (DISTINCT {$<[Invoice Date] = {"> 39500"}>} [Customer Number])

=Count (DISTINCT {$<[Invoice Date] = {"> 39600"}>} [Customer Number])

It needs to look like this

error loading image

2 Replies
disqr_rm
Partner - Specialist III
Partner - Specialist III

Hi Kristen,

See enclosed. Something quick and not-so-dirty.

Rakesh

Not applicable
Author

Hey Rakesh,

Thanks for doing that for me. Sorry I should have mentioned that the end user needs to be able to change the three dates on the fly without having to do a reload.