hvibberts
Cloud Apps
Joined 3 years ago
User Profile
User Widgets
Contributions
Dynamic Field labeling in Table or pivot
Is there a way to change the field title for a variable in either a pivot or table based on a specific value. More specifically-- we have variables desc1, desc2, desc3..... For each customer what desc1, desc2, desc3 contains or is called by them varies...so for customer a desc1 is region, for customer B desc1 is state and customer C desc1 is county. We have a look up table that contains the detail by customer of what desc1, desc2, desc3 is. How can I dynamically name the variable in a pivot or table widget based on the value in the lookup table? Im wondering if this can be done in either js or even sql as part of a custom table in the elasticube.... Also to note we are already using the metadata translator for multilingual support so using that plugin is probably a bad idea and creates way too much complexity.Hide Multiple Columns in Aggregated Table on display but available for download
Hello All- I am hoping you can help. I have an aggregated table where there are several columns I do not want to see on the screen but want them shown when the table is downloaded. I tried having the column as an option but disabling the "show"...but then it doesnt download. Below is an example: This is what is shown--> I want to hide multiple columns and have it look like this on screen but download everything from the exhibit above: I saw the following code that worked but it only gets rid of 1 column on https://www.binextlevel.com/post/hide-a-column-from-table-widget ....I need to hide multiple. There was other code that you had to list every column and give a percentage but I could not get it to work. Im hoping someone here can help.
