Portals for Tableau New Feature Spotlight: Data Manager Calculated Fields

Data

Portals for Tableau New Feature Spotlight: Data Manager Calculated Fields

The Portals for Tableau New Features series is designed to keep users up to date with all the latest features being added to InterWorks' embedded analytics solution, Portals for Tableau.

Do you ever feel like your computer should do more of the heavy lifting? You had to pay good money for it, and it eats a lot of your electricity. Why should you have to work harder than you need to instead of making that freeloading box of wires and lights make your life easier? The Portals for Tableau team agrees with you. We’re doing what we can to make your computer work for you instead of against you.

If you’ve ever used your Portals for Tableau data manager, you may have had a field that was a simple calculation of other fields. If you did, you had to spend your precious brain power performing that calculation instead of putting the computer to work. We say, “No more!” Now, you can set up that calculation in the data manager to do the work for you.

We’ve added a new field for building calculations to data manager groups.

For example, if you have a quarterly sales field that is just a sum of your October, November and December sales fields, you can set it up as follows:

Portals for Tableau data manager calculated fields

Now, when you are filling out the form, it will automatically update the Quarterly Sales field whenever you fill in each month’s sales figure:

quarterly sales in calculated fields data manager

Another example is if you need to concatenate (a fancy way of saying glue together) several fields, you can set it up as follows:

concatenate with separator in data manager for Portals

This will automatically glue the First Name field to the Last Name field and separate them with a space (hard to see in the above screenshot for obvious reasons, but it’s there).

concatenated fields in data manager for Portals

Feel free to warn your computer now that there will be no more free lunches. It has to earn its keep.

More About the Author

Matthew Orr

Solutions Architect
Portals for Tableau 101: Filter Blacklists and Averaging The advanced filtering capabilities are some of the most popular features of the portal product. These are made possible by Tableau ...
Portals for Tableau 101: Multi-Tenant Architecture Several of our clients utilize their portal to show dashboards to numerous clients of theirs in a multi-tenant architecture. Unlike ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072