Dynamic Field labeling in Table or pivot | Help and How-To

hvibberts · 2024-06-04T15:02:35.930000Z

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.

MoreDiscussions

Dynamic Field labeling in Table or pivot | Help and How-To | Sisense Community