Max value for a stacked chart

[MikoMan]

Hi,

I have a stacked chart and i need to show the max value for this chart for the time period it runs.
you can see the example of my chart in the attachment.
This is a 24 hours data graph.

Thanks,

Miko

[hespora]

Seeing as you didn't post a specific question, it's kind of hard to help you here.

- looking at the graph, I cannot determine whether this is a stack of one measure over time with a dimension being the series, or whether this is some 20 measures in the series. Both could be possible (and would change the way on how to achieve what you want), but which is it?
- are you on a relational or dimensional model?

[MikoMan]

Hi hespora,

Thanks for your replay.

The main question is , how do i get the max value of this chart for this period of time ?

This stuck is a group of network interfaces and their throughput out data over a day.
Each line is a different network interface.
You right, this is a 24 hours graph.

Thanks,

Miko

[hespora]

ok, then

Code Select Expand


total (
  [throughput]
  for [time]
)


will then give you the total sum for each time interval, thus

Code Select Expand


maximum (
  total (
    [throughput]
    for [time]
  )
  for report
)


will give you the highest total value for the entire report.

/edit: ...obviously assuming you are on relational.

[MikoMan]

Hi hespora,

Great !! it worked !!

Thanks a lot !!

Miko

[hespora]

wonderful; glad I could help!