Category
Report Builder
Product Version
7.3
Convert a metric to a dimension
Answered
I need to convert the Metric (Year) to a dimension so that i could use in Set Analysis.
Much appreciated
The same question
Hi Dayalan,
I am going to respond here rather than our previous thread which I will close shortly (let me know if you run into problems with that and the case will re-open).
This will need to be done at the view level. I you use your year as a metric elsewhere, I would suggest dragging in another copy of that field, so you can have one of each. In 7.3 the field type can be set here:
Please let me know if this is not applicable to your version (this is slightly different for 7.1 and 2), or if you have any questions on implementation.
Regards,
Nathan
Hi Dayalan,
I am going to respond here rather than our previous thread which I will close shortly (let me know if you run into problems with that and the case will re-open).
This will need to be done at the view level. I you use your year as a metric elsewhere, I would suggest dragging in another copy of that field, so you can have one of each. In 7.3 the field type can be set here:
Please let me know if this is not applicable to your version (this is slightly different for 7.1 and 2), or if you have any questions on implementation.
Regards,
Nathan
Replies have been locked on this page!