I want to plot a stacked bar combo chart.
I want to see the number of conversions for each time to purchase and also plot the line chart for conversion rate that is number of people converted / number of people targetted.
The number of people targeted should not be affected by the time to purchase filter . However the bar chart is plotted against time to purchase.
Is there anyway to plot a line graph in the same chart where the number of people targetted is not affected by time to purchase.
Hello @liya101, I have a few questions about your expected visual to try and guide you further on this question. Are you setting the Time to Purchase as the x-axis for your visual or is your x-axis a date field? We may be able to work something out where you utilize build the converted / number of people target using LAC-W functions if your x-axis is a date field. It would look something like this: sumOver({converted}, [{date}], PRE_AGG)/sumOver({targeted}, [{date}], PRE_AGG)
With more information about how your visual is formatted, it’ll be easier to guide you. You can also recreate this in QuickSight Arena so I can look at your fields and the visual to assist within a QuickSight console.
