topic set analysis: how to ignore date filter on chart label in App Development

set analysis: how to ignore date filter on chart label

christiancut — Tue, 19 Mar 2019 16:04:58 GMT

Hi,

I have a problem with x axes label in chart.

I have a chart with month in x axes and value in y axes.

I have used following expression to exclude data filters

Avg({1<[MarketName]={'MGP'},[ZoneCode]={'PUN'}, [Date]=>}Val_18)

The expression work correctly but, in the chart label, I have the correct name only for month filtered

There's a solution for my problem?

Thanks

Re: set analysis: how to ignore date filter on chart label

vikasmahajan — Wed, 20 Mar 2019 08:40:47 GMT

Avg({$< DateField= , [MarketName]={'MGP'},[ZoneCode]={'PUN'}, [Date]=>}Val_18)

This will ignore date field in set analysis

HTH

Vikas

Re: set analysis: how to ignore date filter on chart label

christiancut — Wed, 20 Mar 2019 08:53:08 GMT

Hi Vikas,

I have no problem with calculation.

The value shown in chart is correct. The problem is only the laber of x-axes where I see the month's name only for the months filtered and not for all.

Re: set analysis: how to ignore date filter on chart label

vikasmahajan — Wed, 20 Mar 2019 09:39:08 GMT

Can you attach sample demo

Vikas