Unable to report on 2 separate tags with custom metrics.. | Community
Skip to main content

Unable to report on 2 separate tags with custom metrics..

  • February 28, 2022
  • 1 reply
  • 0 views
J

Hello Team,

I have a custom field 2 separate answers, "-Yes-" and "-No-":

I'd like top create a Line chart or a stacked chart to report on both tags for each week of the year but when I create a calculated metric for each tag I can only seem to pull data for one at a time.

My metric calculations are as follows for the -no- Tag:

IF (INCLUDES_ANY([Ticket tags], "-no-")) THEN
    [Ticket ID]
ENDIF

For the -yes- Tag:

IF (INCLUDES_ANY([Ticket tags], "-yes-")) THEN
    [Ticket ID]
ENDIF

However for some reason it will only pull data for either one of the other depending on which one I create first like below:

I've tried using count, D_Count and Sum and no luck.

Yet when I do a combined query such as: 

IF (INCLUDES_ANY([Ticket tags], "-yes-", "-no-")) THEN
    [Ticket ID]
ENDIF

Then it will combine them into one Column but I want them measure as separate attributes. 

It's been driving me crazy so any help appreciated. 

      1 reply

      CJ99
      • CJ99
      • March 1, 2022

      So, I think you would need to use the main metric of "Tickets Updated". 
      Then you could apply an attribute like this: 

      IF (INCLUDES_ANY([Ticket tags], "-yes-")) THEN
      "Yes"
      ELIF
      (INCLUDES_ANY([Ticket tags], "-no-")) THEN
      "No"
      ELSE
      "Not Selected"
      ENDIF

      You could then exclude "not selected", and would get a chart of just tickets where the value was set to Yes or No, and the ticket had an update during the "updates" date stamp chosen. 


      Terms & ConditionsCookie settingsAccessibility statement