Hi community, this is my first question here.
I have a page with a list of cards. Each card fires an event “card clicked” with a property “name”.
I would like to graph the percentage of cards that receive more than 10 clicks a day every day, grouped by “name”.
Best answer by sydney.koh
View original
+8
I can’t think of a great way to do this, but following to see what ideas other folks might have. I’d love for this ability!
+10
Hey
Interesting use case. Currently, I don’t see a direct way to select any event as an entity in itself in any particular chart so that we get to choose the times it gets fired in an interval, unlike we can do with users.
The closest I can think off is using the Frequency metric in an event segmentation chart and then switching to a Horizontal Bar view with % Relative toggle, but in pretty hacky way. Similar to this - https://analytics.amplitude.com/demo/chart/new/oxavszb
In this, you’ll have to deal with the pre aggregated bucket frequency Amplitude generates for you. The hacky filter way would be to the use the bar chart view and then in the Search Bar in the Breakdown Table and search for something like “10”.
This won’t guarantee the % graphing as I found that the search bar text filter doesn’t get carried over to the Horizontal Bar view’s Breakdown Table.
If those cards are an important entity in your product workflow and those metrics are something which are of high value, then I would recommend reading about how those cards can be instrumented as groups.
This isn’t a complete practical solution by any means and I would love to hear for any other possible workarounds. Hope this helps.
+8
Hi Luigi!
Saish’s solutions are great workarounds! In the end there is not an exact way to do this out of the box. You could achieve this if you implement some more things. Saish’s suggestion to implement your cards as groups would be the most effective! They you can instrument a group property that denoted whether or not a card has more than 10 clicks a day every day then you can filter for those cards and group them by name. You could use Custom Formulas to make the percentage that you want too https://help.amplitude.com/hc/en-us/articles/115001163231
This solution will require having the Accounts feature as part of your plan as well. Saish’s solution is the closest without any extra implementation!
Let me know if you have any questions.
Best,
Sydney
Still, any other idea is welcome.
+10
Hey
If you have the re-instrumentation bandwidth, then I think the groups approach might work the way Sydney suggested for the amount of cards you have.
Exporting your raw event data and writing the custom SQL for this will be the other way. You can either use recurring exports to the cloud destination of your choice or leverage the Export API .
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
