Reporting on combined category attributes

James Molina

• July 07, 2020 16:09

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

• Hillary Latham

  • July 09, 2020 01:55

  I think a group would help you accomplish what you want.  https://support.zendesk.com/hc/en-us/articles/360022184334-Organizing-values-by-groups-and-sets

• James Molina

  • July 09, 2020 02:39

  @... Thanks for the comment.  I actually experimented with groups and sets and they didn't work.  I was able to create each group.  However, I can't add each of the groups to a single query to create a visualization for comparison.

• Hillary Latham

  • July 13, 2020 23:08

  yeah, I don't think you can create subgroups.  But could you create groups A1, A2, B1, and B2?  

• James Molina

  • July 13, 2020 23:41

  @... Yes, thank you for that Hilary.  I was able to do that but I couldn't place two different attribute groups within the same query.  Did I do something wrong?  Is there another way to add multiple attribute groups to the same query?

• Hillary Latham

  • July 14, 2020 15:52

  Might be a limitation - are they the same attributes in both groups or different ones?  Either way, I would give some feedback for an enhancement to allow multiples. You can make feedback suggestions here: https://support.zendesk.com/hc/en-us/community/topics/360001200913

Please sign in to leave a comment.