How to create top quartile as a line in bar chart for existing timeseries data in DBI?

#1

How to create top quartile as a line in bar chart for existing time series data in DBI?
I have dynamic set of data depending on duration filler, hence I wanted to calculate Top quartile for that selected duration data. Is it possible to show top quartile line in Bar graph where bars are representing daily values and quartile line should show top quartile value for selected duration data.
Appreciate your help.
Regards,
Prashant

#2

Hi Prashant,

Yes it’s possible to display lines inside a bar chart. For example, if the chart will use two measures, measure1 for the daily values is displayed as bars, measure2 for the quartile values is displayed as a line. Go to the chart’s properties:
image

Click on the first measure,set the chart type as bar.
image

Click on the second measure for the top quartile values, set the chart type as line:
image

#3

Hello Jay, I know that multiple measures can be shown in any chart in dundas.
My original question is , can we do quartile calculation dynamically inside dundas as per duration filer selection and show in chart?

#4

Hi Prashant,

Have you tried to use the percentile formula?
https://www.dundas.com/support/learning/documentation/analyze-data/formulas/statistical/percentile