Highlighted
Community Boss

Dynamic Table

Hi Guys,

 

I need some assistance on what approach to use here. Below is the description.

The clients report consists on a table where they input the No. of Bldgs. and on another report those numbers of bldgs will be spread out.

 

Jsdeloria21_0-1590593750126.png

The result on the Target module will be

Jsdeloria21_1-1590593780389.png

 

Another example will be

Jsdeloria21_2-1590593813885.png

and the result on the target module will  be

 

Jsdeloria21_3-1590593838064.png

 

So its like a dynamic table depending on the input of the client.

Is this like a numbered list because I never encountered something like this before.

 

Appreciate the assistance

 

Regards,

 

 

5 REPLIES 5
Highlighted
Master Anaplanner/Community Boss

Re: Dynamic Table

@Jsdeloria21 ,

 

So, how many total towers as in what is the max?  Can you not just define x number of towers and then use filters to show the correct number?

 

Rob

Highlighted
Community Boss

Re: Dynamic Table

Hi Rob,

 

to be honest in the sample report that the client sent us. The No. of bldgs they inputted on their Assumptions was 16. That is same sample I gave you. But let us say maximum they have is the 2nd example 4 bldgs. The client has not confirmed the maximum towers as of posting.

 

Appreciate the response


Regards,

Highlighted
Regular Contributor

Re: Dynamic Table

Hi @Jsdeloria21 

 

If I assume right, based on no of towers they want to show, you have to filter the towers list,

 

you can create a filter module which will be true as per the input entered, so i added a property tower number in the list and it is showing towers for which tower number <= input number and it shows all towers in case it is blank 

 

Kanishq17_0-1590598747845.png

 

then simply you can apply this as a filter to the target module and publish it on the dashboard

Kanishq17_1-1590598944670.png

Kanishq17_2-1590598993940.png

note- dashboard has to be refreshed after entering the number

 

Kanishq17_3-1590599046127.png

 

Highlighted
Community Boss

Re: Dynamic Table

Hi Kanishq17,

 

With some new information from client with regards to this query, I have some questions on this

1.  On the screen shot below, the module below with filter tower line item, is this a module with a List on the rows pertaining to a fix number of towers? 

Jsdeloria21_0-1591684741326.png

2. in the formula, ISBLANK(inp.No of buildings) or Towers.number tower <=inp.Buildings val. Where is Towers.number tower present? In the list of in the module?

 

Appreciate the response I am currently re-building the current design base on this approach

 

Regards,

 

Highlighted
Regular Contributor

Re: Dynamic Table

hi @Jsdeloria21 

 

1. as per your requirement , you said that the user can enter the no of towers needed to view, so that filter has tower list as the dimension to filter. so it will contain entire list as the dimension, i added only 20 as an example

 

2. Towers.Tower number is a property of the tower list, basically it counts sequentially all the towers added , then this property is used to match the input value

Kanishq17_0-1591712452276.png

Kanishq17_1-1591712691170.png