cancel
Showing results for 
Search instead for 
Did you mean: 

I want to do the attached chart like the same in SAC Dashboard dashboard.png Appreciate your help

vku
Explorer
0 Kudos

Hi

I want to do the attached chart like the same in SAC Dashboard

dashboard.png

Appreciate your help

Accepted Solutions (0)

Answers (1)

Answers (1)

VijayetaSharma
Active Contributor

Hello Vinod,

You may not be able to get exact setup of chart in SAC. At least that is offered out of the box (analytics app would be an option though). What you can do is setup bar chart with cross calculations to calculated the deviation between actual, forecast, budget
or
Use standard variance/ compare to functionality in charts to show variance on top of each bar chart. you can pick and choose what you want to compare Actual Q1 to Forecast Q1 or Actual Q1 to Budget Q1

You charts would look somewhat like below:

You can play around with the options under Variance on the right side to get what you are looking for.

or

Now if you add "Selection" widget in your canvas you can reuse the same chart for multiple quarters. End users will get a arrow to switch between different quarters (provided you add time period as filter in Selection) . This way you do not have to build separate charts for different quarter comparison. Here is an example

Don't forget to up-vote and accept, if it helped. 🙂

Vijayeta