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
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.
