Hi,
The calculated field can either be formatted as a numeric or percent. I don’t see a way to customize based on 2 different formats ( click or conversion rate) .
A work-around is to use free-form layout and conditional rules.
- Create a parameter ( values : clicks , conversion rate )
- Create 2 calculated fields ( 1 for clicks and 1 for conversion rate )
- Create 2 visuals ( 1 for clicks and 1 for conversion rate ) , apply conditional formatting.
- Overlay the visual for conversion rate on top of clicks.
- Hide visual by default for conversion rate. Show only when conversion rate is selected in the parameter.
Selection is sales
Selection is percent of total
Analysis : Conditional Rules
