cancel
Showing results for 
Search instead for 
Did you mean: 

Frequency of attributes countable?

Former Member
0 Kudos

Hi,

we want to find out the frequency of an attribut in our variable data.

For example,we upload the name of a customer, the sales and the invoice number. Is it possible to give out the name and the number of invoices the customer has received to create a nice chart with these data?

Thanks

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member188325
Active Contributor
0 Kudos

Hi,

have a look at this:

do u need to count no of invoices ?what are the other chars u have in rows of u r designer?

regards

0 Kudos
Former Member
0 Kudos

Hi,

Yes it is possible using the count function by creating a RKF and CKF.

Former Member
0 Kudos

Maybe I've asked the wrong question. We are able to get these intermediate results using RKF and CKF.

However, we would like to calculate with these data without changing our infocubes.

Thank you

former_member188325
Active Contributor
0 Kudos

Hi,

could u pl tell u r problem in detail?

regards

Former Member
0 Kudos

Sure, because we need it quite urgent.

We load the following information into our variable data:

ProductID, Selling time and date ,invoice number, customer ID, quantity.

For example, if the customer buys a bottle of water, a box of coke and two bottles of wodka, we'll upload the following information:

ProductID, Selling time and date ,invoice number, customer ID, quantity

5001, 12:12 2005-12-12, 1000, 999999, 1

4012, 12:12 2005-12-12, 1000, 999999, 1

3892, 12:12 2005-12-12, 1000, 999999, 2

If the customer buys again something, e.g two bottles of water, three boxes of coke and two bottles of wodka, we'll upload the following information:

ProductID, time/date ,invoice number, customer ID, quantity

5001, 12:12 2005-12-15, 1015, 999999, 2

4012, 12:12 2005-12-15, 1015, 999999, 3

3892, 12:12 2005-12-15, 1015, 999999, 2

So, what we need to have calculated, is the number of times he has purchased something, in this case - 2 times.

Is it now possible to count the number of same invoiceIDs to find out how often a customer appears in our shops or to calculate the average volume of sales per customer per purchase?

Former Member
0 Kudos

Hi,

Yes it is possible to find based on n invoices. You even have selling date & time. So if is in the variable you should go for an exit I believe.(Query level na...)

former_member188325
Active Contributor
0 Kudos

Is it fine to have no of invoiecs?i.e 6 in u r example.??

regards

Former Member
0 Kudos

No, this is unfortunately not sufficient.

We do not need the no of invoices, we need the quantity how often the customer has bought something, so 2 in my example...

former_member188325
Active Contributor
0 Kudos

u mean ...no of same invoices?

regards

Former Member
0 Kudos

Exactly - the number of same invoices is what I need!

Any idea for that?

former_member188325
Active Contributor
0 Kudos

rght now i do not have system to try out.so...will try out and let u know by tomorrow...wait for some good answers from experts.

regards

Former Member
0 Kudos

Hi,

Yes if you want the no of same invoices for a particular customer u can do it in exit as I said.

Suppose a customer may have many no of same invoices, even then you can do it in the exit logic.

former_member188325
Active Contributor
0 Kudos

Hi,

i got half solution for it.

try out this:

i assume u have ProductID,Selling time and date,invoice number and CustomerId in rows and Quantity in columns.

chars should be in the following sequence in rows.

1. Invoice number

in properties,set Suppress result rows always/never and no normalization.

enable sort order,by 'key' in ascending/descending order.

2.Customer ID ( or ProductID )

but set Suppress result rows 'never' .

3.ProductID

Suppress result rows 'always'

4......

for all remaining Suppress result rows should be set to 'always'.

Then in columns-Keyfigures structure,create a formula (Quantity>=0). and set 'Calculate result as' 'nothing defined'. (here i assume if there is no Qty,then no invoice)

after Executing Query u will get 'Report result' rows (sub result rows).and values as '1'.

here the no subresult rows are no of same invoice numbers.

for ex:if u have 4 subresult rows (yellow color rows),it means u have 4 invoices.

i dont know how to count these subresult rows...if u can count these subresult rows (result rows)....then its over...

hope this helps.

regards

former_member188325
Active Contributor
0 Kudos

HI,

is u r problem solved?

regards