How to regex a value from string and convert as metric in CJA? | Community
Skip to main content
gautham_madala
gautham_madala
Level 5
October 17, 2024
Solved

How to regex a value from string and convert as metric in CJA?

  • October 17, 2024
  • 3 replies
  • 1292 views

Hello, 
I have a question specifically in CJA data view settings, would like some help. 
I have a string that has the value event345=12 

I have used regex to extract the value 12 and deduplicated this dimension to make it as my metric. 
However since the schema datatype was string its still treated as the same rather making the metric to store the value 12 in it. 
Could someone help me figure out a hack to achieve what I need without the use of derived field ? reason I am not using derived fields are, I guess we get only 100 derived fields as a limit. 

Thanks

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

    Currently in CJA there are two ways to turn a dimension into a metric - derived fields and component settings. 

    If you use component settings to turn a dimension into a metric, it will give you a count of many times that dimension fired, like a counter event. There isn't a way to turn it into a numeric event and have the value in the field become the metric itself (ex, return "12" instead of the number of times "12" fired). Right now, the only way to do that would be through derived fields. It might be worth reviewing your derived fields and see if there are any that can be accomplished by using the component settings instead so that it can free up some space to do what you need to. 

    3 replies

    MandyGeorge
    Community Advisor and Adobe Champion
    MandyGeorgeCommunity Advisor and Adobe ChampionAccepted solution
    Community Advisor and Adobe Champion
    October 31, 2024

    Currently in CJA there are two ways to turn a dimension into a metric - derived fields and component settings. 

    If you use component settings to turn a dimension into a metric, it will give you a count of many times that dimension fired, like a counter event. There isn't a way to turn it into a numeric event and have the value in the field become the metric itself (ex, return "12" instead of the number of times "12" fired). Right now, the only way to do that would be through derived fields. It might be worth reviewing your derived fields and see if there are any that can be accomplished by using the component settings instead so that it can free up some space to do what you need to. 

      gautham_madala
      gautham_madalaAuthor
      Level 5
      November 5, 2024

      I agree, the reason I want to limit use of derived fields is because I have a limited derived fields that I can create(~100).
      Would like to know if there are any other hack.

      Josh Stephens
      Community Advisor
      Josh StephensCommunity Advisor
      Community Advisor
      November 5, 2024

      Hi @gautham_madala 

      I've run into this same issue and I do not believe there's currently a way to extract a number from a string and cast it was an integer.  

      With that being said, I'm building a Report Builder project that accomplishes similar results in Excel.  I'd recommend taking a look that that if you haven't already.

      Wouldn't it be nice if Adobe added the ability to cast as integer soon?  🙂

      gautham_madala
      gautham_madalaAuthor
      Level 5
      November 5, 2024

      Thats what I figured out. I wouldnt want to use report builder. Moving away from excel for reporting and rather use CJA to visualize. Thats my current challenge.

        H
        hegi90
        Level 3
        February 13, 2025

        I guess you have two options here:

        Clientside => change from string to int

        Serverside => use Dataprep mapping for transform it with to_integer()

         

        Both changes need either to change the format of the xdm field, or add an additional. 

        But I agree that would be a great feature to have in CJA, but I guess it is more a data collection topic. 

          Terms & ConditionsAccessibility statement

          Loading footer...