Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you share whit us your data model ?
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
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