When will data bars be upgraded to allow setting a max and min value? For example, I have % progress and want to display a column that visually demonstrates progress towards 100%. If there’s no anchor value at 100%, it shows the current max value as ‘full’. This really doesn’t meet the visualization purpose. Same question on heatmaps as that’s thrown my users issues as well.
Hello @SYork !
I was able to achieve a version of this with the calculated field below. Are you able to share an anonymized version of your calculated field?
percentDifference(sum(Sales),[sum(Sales) DESC],1)
1 Like
Hi Duncan,
Perhaps the total at the bottom of my screenshot sent us astray, but I’m not following how percent difference will help here. The percents are specific to each facility, demonstrating progress that facility is making towards a goal. They don’t interact between facility, and so there isn’t a field to aggregate across for the [field, ASC/DESC] step:
percentDifference - Amazon QuickSight
Is there another calculation that would let me show the data bars relative to 100% as demonstrated below? In Excel, I’d just set a max and min:
Thank you
@SYork I did not know that your dataset did not have a relative attribute for your Facility field. I will mark this as a feature request.