How no reflect the filters in a particular graph?

[#1]

Hi all,

I have a cumulatives summaries for weekly,  monthly and annual values.   In the summaries I can filter by week,  month and year.

Under the summaries I would like to show a line graph with the weekly trend, however, when filtered a week the graph only shows me a point... How can I make the week filter doesn't affect the line graph?

Thanks in advance...

[sunny_talwar]

Within your expression add this as your set analysis:

{<week =>}

[#3]

I tried to do this:

=SUM({<SEMANA =>}{<ALMACEN2 = {'TOMÉ'}>}VENTA)/COUNT(DISTINCT [FECHA FACTURA])/1000

But it doesn't work... (SEMANA = week)...

[sunny_talwar]

You don't need 2 set analysis, try this:

=Sum({<ALMACEN2 = {'TOMÉ'}, SEMANA =>}VENTA)/Count(DISTINCT {<SEMANA = >} [FECHA FACTURA])/1000

[#5]

Great!... It worked but also I need that the monthly filter doesn't affect the graph... How do I do this?

[sunny_talwar · Accepted solution]

Add all the fields you don't want to impact the chart on selection like this:

{<Field1 = , Field2 = , Field3 = >}

or this will also work:

{<Field1, Field2, Field3>}

=Sum({<ALMACEN2 = {'TOMÉ'}, SEMANA =, MONTH = >}VENTA)/Count(DISTINCT {<SEMANA = , MONTH = >} [FECHA FACTURA])/1000

[#7]

Thank you very much Sunny!

[sunny_talwar]

No problem