Dynamic Field Formatting

Q&A
, , , , ,
1

I have a calculated field who’s output is driven by a parameter.
ifelse(
${param}=‘Revenue’,{revenue},
${param}=‘Attainment’,{attainment},
0)

{revenue} is set as default format as currency in the analysis
{attainment} is set as default format as percentage in the analysis

I would like the calculated field to inherit the default formatting of the underlying fields. ie when Revenue is selected in the param control, then the calc field should not only show {revenue} but show {revenue} as currency. likewise, the calc field should show {attainment} formatted as a percentage when Attainment is selected.

I am aware of workarounds for this in Insight type visualizations using additional ifelse statements within the vis. For my use case I am referring to all visualization, not just Insights.

To add one more note. I’ve seen multiple questions here regarding dynamic currency representations, enabling the functionality I am requesting will allow for correct currency representation controlled by a parameter as well.

3 Likes
2

Hi @BrianJager,
Thank you for bringing this to attention. I agree that both of these functions, the calculated field behavior and the dynamic currencies would be nice additions. So I’ll mark this as a feature request to provide further visibility to the support team!

3

Hi @BrianJager,
It’s been awhile since we last heard from you; while I’ve marked this as a feature request, I wanted to see if you had any additional questions as well?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

4

Hi @BrianJager,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!