Capture multiple values via Classifications? | Community
Skip to main content
M
mjdavid007
Level 3
March 1, 2024
Question

Capture multiple values via Classifications?

  • March 1, 2024
  • 1 reply
  • 1389 views

Hi, I'm working with Classifications, which have proven to be very useful when it comes to give more value to our data. We are facing now a challenge, though: some of the classifications might come with multiple values on the same cell. For instance, let's imagine we have an activity ID, which is captured on an eVar, then we use classifications to give this activity more attributes:

  •  Key: activityID

    • activityName: Webinar on shoe industry in Germany and France
    • activityType: Webinar
    • activityMarket: Germany, France

The problem is that, although I could split that activityMarket into two, I need to allocate them on the same classification level (activityMarket, in this example). I cannot create another classification with the same name, and create a different one, like activityMarket2, would not be useful for us as we need to breakdown only by activityMarket and allocate all values there.

 

Any thoughts on this?

 

Thanks a lot.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    RobertBlakeley
    Community Advisor
    RobertBlakeleyCommunity Advisor
    Community Advisor
    March 1, 2024

    Help me understand.

    You cannot do this:

    • activityName: Webinar on shoe industry in Germany and France
    • activityType: Webinar
    • activityMarket: Germany, France
    • activityMarket2: Germany

    But if you get:

    • activityMarket: Germany, France
    • activityMarket: Germany, UK
    • activityMarket: Germany, Italy

    You want a value to see the total allocation for Germany.

     

    • activityMarket: Germany, France     5
    • activityMarket: Germany, UK           2
    • activityMarket: Germany, Italy         1

    So in the above, you want to see Germany = 8, UK =2, etc.

    Is that correct?

    M
    mjdavid007Author
    Level 3
    March 1, 2024

    Hi @robertblakeley , it is as follows: imagine we have 3 activities that receive, on their activityMarket classification, the following values in one simple cell:

    - activityMarket (for activity 1): Germany, France

    - activityMarket (for activity 2): German, UK

    - activityMarket (for activity 3): UK, Italy, Germany

     

    When we use activityMarket in Workspace, we would like to have:

    - activityMarket:

    • Germany: 3
    • UK: 2
    • France: 1
    • Italy: 1

    I hope now it's easier to understand.

    RobertBlakeley
    Community Advisor
    RobertBlakeleyCommunity Advisor
    Community Advisor
    March 1, 2024

    You can always filter the activityMarket report by Germany, UK, etc .and use the report totals value.

    I don't think you can use a list variable as that only applies to the parent variable, not the classification.

    You could use a sub-classification but if you could do that, you could probably also do an activityMarket2. So that does not seem to be an option.

    I am out of ideas.

     

    Terms & ConditionsAccessibility statement

    Loading footer...