So I am working with trade data and I have 1 Viz that will filter down a set of trades based on trade type over time. I have this working in a dashboard.
The idea is that one I get that list of trades, with varying start and end date time frames, I want to pivot to that data and perform many types of running averages and day over day profit.
Data in a filtered sheet within a dashboard
|Trade||Start Date||End Date|
Would filter data for analysis as such:
I have aspects for what I want in Step 2 working, and I am filtering to the first table in the dashboard.
I just don't know how to make the jump - any guidance would be GREATLY appreciated! These linkages will be totally random based on filtered criteria.
Thanks in advance