score card calculation for active users that clicked a button

[davelin]

Hi everyone

I'm trying to get a score card % calculation.

We have an event (call it "event1" ) that tracks all button clicks on our home page.  This event is looking for specific ids to fire so we don't actually filter it on the homepage, it just listens for specific button IDs to fire which just happen to only be on the home page.

I just want to get a % of all [active users] who fired [event1] and show the percentage in a score card.

I can't seem to get this simple calculation to work.

Thanks for the help.

[Carlos_Leon]

Hi,

You can create a calculated field to count the number of users who fired event1.

COUNT(DISTINCT CASE WHEN EventName = 'event1' THEN UserId ELSE NULL END)

or 

(COUNT(DISTINCT CASE WHEN EventName = 'event1' THEN UserId ELSE NULL END) / COUNT(DISTINCT UserId)) * 100

[ArkadyZagdan]

You can blend two tables together.
On the left side use a table withh all data and grab users, on the righhht side show Count of Events and use filter to a specific event name. Use the Left Join  and join data on date field. You can now divide event count by number of users and you shhould be good to shhow it as a ration in scorecard.

[davelin]

thank you both, I will need to try these options.