how could i have funnel graph to represent 4 calculated field each field in one bar, is that possible?
if not
how could i have many countif function in one calculated field like,
countif(eventname, event_name=“login”)
countif(eventname, event_name=“likepost”)
countif(eventname, event_name=“sendrequest”)
countif(,… and so one)
what to have all of thes values in one column every value stored in row is that possible?
Hey @Muhamad_Nady , welcome to the Quicksight community!
Is your goal to be able to show the same user progressing through these events like login > like post > etc…? Or do you just want to count each time one of these events happen?
From how you have described the problem it sounds like you will need to create a new dataset with custom SQL. You are going to need to use a select statement, pull all of the values that you want for the visual, add a value for interaction_type, and make it equal to a string for one of the interaction options, i.e. ‘Like’. Then in your WHERE clause, only grab rows where count of Like is greater than 0 or not null. Then use the union function in SQL to create each remaining grouping so that it will work with the Funnel Table.
Last note, you will also want to make sure you have a Interaction_Count field in each grouping that will be linked to count of likes, count of logins, etc.
Now you have Interaction_Type for you group by field well, and Interaction_Count for the values.
Here is some documentation for the UNION function in SQL.