topic Re: using variable to render straight table (expression) in App Development

using variable to render straight table (expression)

dreweezy — Sat, 16 Nov 2024 06:20:59 GMT

I have a straight table with many columns that are pertaining to a sales person within a company. I have 5 buttons, related to that sales person, that I hope will render my table based on the user selecting a button.

if($(vTableFilter)= 1, sum({<SALES_PERSON= {"Michael Johnson"}>} SALES),
if($(vTableFilter)= 2, sum({<SALES_PERSON= {"Jordan Peele"}>} SALES),
if($(vTableFilter)= 3, sum({<SALES_PERSON= {"Kobe Bryant"}>} SALES),
if($(vTableFilter)= 4, sum({<SALES_PERSON= {"Lupe Fiasco"}>} SALES),
if($(vTableFilter)= 5, sum({<SALES_PERSON= {"Magic Johnson"}>} SALES)
)
)
)
)
)

My table doesn't seem to be rendering at all. I did a quick check by adding the SALES_PERSON column within the table and I can see that once I click a sales person (button) it still shows the other 4 individuals. Thoughts?

Re: using variable to render straight table (expression)

Anil_Babu_Samineni — Wed, 13 Mar 2019 14:59:39 GMT

Sugar is the definition of variable

Re: using variable to render straight table (expression)

marcus_sommer — Thu, 14 Mar 2019 09:36:35 GMT

Why so complicated and not just using SALES_PERSON as a listbox?

- Marcus

Re: using variable to render straight table (expression)

dreweezy — Thu, 14 Mar 2019 13:42:42 GMT

End users want something more interactive on a dashboard with buttons since there are only a few sales person. I was able to figure it out - for some reason once I deselected "null values" on the dimensions everything started to work. Thanks.