Is this chart possible in Dundas

#1

Hi Team
I have a requirement as below to show 3 things in Bar Graph :

  1. Siesmic Indicator column (Dimension column with Y and N values): to be shown in X axis
  2. Customer ID column (alpha numeric) : want to show the distinct count in Y axis (right side)
  3. Revenue : Measure column to be shown in Y axis (Left side).

Is it possible in Dundas without downgrading the performance ? I have observed in the past that when we convert Dimension to measure in this count distinct of customer id the performance drops significantly.
Please see the attached mock up.

Regards
Aditya Dave
image

#2

Hello @adityadave,

I was able to create something similar on my end based on your requirements. Please see the screen-shot attached.
Remark: I do not have “the best” DataMart(quality of the data perspective) for this scenario.
Regarding the performance this is totally dependent by your cases and scenarios. There are a lot of elements involved here: performance of the server, network quality, type of usage of the dashboards, how the ETL is build etc.

123
123.PNG1345×881 6.94 KB

#3

Thanks a lot Costin. I was able to create it as well. I am working on performance part now.

#4

Hi Aditya,

This functionality shouldn’t be causing performance problems. Have you talked to support about it? Cheers.