Chart properties

[KumaRan]

Hi

In  the above chart there is no sales on July month. So Target also not coming.

Even if there is no sales also i have to display Target.

Is this data model issue or chart issue. Black Colour bar is Target.

Transaction Started on June month .So there should not be a target before to June month

[Anonymous]

Can you share whit us your data model ?

[sunny_talwar]

What is your expression you are using for Target? If you have an if statement (or set analysis on sales field) restricting the Target expression to only show when there is sales, then I guess remove the if statement (or the set analysis). If there is no if statement, then this must be because of data issue

[#4]

Hi Kumaran

It is definitely a data issue.

If you dont have data captured for the month of July, nothing will reflect on the chart

You can create a constant value for Target when you load the data

MyTable:

Load

          *,

          20 as Target

From

          SourceTable

Target will then be created with the value 20 for all rows, even for July