Sum of 2 columns based on same ID

Hi ,

i have this data above, i would like to sum pageview & screenview group by that same article ID to achieve the “Total View”. I looked into sumOver function, but it seems to only accept 1 measure/column. Any workaround for this?

Hello @LeonardLai - Thank you for posting your query. Did you categorize the Pageviews, screenviews and total View columns as measure and Article ID as Dimension? Please also ensure that you are putting the Article Id under the Group By and the measures under values. Hopefully this will help. Please let me know. Thank you!

Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!