Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bookmark called "Set1"
I have a field called "company"
I would like to use a the bar chart dimension of "company" based on the bookmarked Set1 company selection(s).
It's probably something obvious, I'm just missing it.
=??({Set1}company)
Any help?
You should be able to use "company" as the dimension and then include the bookmark in the expression.
If it's sum(Sales) for example you would use sum({Set1} Sales)
Then if you have suppress zero values turned on for the chart you'll only see dimension values where the expression evaluates to more than 0.
So I'm doing a set analysys between two bookmarked sets, Set1 and Set2.
Set1 contains information for one Company or more, and Set2 cointains information on the pool of companies.
I'm using a variable "Percent_Index" as my expression which compares both bookmarks and returns a % of the Set1 score vs. the Pool average score. So in my chart my expression value I have simply the variable: [Percent_Index]
Ideally I would like to plot Companies, but only the companies selected in Set1...
I should also note that company is a string - the name of the company.