Forum Discussion

oliviar's avatar
oliviar
Data Storage
07-05-2022
Solved

Overlapping Column Chart

I am looking at a Goal vs. Actual column chart. I have two context cases for this framework: units goal and units sold, and revenue goal and revenue collected.

I have my bar chart working correctly, but I want to change the design of it a bit to be more visually appealing.

I am not satisfied with the Classic design view. It looks like this:

 

I have tried the Stacked and Stacked 100 views but they aren't doing what I need them to do.


I want the column charts to overlap.

If I have a product with a goal of 100 units, and we've sold 20 of them so far, the Stacked design view makes my entire bar equal 120 (combining the goal and the actual). 

I don't want that. And I don't want a static goal or budget line across my graph.

I want the bar to stay at the goal of 100 and to see the 20 units sold in front of the 100 unit goal bar.

Kind of like this, visually:

 

Does anyone know how to do this? I think it should be a default design view option.

 

Thanks for the help!

 

dashboards & reporting
Finance Analytics

5 Replies

Replies have been turned off for this discussion
    • oliviar's avatar
      oliviar
      Data Storage
      07-06-2022

      Thank you! I like the top one. I think this is what we are looking for. The only thing that's kind of bugging me now is when I hover over the product in the bar graph, the numbers associated with the goal and actual are not formatted the same way as they were before--they don't look as clean.

       

      I have tried to change the format in the dashboard design and it won't change. Do you have any pointers here?

      Ideally I would be able to see the comma separators, dollar signs, and reduce the decimal places so it is a rounded figure.

      Thanks!

       

      • harikm007's avatar
        harikm007
        Data Warehouse
        07-07-2022

        One option is to remove below lines of code from the script, so that it will display default Sisense tooltip with formatted numbers.

        widget.on("beforedatapointtooltip", function (se, args){
	args.cancel=true;
});
        ev.result.tooltip.shared = true
ev.result.tooltip.enabled = true

        -Hari

         

  • Angelina_QBeeQ's avatar
    Angelina_QBeeQ
    ETL
    07-06-2022

    Hi oliviar ,

    You can play with formulas and Stacked type.
    In your case, instead of Goal value use the difference between Goal and Actual. As a result, you will get the correct sum. But be careful with cases where Actual > Plan, because the difference will be negative. But you can do whatever you want with the conditions and colors. For example: