How to hide negative value in linear trend line

[ashis]

Hi,

I have a line chart and also I am using linear trend in the expression tab to showcase our trend over the selected period of time.

My question is there any mechanism or way to hide the negative value in the line chart for trend line, we want to stop it once it touches 0 value.

Please give me your thoughts.

Thank you,

[PrashantSangle]

You can use if()

like if(sum(sales)>0,sum(Sales))

Regards,

[ashis]

HI Prashant,

Thank you for your reply. It does not work for trend line.

Regards,

[sumanta12]

First make a calculated dimension like below:

=IF(sum(Sales)>0,'Your Dimension field')

check suppress value is null.

Then put your expression in the expression section.

[ashis]

Hi,

I am using Date as dimension, and if I put

=if(sum(sales)>0,'Date') , and suppress null value , my chart is not able to get data. and I am getting error in calculating dimension.

Regards,

Ashis

[sumanta12]

Please Share Sample Data.

[sumanta12]

Put this in calculated dimension

=IF(AGGR(SUM(Sales),Date)>0,Date)

[ashis]

Hi Sumanta,

As proposed , I have created calculated dimension as date, then check on the suppress when value is null option.

However I am still getting trend line value in negative .

Due to security purpose I am unable to share sample data.

I want trend line to stop when it touches zero.

I appreciate your response.

[jyothish8807]

Hi Ashish,

You cannot put conditions for a trend line. What you can do is create a expression instead of using the trend line option and  you can set the style in line format. '<S1>' to '<S4>'.

Hope this helps.

Br,

KC