Skip to Content

Lumira Discovery - Custom Calculation with linked datasets

Dec 12, 2017 at 01:58 PM


avatar image


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?


Hello Tammy,

I use the link function, not the merge.


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


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)


Do you need more informations ?

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

0 Answers