Forum Discussion
Top 3 flags being removed
Hi,
I'm needing help with a measure to get the top 3 support needs being removed on a month to month basis.
I have a transactional table, "CUSTOMER_FLAGS" with customers, "CUSTOMER_FLAGS"[Customer], that have flags against them for support needs "CUSTOMER_FLAGS"[FLAG_ID]. Customers can have one or more flags against them.
I have a date table "DATE"[Date], and relevant date columns in my table connected to this are "CUSTOMER_FLAGS"[ACTIVE_AT], "CUSTOMER_FLAGS"[EXPIRES_AT]. The "DATE"[Date] column is connected to "CUSTOMER_FLAGS"[ACTIVE_AT].
I also have "FLAG_REFERENCE" table with "FLAG_REFERENCE"[FLAG_NAME] to define what the flags are, [FLAG_ID] '103' = FLAG_NAME 'I need help with reading' etc and is connected via "FLAG_REFERENCE"[FLAG_ID] to "CUSTOMER_FLAGS"[FLAG_ID].
I need to see on a month to month basis, the top 3 support needs that are being removed; this is to see which support needs customers are needing less over time.
I have struggled with this as it's both needing to get the support needs that are being removed over time, not the number of customers, but also with the added necessity to see it as the top 3 being removed.
Many thanks in advance,
Data-Papa.
1 Reply
- AnonymousNot applicable
Hi Data-Papa ,
Could you provide some screenshot information and describe it, it would be great to have test data.
Best Regards,
Adamk Kong