Forum Discussion
Remove Matrix context from a user count measure
Hi Mmerinen - if possible please share dummy data for reference. as per the above situation You need to create a measure that calculates the company price divided by the user count, but you need to ensure that the user count is calculated correctly irrespective of the matrix's hierarchy.
so two measure one for user count and another is for company price per user.
Sharing via google sheets:
https://docs.google.com/spreadsheets/d/1DDKKjMESOiNmrfNEn4ytlYRseY0znOFhBHvLLyvZdCQ/edit?usp=sharing
The data table rows are unique by columns: user_id and service_type. Table show all services for all users and therefor also companies.
If a company has a product that has a price on company level (Trio 1 and Plus 2) then the price should be divided by the user count for the matrix visualization.
The user count changes over time, when users get created and deleted. Info is visualized on a matrix, and the hierachy is created though the levels: level1 -> level2 -> level3 (user)
I also have a separate calendar MRR Calendar, where the active relationship to MRR Clients table is the column: service_billing_startdate