Aggregated measure based on custom X-axis Scale

[shyamcharan]

Hi Experts,

I have a requirement where the user should be able to change steps of the X-axis scale like he can use 250 or 500 or 1000 etc..

I was able to achieve it with a few variables, however, the graph does aggregate based on the scale. I want the graph to be aggregated or modified based on the x-axis values.

Can someone please suggest how i can achieve this?

thanks in advance.

Regards,

Shyam.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw. Is that what you want?

[shyamcharan]

Thanks Gysbert. That works like magic.

Could you please share what made this work?

Thanks heaps.

Regards,

Shyam.

[shyamcharan]

Hi,

Sorry just a bit confusion on the X-Axis value(Usage) band.

When I select a step of 250 the x-axis shows values as 0,250,500,750, etc.

Now, When I have a value(amount or Cost) at 65 usage where does the data value will be shown, at a lower band value or upper band value? Is it at 0 or 250?

Regards,

Shyam.