What is the problem or goal the end user is trying to solve or accomplish?
Be able to change the format to dollar vs regular number separately within a pivot table or time-series table
How are they solving it currently?
No formatting is applied, because a dollar D3 format will be applied to all columns, even though some columns aren't monetary
What is the recommended solution by the Customer?
Be able to customize per column the format for a pivot table or time-series table
This is now available for the Interactive Pivot Table. Use the Customize tab and look for the "Customize columns" section
This issue is also seen in the new 'Interactive Pivot Table' chart type. It only allows 1 metric formatting, applied to all metrics. If you have 3 metrics - say a count (should be represented as an INT), an average (should be represented as an DECIMAL), and a percent (should be represented as 100*DECIMAL), this is currently not possible.
I would note this needs to be able to be customized per column or row. In my particular use case, I'm pulling in multiple metrics in one time-series table. Some rows need different D3 formatting (see example screenshot, t
One thing that would make this even better (and may require less UI work)--> if no D3 formatting is applied to a particular time series column, it should just inherit the D3 Formatting associated with the metric pulled into the chart. It's annoying to have to reconfigure the D3 formatting when I've already set the D3 Formatting for a particular metric at the dataset level.