Save and reuse custom functions in calculated fields

Question & Answer
1

I have a few custom field operations that I use many times in dashboards and datasets. E.g. mapping currency numerical codes to human-friendly names, currency conversions, etc.

It would be great to be able to save and reuse custom functions in calculated fields.

Thanks.

1 Like
2

Hi @Gabriel_R - I guess you can create the calculated field and save it, however it is specific to the data set level. If the same mapping or function is used across your eco system, better to create a look up table and used it as a join to your data set and maintain it at DB level.

Regards - Sanjeeb

2 Likes
3

Thanks @Sanjeeb2022
That would work and would improve things, but:

  • it’s more work and more complex
  • not a single point of truth, as the logic is not centralized
  • an extra join is bad for performance
4

Hi @Gabriel_R - Thanks, performance may be a bottleneck. but in DWH world we usually store the look up at database level. By saying that let’s hear from other experts in the community. We need some kind of look up concept in QuickSight.

Hi @Koushik_Muthanna @David_Wong @Naveed @eperts - Please give your advise on this.

Regards - Sanjeeb

1 Like