Ok Got it, essentially you need event code as well in your report. Let me explore on this and get back… @Biswajit_1993 any quick tips here… the max date is coming now… all need now to have the corresponding event code… Thinking of a parameter and put a filter on the parameter… but have to do the poc.
Regards - San
HI @Sanjeeb2022 no need to add any parameter because everything looks fine just a minor change needed nothing more I think.
Ok, can you share the quick tips here… hope you got the problem
hi @aaron000000001 ,
I am trying to replicating the same field value into my analysis I got the below details.
These are the below calculated field list.
Just checked once like your event_date is a Date Field or String type
Hi @Sanjeeb I am doing the analysis by using the same data and replicate in QuickSight analysis it is working fine for me.
Hi @aaron000000001 have you got your answer or do you have any query please post it so that you can clear in each steps.
Thank everyone for all the help, I ended up converting to a table and just making filter for event code. Not the most automated process but it works!
@aaron000000001 if your data source is a relational system, you can use custom sql and filter the data before exporting to analysis… how you glad you found a solution.
Regards - San
hi @aaron000000001 good to know that you have found your solutions.
