Bar and Line Graph

#1

Hi Team

I am try to create a combination of bar and line graph which has 2 measures and one hierarchy which has drill up / drill down functionality.

  1. number of partners- (need to get distinct count. note - it is a dimension in DB need to convert to measure.)
  2. Geography hierarchy which has 3 levels (e.g. Country , State , Region)
  3. Revenue for each Country/state/Region

Is it possible ? I am attaching the prototype here.

Image
Image.JPG948×771 42.3 KB

#2

Hi @adityadave,

Absolutely possible. I did a video a few weeks ago that does not aim to specifically cover building this chart but it basically does create something very similar.

https://www.dundas.com/resources/off-the-charts-tips-from-an-expert/you-cant-flatten-the-curve-without-log-scales

The only main difference would be to change one of the chart types to bar (click the chart -> choose the series -> look for the chart type option)

Create a hierarchy and use it as the rows dimension instead of date like i do in the video. Covered here:
https://www.dundas.com/support/learning/documentation/analyze-data/how-to/how-to-create-a-custom-user-hierarchy

Hope this helps.

#3

Just to clarify: you don’t need multiple metric sets to display a second Y axis on the right, so if you can add both of your measures to one metric set this is best. In the properties for a series, just set Vertical Axis to “New Right Axis” or an existing right axis. This is just below the Chart Type property that can be set differently for each series: to Bar, Line, Point, etc. (https://www.dundas.com/support/learning/documentation/data-visualizations/using-chart-properties)

#4

Thanks Jamie and Jeff for your prompt response.
I will try out the approach suggested and let you guys know in case of any issues.
Thanks a Lot again !!!