Show full date range in chart

[GrantBooth]

I'm trying to create a chart that shows the full date range rather than a selected month.

In my chart I have the field Month, which are values from 01 to 12. When an individual month is selected, it shows the value just for that month, which is expected. What I am trying to do is have the full date range 01 to 12 appear.

The dimension  is =Month, and the value in the chart is sum(Amount)

I've tried using =Month={">=$(01)<=$(12)"} in the dimension and it's telling me it is an invalid dimension, any ideas?

[AshutoshBhumkar · Accepted solution]

Hello,

You can ignore selection of Month on that chart if you dont want Month selection to affect your sales values.

E.g

Sum({<Month =, Year = {CurrentYear}>}Sales)

Thanks,

Ashutosh

[GrantBooth]

Thanks for the response, I feel I may not have explained myself well enough. I am trying to display all of the 12 months regardless of the month that has currently been selected. 

[AshutoshBhumkar · Accepted solution]

Hi @GrantBooth ,

If I understood correctly, please check below example and correct me if I am wrong.

As expected, I am displaying all of the 12 months regardless of the months selected.

[GrantBooth]

I stand corrected, that's exactly right, thanks heaps

[AshutoshBhumkar]

🙂

Hope that solves your query.

Thanks,
Ashutosh

[AshutoshBhumkar · Accepted solution]

Hello @GrantBooth ,

Please mark the answer as correct if that solves your problem. 🙂

Thanks,

Ashutosh