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
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?
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
ok, then
total (
[throughput]
for [time]
)
will then give you the total sum for each time interval, thus
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.
Hi hespora,
Great !! it worked !!
Thanks a lot !!
Miko
wonderful; glad I could help!