Forum Discussion
av9
Helper III
Helper IIICount 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...
vanessafvg
Community Champion
Community Championin 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?
av9I have a disconnected Segments table, is there a way I can use this is the measure to group the click counts by segment?
- vanessafvg
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?
- av9
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.