In Progress

Forecasting in Tableau where data is on MAS server (cubes)

I have a tableau question (about modeling).

I have built a workbook that shows Daily Sales for the current month (two columns – current year and last year’s daily sales). I have added three lines – current and last year’s daily sales budget, and last year’s daily sales average.

I would like to add a fourth line that shows the budget realization forecast for the remaining days in the month. This line would show the sales number for each of the next x-amount of days to achieve the monthly sales budget. Is it possible to create this type of line? Maybe through a custom reference line?

Data connection is through MAS server, I am new to this and data server connection. I have attached an example titled Realization Forecast Example (someone explained this to me via simple excel concept).

I am attaching the screenshots (with the titles: Real workbook snapshot) from the original Tableau workbook I am working on, as I can' share it due to privacy reasons. Let me know if any additional info needed.

Skills: Tableau

See more: custom data entry sql server, create pdf mysql data, create real time data adapter wealth lab, visual studio adding custom data types, data access layer business object code example net, create script harvest data, code create property custom server control, quickbooks pro custom data entry, create complex custom server control aspnet, aspnet create form post data, create hyperlink mysql data, custom data entry form excel, create graphs mysql data, create database normalize data, php create table csv data

About the Employer:
( 0 reviews ) United States

Project ID: #14697648

4 freelancers are bidding on average $24 for this job

$25 USD in 1 day
(1 Review)

Hi, I'm Saravana from India and have several years of experience in Business Intelligence and Data science. Current Clients Location: India , USA(Ohio,Philadelphia) , Panama, Canada, Kenya, Australia, France. Indu More

$19 USD in 1 day
(2 Reviews)

4+ years of relevant industry experience.

$25 USD in 1 day
(1 Review)
$25 USD in 1 day
(0 Reviews)