First 12 Months Since Launch Calculated Field

I am looking to for a calculated field that shows the number of views (view_uuid) in the first 12 months since launch (C.Created_at) for multiple companies that have different launch dates.

Ideally, this parameter/filter can be show on a line graph with month 1, month 2, month 3 etc. as the x axis instead of the actual date and year.

Let me know if you need anymore information.

Hi @Quicksightnewguy,
maybe you can use dateDiffto check the 12 month and ifelse to get the value.

e.g. ifelse(dateDiff({C.Created_at},now(),'MM')<13,1,0)
Then you can use the new field and month in you line chart
BG

1 Like

Hey Erik,

Thanks for responding. Your formula worked. However, it’s not charting on the line graph or showing me that month 1, month 2, month 3 etc. I have the date on the X Axis, your formula as the value, but the data isn’t populating and it’s still showing the date on the bottom. I’ve attached a screenshot. I know I’m probably doing something wrong since I’m new to quicksight.

I always start with a table in that case to see if the caltulation is doing anything.

Hi @Quicksightnewguy
did you found an solution?
BR

1 Like