101 chart question

[#1]

Apologies in advance for what must be a simply answered question

I have a CSV of deliveries during the month of essential form

Part A     delivered May 2

Part A     delivered May 6

Part A     delivered May 10

Part B     delivered May 5

Part C     delivered May 6

Part C     delivered May 10

Part D     delivered May 8

Part E     delivered May 3

Part E     delivered May 6

Part F     delivered May 3

Part F     delivered May 9

Part G    delivered May 2

Part G    delivered May 13

I need a simple chart showing number of occurrences where a part is shipped multiple times a month/period

Occurrences

|

|

|

|                                X

|                                X

|          X                    X

|          X                    X                      X

|----------------------------------------------------------------------------------------------------------------------------------------------

           1                     2                    3                  Shipments

Tks Dave

[jagan · Accepted solution]

Hi,

Try this script

Data:

LOAD *

Inline [

Part, Occurence

Part A,     delivered May 2

Part A,     delivered May 6

Part A,     delivered May 10

Part B,     delivered May 5

Part C,     delivered May 6

Part C,     delivered May 10

Part D,     delivered May 8

Part E,     delivered May 3

Part E,     delivered May 6

Part F,     delivered May 3

Part F,     delivered May 9

Part G,   delivered May 2

Part G,     delivered May 13];

Count:

LOAD

Part,

Count(Occurence) AS Shipments

RESIDENT Data

Group by Part;

Now in chart use Shipments as Dimension and Count(Distinct Part) as expression.

Regards,

jagan.

[#3]

Tks Jagan for such a quick response - yes that works well

Now for a slightly different question.

If I have say 6 months of shipments and I only select the latest 3 months - How would I get a bar chart for that - ie dynamic selection based on month? 

[jagan]

Hi,

Try like this

Script:

Data:

LOAD *

Inline [

Part, Occurrence

Part A,     delivered May 2

Part A,     delivered May 6

Part A,     delivered May 10

Part B,     delivered May 5

Part C,     delivered May 6

Part C,     delivered May 10

Part D,     delivered May 8

Part E,     delivered May 3

Part E,     delivered May 6

Part F,     delivered May 3

Part F,     delivered May 9

Part G,   delivered May 2

Part G,     delivered May 13];

Chart:

Dimension -> Add Calculated Dimension -> Enter =Aggr(Count(Occurrence), Part)

Expression : =Count(DISTINCT Part)

Hope this helps you.

Regards,

Jagan.

[#5]

Yes - works perfectly - thanks again Jagan