I am trying to find a way to combine old and new category values into a new explore attribute for reporting. The use case is because we are changing our product value hierarchy but want to be able to link the relevant historical software types to the new products.
Below is the visual:
Would this be done with a standard calculated Attribute?
Need some help with the formula for the calculated attribute assuming that is the correct method.
With the multiple attributes would I be able to visualize each standard calculated attribute together in a Pie Chart or Graph Chart for comparison?
I appreciate the help