Forum Discussion
Creating time series visualization from data snapshot
Hi,
I do not know why you see that. This is what i see when i click on the link
Thanks! I think because I was downloading your file in a mac, it was by default zipping it to download. When i tried to download your file on windows, it worked! Thanks a lot for sharing it 🙂
Hi,
That is exactly the transformation i have been able to achieve in the Query Editor. Please go to the Query Editor and study the steps there.
You are welcome.
Hi Ashish, I tried your solution and it gets me close to what I need, but there is a small hickup. My data looks like this:
Project name Stage 1 entry date Stage 2 entry date Stage 3 entry date A 1/1/2021 2/1/2021 B 2/1/2021 3/1/2021 5/1/2021 C 2/1/2021 3/1/2021 6/1/2021 when I pivot the table to get it in this format as mentioned in your solution, since I only have stage entry dates and not dates when a particular project stayed in its stage: e.g. the above table doesn't explicitly tell that project C was in stage 2 from 3/1/2021 to 6/1/2021. I thus don't have the highlighted rows shown below. It seems like I will have to fill rows for each and every project that corresponds to every month between stage entry dates, in order for the projects to be counted in months in which they did not move to other stages:
Can you help me understand how I can achieve this? I hope I am clear in my explanation above!