Bar Chart for Daily Budget

[#1]

Hi All

I have a FACT or TRANSACTION table in which my Dailys Sales and Monthly Budget is stored.

I would like two bar charts (Sales vs Budget) but where the x-Axis dimension is daily. 

Problem is my budget date is only 1st of each month as we set it monthly not daily hence I can Full Accumulate Sales but the budget only appears once.

I would like to calc an ave daily budget, i.e.: BudgetValue/WorkDays and then Full Accumulate this?  Any ideas please? See attached current Chart.

[er_mohit]

I think in expression tab for that expression tick on relative and full accumulation with your simple expression

[#3]

Hi

Tried but it does not accumulate.

Here is the expression now:

Sum({<Type={'BR'},Date={'>=$(vFYPeriod)<$(vToday)'}>} Value)/30

//the result is $2,3mil but when relative and full accumulate the expression it looks like this (attached)

[kaushiknsolanki]

Hi,

     Why dont you divide your budget by no of days in month to get daily budget, then you can use the accumulation to get the values.

Regards,

Kaushik Solanki