To try something new, I decided to try my hand at creating one of my new dashboards in Dashboard Studio. I'm running into an issue that I can't seem to overcome.
I have a table which is using an SPL as a data source. One of the fields is "zip code" . When viewing the SPL in search, the zip code displays as intended (i.e. 5 characters, with leading zeros in tact). However, when I add it to the table object in DS, it detects that column as a number which in turn cuts off any leading zeros. I have tried everything I can find in the documentation regarding column formatting, but can't seem to convert it back to string.
Any ideas on how to either prevent the table from detecting it as a number, or how to convert it back to string once it's loaded in?
... View more