Bar Graph - Rounding
-
If I have all of my data for a certain category in fractions and I set the "Decimal places when abbreviated" to zero, it shows up as 200m, 300m etc (The original values are 0.2, 0.3). Ideally, I would like no bars to be shown, but since they do, is it possible to just round these values to zero. If I have a single value >= 1 , then they show up right.
Please see attached file.
VijayAttachments
Test.iok 9K -
1 Comment
-
If you want the displayed bar height for fractional values to be rounded (in this case to zero-height disappearing bars), you can do this using a formula measure.
In the measures menu, you currently have "Value, Sum". Replace with a "Formula" measure. The equivalent formula would be:SUBSET_SUM([Value])
but you want:INTROUND(SUBSET_SUM([Value]))
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.