Help on Grid Chart

[sayadutt]

Hi Team,

When I am using the Grid chart, below is what I am getting which needs few modifications:

1) Y-axis (time) should be in integers only (no decimals)

2) the size of all doubles should be same

3) color of each doubles to be same (if possible)

Below is something which I am looking for:

[vishsaggi]

Can you share a sample app you work on ?

For your timetaken try using this?

= Num(TimeTaken/60, '#0')

[adamdavi3s]

As above for your time taken.

For the size, simply set the expression to =1

For the bubble colour, change the background colour of the expression

[sayadutt]

Hi Nagaraju,

when I use = Num(TimeTaken/60, '#0'), i see below:

i just want to hide the multiple occureance of numbers in y-axis.

Below shows 5 occurrence of 1, 7 occurrence of 2 etc.

I need 1 each.

[sayadutt]

Thanks Adam.

However

when I use = Num(TimeTaken/60, '#0'), i see below:

i just want to hide the multiple occureance of numbers in y-axis.

Below shows 5 occurrence of 1, 7 occurrence of 2 etc.

I need 1 each.

[vishsaggi]

Can you share a sample app to work on?

[sayadutt]

Hi,

I have attached 1 sample in the original post

[antoniotiman]

Hi,

try

Floor([Time Taken]/60)

Regards,

Antonio

[vishsaggi]

Can you try what Antonio suggested and let us know if that i what you are looking for ?

OR

Using Antonio's suggestion try this?

= Floor(Aggr(Sum([Time Taken])/60, [Start Date Only]))

[sayadutt]

Unfortunately, this time all bubbles are at integer axis.

For example if the value is 1.5, i want the bubble to be in between 1 and 2. But your solution will put that at either 1 or 2, but not in between.

See output of above: