Hi,
I am new to Quicksight and trying to use calculated field. I have created 2 columns
PrevCount: lag({eventdata.packagecounter}, [{timestamp} DESC], 1, [{standardtagnumber}])
AvgCount: avg({eventdata.packagecounter})
After saing the fileld the bottom dataset view shows unavailable. Am I missing something?
@P_K_PATRA - Welcome to the Community! Thanks for posting your query. Since LAG function is a level aware calculation, those can be only visible at the analysis level as that involves active context. I would request you to publish the dataset and visualize the dataset via an analysis. Try to pull one table visual and drag the calculated fields with other relevant columns; you should be able to see the values based on your logic. Hope this helps!
Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!
Thank you. I am able to plot the data in Analysis.
