Hi,
I have a calculated field for cumulative count for email which is :
runningSum(distinct_count({email), [{event_time} ASC])
I want to create a line chart which shows the cumulative count vs the time to purchase.
Time to purchase is calculated as the difference between the date mailed and the date the customer purchased. However I keep getting the error : VISUAL_CALC_REFERENCE_MISSING.
Hi @liya101,
When you see the VISUAL_CALC_REFERENCE_MISSING error, it means that some fields that QuickSight is expecting to be in the visual are missing. Are both email and event_time in your visual?
Hi ,
I have added the time to purchase as x axis and the cumulative count as the y axis.
Both are calculated fields. Also line chart is generated when I put cumulative count and the event time. However I want to generate the chart which is cumulative count vs time to purchase.
When I was creating the cumulative count, it did not allow me to put the time to purchase as an input.
Can you share your calculated field for event_time?
event time is the time when customer converted. It is not a calculated field. My intention is to plot the cumulative count of conversions vs time to purchase.
Didn’t you say that time to purchase is a calculated field? Is time to purchase the same as event time?
@David_Wong Time to purchase is calculated as the difference between date the customer was targeted and the the event time (date converted)
It works fine for me. I have a calculated field that calculates the number of days between Order Date and Delivery Date.
I then took your calculated field and replaced your fields by mine.
My line chart looks fine.
Can you show what your values for the Time field looks like? Are they integers?
