I have an interesting problem. I would like to convert this chart's X axis into a percentage instead of the absolute number:
![SyncDist.jpg](/legacyfs/online/52422_SyncDist.jpg)
So each bar really should extend fully to 100%, and then I would just see the ratio of the sync results within each bar. I've done this successfully before, but never when using the "class" function.
I can't post the QV file due to proprietary information contained, but here is what I have as the dimensions and expression:
Two Dimensions:
=class(aggr(UserCount,EngagementFileKey),2)
=SyncResultType
One Expression:
=Count(SyncResultType)
//I think this should be something like this, but it doesn't work since UserCount needs to be considered in the class group:
//Count(SyncResultType)/count(TOTAL <UserCount> SyncResultType)
Can anyone suggest how I can get this converted into a percentage bar?
Thanks!