How could create a Group Median line in the Chart

[Anonymous]

Hi,

I have a group have 4 subgroup.

I create line chart to have individual group line (sum(Sales) per day)draw out

but I want to have a Group reference Line (Median(all 4 subgroup sale)per day) in the Same graph.

Any suggestion how could I achieve that?

Here is the qvf file in the attachment. Thank you so much!

Regards,

Celine !

[sunny_talwar]

Is this line going to be a static line? or is that going to change each day?

[Anonymous]

Now it is static.

But if possible, this will be refresh weekly

Could I have both solutions?

Thank you!

[sunny_talwar]

What I meant to ask is that you need Median for each day or Median across all dates and subcategories?

[Anonymous]

Sorry. did not understand correctly

I want a line (not the straight reference line) have 7 points.  and each point represents 1 day for 4 subcategoris' Median

[sunny_talwar]

May be create multiple expressions with single dimension?

[Anonymous]

Sure. this is what i want. How did you do that?

could i have the qvf with function ?

and any chance we can make the Media line --Boarder? or Darker? or change the line shape?. to distinguish from the individual one? (any One methord would be nice)

[sunny_talwar]

How about this?

The QVF is attached with this post again (did attach it with my previous response also)

[sunny_talwar]

Have used line for marker, but you can chose any other symbol also

[Anonymous]

Cool. But how did you do that?

what things i need to do? could you attach the qvf please? or teach me how to do that?

Thank you!