I have two graphs that I would like to be overlayed on top of eachother.
The first graph is showing the counts of logged activity per day overall.
The second graph is showing the counts of logged errors per day based on a 'transactions' field that can be filtered.
They use different Date dimensions, but both date dimensions cover the same time period (4 weeks)
Essentially I would like to see how much of the logged errors make up total logged activity.
I created a calculation to filter only one of the PK fields so that it counts PKs based on the transactions field == 0 and counted.
I overlayed, but the main issue is the Calulation1 needs to be filtered by Tuning Event Start Date, while PK should be filtered by Run_dt.
How do I add a date dimension filter to only one of the measures, and the other date dimension filter to the other measure?
Hi Sanjay -
I hope I understand your situation fully. If both time dimensions have the same time frame, why not combining it either using join or blending? It will be easier for you to filter both measures that way.