Get data ready for Venn diagram from customer logins by channel
I want to use the Venn diagram by MAQ LLC visual to show the numbers of customers that log in during a time window (Google analytics data source). I have two channels: "mobile" and "desktop". The Venn will show the count of customers that logged in mobile only, desktop only and the intersection both mobile and desktop. Values should update as I move my date slider filter. My log in data is in this format: A summary of this information can be seen in the Pivot table: The Venn diagram by MAQ LLC requires the data to be in this format... ...where 1 represents use of that chaannel type I've tried various combinations of CALCULATETABLE(), SUMMARIZE() AND ADDCOLUMNS() and INT() but to no avail. Any assistance welcome. Many thanks
