Show all Dates on Chart

[ivandrago]

Hi,

I have the attached Bar chart on the Analysis sheet, I want this chart to show all the DateMonth's that are available, the issue I am having is that there is a Trigger on the Analysis Sheet that will pick the latest DateMonth so the chart changes because of this selection.

How do ignore this selection for this chart?

Thanks

[sunny_talwar]

Try this:

Sum({<DateMonth = >}Amount)

[srchilukoori]

Hi,

Use the following expression in the chart.

sum({1}Amount)

[ivandrago]

Hi, I've applied a few more filters but chart 1 is not showing all the months? Any ideas as to why?

[sunny_talwar · Accepted solution]

Try this expression may be:

=If(Only({<DateMonth = >} Pick='JS'), Sum({<Type={'OFF'}, DateMonth = >} Amount),

If(Only({<DateMonth = >} Pick='JT'), Sum({<Type={'ON'}, DateMonth = >} Amount)))

[ivandrago]

Hi, So what does this actually do? As if I make other selections will it affect the chart?

[sunny_talwar]

The chart won't be impacted by any selection you make in DateMonth field. For all other selections, the chart will drill down. Are there other fields on which you don't want this chart to change? If you do then just add them next to DateMonth like this:

{<DateMonth = , Field2 = , Field3 =, Field4 =>}

[ivandrago]

‌thanks!