Reports 2.0: Ability to change X or Y axis numbering to exclude decimal notation

Hi Jeff,

If we automatically detect whether decimals are required based on the available dataset, will that work?

Thanks,
Sumesh

Yes I believe that would work.

Any update on this?  The decimal places look very unprofessional on reports where you are reporting on items that cannot be "half" like Cases, CTAs, etc.

Hi Jeff,

This enhancement request will be executed in the next 1-2 months

Thanks!

Hi Sumesh - any update on this?

Jeff, let me follow up on where this pebble is. Essentially what we'll do is, the aggregate number will have same decimals as maximum decimals on any entry in the data set being aggregated. does that work?

Thanks Gaurav - could you provide an example so I'm clear?

Yeah an example would be great. In reading your answer, it appears that if the data set has numbers with 2 decimal place precision, then the graph will also have that. If the dataset is all rounded up to no decimals, the graph will also have that.

Can you confirm if this is true of all numeric columns or just the specific column? Also what about count of IDs or Names, that do not have any decimal place precision? 

I actually misread original issue, that it's about label of axis. 

Ok so in general anything that plotting a count (or count distinct) will always have axis by whole number. If the aggregate is a sum, average, min, max (only available if underlying field is numeric) the axis will be 2 or decimal points of value in that field with most decimals. E.g. if I plot average of ARR across customers, and ARR field has 2 decimals axis will have 2 decimal. But if I plot average age of CTAs across customers, this will whole number since age is calculate in days, not fraction of days. Of course if it is count of support cases by (anything) will always be whole.

For bar, column charts, line you can only plot 1 value, so the X or Y axis. For scatter charts or bubble charts you can plot a value each on X and Y axis, e.g. average of AGE maybe on Y axis and average of ARR can be on X axis. So Y axis is whole, where X axis is 2 decimals. Makes sense?

Hi Gaurav, I don't think your explanation with respect to CTAs is accurate. Please see the attached image