on 06-16-2022 7:07 PM
Hi
I want to do the attached chart like the same in SAC Dashboard
Appreciate your help
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.