Forum Discussion
Count totals for Dynamic Group
Hi, I have a specific query I am trying to solve for. I have a table that looks like this which has Customer, Unique Click Count(Measure), and Segments(Measure). I am trying to G...
in order to place the categorical segments on the axis it needs to be a column not a measure so you will need to do some remodelling of your data. Did you want a separate table for segments?
I have a disconnected Segments table, is there a way I can use this is the measure to group the click counts by segment?
you can only slice a measure by categorical data, you can't slice it using a measure.
There are other ways to model this data but it all depends on why you are trying to do it the way you are, as there are other ways to model this. What is your objective?
The objective is to display whose clicking on articles based on their invested segment. I think I'll try a switch measure and link to the disconnected table using SELECTEDVALUE.