Charting 2 Different Measures Fields

Hoping someone can help me.

I'm working with a dataset that breaks out the Number of Questions asked (by users) as two different measures fields (in screen below) as:

  • NoOfAudioQuestionsAsked
  • NoOfTextQuestionsAsked

I don't have access to the lineage to change this dataset and must work with it.

Is there any way to bar chart such that each bar for a period displays the total of both fields above breaking the bar into Audio Asked vs Text Asked?

Thanks for any thoughts on this.

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Add your other metric as a Series. Since it's a metric and not a dimension it will treat your y-axis and series as two separate series.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Add your other metric as a Series. Since it's a metric and not a dimension it will treat your y-axis and series as two separate series.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Hit the Staples button Grant…That was easy!