Count with Mode function

[#1]

Hi

I am using the mode function to find out the item which was ordered many times with the same quantity during the project life cycle.

The expression that I used to compute the mode is

= mode  (aggr (sum(Quantity), Project, Item))

I need the count of mode in the aggregate output.

I am using this the above expression in the chart and I need to know how much percentage that the same quantity is used in the project.

Please help.

Regards

Mohamed Abubakker

[sundarakumar]

The expression that u have created will return only one value.

What i understand is

u want to know which item was ordered with the same quantity number, very often.for each project.

Pls correct me if am wrong.

-Sundar

[sundarakumar]

Pls post some sample data. I think

aggr(mode(item),project,quantity).

This would fulfill ur need.

-Sundar

[#4]

Hi Sundar

I am using a chart function with the Item as dimention,

Consider the following sample data

Item	Project	Quantity Ordered
Item - A	Project - A	1
Item - A	Project - B	1
Item - A	Project - B	1
Item - A	Project - D	2
Item - A	Project - E	3
Item - A	Project - F	4
Item - A	Project - G	2
Item - A	Project - H	2
Item - A	Project - I	2
Item - A	Project - J	3

Following expression will return 2

= mode  (aggr (sum(Quantity), Project, Item))

I need to know the count of 2.

Thank you.

Mohamed Abubakker

[lironbaram]

hi

attach is an example

but as the example uses a variable

it only can check for the most common value in all the data

[sundarakumar]

Pls correct me if am wrong.

u want to know the number of times the order was made with the same quantity for a particular item.

The particular item would be the item that was ordered the most for each project.

-Sundar

[#7]

Hi Sundar

You are correct. I am interested on same quantity count.

Regards

Mohamed Abubakker

[sundarakumar]

This can be done at the script level.

1. Load an extra field along with the table with value 1 in it.

2. Do a resident load and use group be. Group by Item,Project , Quantity and sum(count) as the aggregate function in the resident load. This will result in the number of times a same order is made in the same qty.

3. now use aggregate in the front end like

aggr(max(count),item, Project){u would not need to use quantity here in this aggregate}

Hope this helps.

-Sundar

[#9]

Like this?

[#10]

Hi Sundar

I cannot load extra table since the record size is more than 10 million. Please suggest any other option.

Regards

Mohamed Abubakker