1 of 1 people found this helpful
I'm sure there are multiple ways to do this.
- I would create two calculations (one for each with the filter built into the 'if' statement). I'm not sure what defines 'total utterances' vs 'core vocabulary' so hopefully the calculation isn't too complicated.
- Add them to the same worksheet
- On one of the 'pills' use the small down arrow and select 'dual-axis'
The two measures should now be on the same chart. It also seems reasonable to 'synchronize' the axis so the scales are the same.
You can also duplicate the datasource. Take the utterances and the time field you want to be able filter from the 'master' date source and the 'constant/static looking at everything' utterances from the duplicate. These will join automatically where you need them to join. As above put them on one worksheet and dual axis the chart. It's not possible to filter the duplicate so it remains static regardless of what filters you apply using the master.
If this isn't clear or you run into trouble post a workbook and I'll do it for you.