In the Discovery Mode, I know that we can create a query (e.g. type: http) to filter out data before building visualizations. However, I do not want to do that. I need the unfiltered data.
I want to create a Data Table in Visualize Mode with its 2nd column to display count where Attempt = "Failed". No. of Failed Attempts is subset of Total No. of Attempts. Can we filter data at the chart-level in Visual mode?
Total No. of Attempts: count of Attempt
No. of Failed Attempts: count of Attempt where Attempt is "Failed"
|Session #||Total No. of Attempts||No. of Failed Attempts|