Daily Sales Forcast

[rahulsingh12]

Hi I want to create a line chart based on the below data:

I get daily sales data and Budget Data for a SKU

I will have days on x axis

For Days lesser than current day value 0, else for day= Current Date value is  of the sale of the day and for days greater than current day it is Budget for the day for all sku *((sum(Actual sales MTD)/sum(Budget MTD for all sku )) {Till the day actual sales data is available for the month}))

how do i code it

[dplr-rn]

Why dont you use set analysis and 2 measures?

some thing like below

Sales - Sum({<MasterDate={"<$(=vMaxDate)"}>}Sales)

Budget - Sum({<MasterDate={">=$(=vMaxDate)"}>}Sales)

vMaxDate is the date where you want to switch over to  Budget data