YOY data with pre-set date range filters

Q&A
, ,
8

Hi @Nico ,

I went ahead and published the dashboard in Arena

YOY data with pre-set date range filters

However, my requirement changed altogether. At the moment I feel YOY calculated fields I am able to get what the desired outcome is. However, the requirement now focuses on having a table where the user gets to see the # Of Licenses Created and # Of Licenses which Expired based on the ‘$TimeFrame’ a NEW parameter which is Q1, Q2, Q3, Q4, YTD. The $ComparisonPeriod stays the same.

If you see my dataset (image attached below for reference), I have two date columns. One is Created Date and the other one is Expiry Date. I want to just use a single date column and draw the table showing # Of Licenses Created and # Of Licenses Expired.

image
image688×472 15.9 KB

I was able to find a similar request in this post which shows how to merge two dates into 1 single date, but the output is not as expected in my use case. What would be the best method to get the desired result as shown below (the output I want - image attached below). (PS we currently do not use any SQL database where I can manipulate the dataset. The data directly comes from our proprietary software to the S3 bucket and then ingested in Quick Sight. Hence whatever manipulation I need, I have to do it in Quick Sight, if its doable)

image
image411×207 2.22 KB

From the post the calculated fields I create. The # of Licenses Created matches only if the date column selected is Created Date and the # of Licenses Expired matches only if the date column selected is Expiry Date, otherwise the counts do not match.

Any thoughts on this and how I can achieve the desired outcome.

Thanks,
Akshay