3 Replies Latest reply on Jul 5, 2016 12:41 PM by Hildebrando Souza Jr

Create Mark for every number in a Sum

I'm thinking this is likely some LOD calculation, but I've been struggling to find the answer anywhere (which makes me wonder if it's useful). I'm trying to do an info graphic based on a population. I have the sums of people who took it But I want to show each individual person.

For example, in the superstore data If you take  California Profit by category you have \$37,748 in office supplies, \$29,470 in tech and  \$9163 in Furniture. I'd like to make a dollar sign for each of the 1000 thresholds and color them based on category. So instead of this

I'd want 9 moneycases for Furniture, 29 for tech and 37 for office supplies.

I can get the right number through calculated fields, but is there a fairly quick way to make the number of shapes dynamic yet still colored by the category?

Or am I left to just do it in the data?

Thank you!

• 1. Re: Create Mark for every number in a Sum

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

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

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