Currently, I’m struggling of list and Bubble table for query and return what I want.
I have Bubble table define as following:
| company | plan | coverage | annual payment |
2,100,000 = 100,000+100,000+200,000+200,000+500,000+1,000,000
This mean to offer 2,100,000 coverage, I have to offer 4 plans (100,000 x 2 plans, 200,000 x 2 plans, 500,000 x 1 plan and 1,000,000 x 1 plan)
item 1. list of number coverage (ex. 100,000 , 100,000 , 200,000 , 200,000 , 500,000 , 1,000,000 )
item 2. list of number of duplicate in item 1. ( ex. 2 , 2 , 1, 1 )
Previously, I tried to return 2 dimensional array ex. [ [100000,2] , [200000,2] , [500000,1] , [1000000,1] ]. However, this is not seem to work.
Any help to solve this, very appreciated.