If the Ask & Bid prices are close to each other,
then they could be shown on a separate view --
with the Y-scale set to Automatic and Not include Zero.
Can you share a workbook with sample data.
This is confidential data. I can not share it.
I should be able to show both ask and bid price as shown in the screen shot attached.
Looks like the two pictures are from the two workbooks
you've got already opened in your Tableau Desktop, right?
Then simply make changes to the Pills on your 'first' view
to look the same as on your 'second' one, namely:
-- change the 'Hour(New Tic Time)' pill to be Continuous (Exact Date).
Or at least the minimum granularity that exists in your datasource.
-- Make both green pills on Rows a 'Dual Axis' (the option is on the rightmost pill).
Then Synchronize Axes (next option there).
-- Then choose the aggregation of both green pills on Rows to be the Average
(they are SUM now as i can see).
-- Last but not least, make the Axis (on the left green pill on Rows) to Not include Zero.
Hope it could help.
Please, choose AVERAGE aggregation for both Measures on Rows (not the SUM).
Still they overlap
The data range is kind of
Ask Mid Bid
1.338867 1.339047 1.339226 1.339226 1.339495 1.339764 1.340123 1.340393 1.340662 1.340303 1.340393 1.340483 1.340303 1.340393 1.340483 1.340303 1.340393 1.340483 1.340303 1.340393 1.340483 1.340303 1.340393 1.340483 1.340303 1.340393 1.340483 1.340303 1.340393 1.340483