Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Percentage Stacked Bar Chart & Line Chart

Hi I am trying to build a combination of percentaged stacked bar chart and line chart. 

 

Is there any reference I can refer to? The curent formula I am using return results that are slighly inaccurate. E.g. Class 1 should be 39.52% but it returned 39.42%. There are some filters on is this the reason why the inaccuracy? The total also doesnt add up to 100% unless I remove all filters. 

Also how do I show the total figures in absolute value instead of % value? Thank you!

2 Replies

  • Thennarasu_R's avatar
    Thennarasu_R
    Icon for Responsive Resident rankResponsive Resident

    Check This One
      Var a= Calcualte(Measure)
      var B=Calculate(measure),All(Table name Or Column Column)
    return
     Divide(A,B)

  • Anonymous's avatar
    Anonymous
    Not applicable

    Are the "Measure" in VAR A & B the same?

    The formula doesnt work as it divide each by the grand total. I would like to compute for the specific period