Skip to Content
0

Lumira Discovery - Custom Calculation with linked datasets

Dec 12, 2017 at 01:58 PM

54

avatar image
Former Member

Hello,

I need to do a custom calculation over 2 linked datasets :

Table A : Reservation

Table B : Sales

tables are linked by Client ID

I need the percentage of people who booked on the number of people who bought.

Every Sales is linked to a reservation.

This works, but i a filter is applied on the Sales tables, for example, peple who bought product A, Lumira give 100%, because 100% of people who bought A made a reservation.

I my calculation, i need the total number of reservation. How can i do ?


Thank you

10 |10000 characters needed characters left characters exceeded

Thierry -did you do a merge or blend when you linked the datasets?

0
Former Member

Hello Tammy,

I use the link function, not the merge.

0

can you share more details of the filter? Maybe a screen shot?

0
Former Member

This is the working chart :

and this happen when a filter on a product or a color on Product is add :

capture.png (43.7 kB)
capture2.png (55.0 kB)
0
Former Member

Hello,

Do you need more informations ?

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers