
1. Re: Create Mark for every number in a Sum
Hildebrando Souza Jr Jun 24, 2016 3:18 PM (in response to Ben Fox)Hi Ben, did you try to change de aggregate state in the Analysis menu (Aggregating Data)? If you do that, you will have one mark for each record on your data source.
Best,
Hil

2. Re: Create Mark for every number in a Sum
Ben Fox Jun 24, 2016 3:39 PM (in response to Hildebrando Souza Jr)Yes, I did. That will work only for how ever many rows there are for the data. So in the same superstore example It would give me more marks but not proportional amount. So if a row has $180 profit or something else has $300 in profit they both get one mark. Here it is without aggregate measures
Thank you for the idea

3. Re: Create Mark for every number in a Sum
Hildebrando Souza Jr Jul 5, 2016 12:41 PM (in response to Ben Fox)Hi Ben,
Yes we can! Sorry for taking a while to answer.
In order to achieve that you will need to use a technique called densification (Data Densification  An Intro?? ) and some table calculations to allow you to put one mark or each 1k of your metric (in this superstore case, Profit). Basically, you will need to write a custom SQL and pick a number that will represent the maximum number of bins that you will draw as an parameter in your query, then you will need to create a calculation that will bring a value for just the number of 1k's that you have.
I know this explanation is not so helpful, so I attached the workbook and I hope it will clarify what I meant.
Best,
Hil