0 votes
1 view
in BI by (41.2k points)

I'm looking to compare a single Fortune 500 company's revenues (selected by the end user from a list of all Fortune 500 companies) to an average revenue for all Fortune 500 companies over time. I would like the averages to show up as bars and the single company revenues to show as a line graph (both on the same chart).

I understand how to set two different chart types on the same view. What I don't understand is how to write the calculations and parameters to give the end-user the functionality of choosing a single company and comparing it against all others.

Any suggestions on how to do this? Happy to clarify further if needed.

Thank you in advance!

1 Answer

0 votes
by (15.1k points)
  • That kind of chart can be achieved using 2 measures.

  • You need to create the measures then. The average of all is pretty straight forward, it's AVG(Revenue).

  • Using parameters, single company revenue can be retrieved. Create a parameter like [Company chosen], and put the list of all Fortune 500 (you can load from field, which helps a lot).

  • Then create a calculated field [Company revenue]:

IF [Company] = [Company chosen]

THEN [Revenue]

END

And just use the sum or avg of this measure.

  • Now, put both the measures on the worksheet and set the right chart

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...