Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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?
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.
Yes - works perfectly - thanks again Jagan