Comments
-
Hi brycec, thanks for your comment. The drill down would be from a table that shows the average response for each question, aggregated by program. Could you assist me in how to create the drill down chart based on the format of the data? I'm having a hard time nesting the bars by question.
-
I think I might use something like this in a MySql transform: SELECT * , (SELECT COUNT(1) FROM `attendees` p WHERE p.`Email`=s.`Email` AND p.`Event Date`<s.`Event Date` ) AS 'Previous Attendance Count' FROM `attendees` s This will give me a count of how many sessions they have attended, with the first one being '0'.…
-
@jaeW_at_Onyx I'm not sure if I totally understand how I could use the percent of the total. This would assume that I know how many people could possibly attend, which I do not. Basically, I need to know out of all the attendees for each session, how many have already attended any previous session.
-
In the "mult-value" card, when I change the date filter to be the previous month, does it also filter the "Change Value"?
-
I tried that but it only returns '+3' for all of the data. I need it to find how many trainings has each individual completed. Does that make sense? In my fake data example, I would need to show that Joe has completed 2 and Mary has completed 1 so I have 1 user that has completed 2 and 1 that has completed 1. Thanks for…
-
Yes, I believe you are understanding. For the case statement, what would you have as the output? If it's a past month, then ___ ?
