Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I don't know if it is possible but I need to display an extra Bar Column or Dimension in Bar Graph with an Average over all Sales
I have tried many different approaches with no luck!
I have attached an example with more detail
appreciate help on this
regards Peter
May be further fine tuned, but look at the attached
May be further fine tuned, but look at the attached
Hi Sunny,
First thank you for this impressive work, I have applied this to my "Main Structure" with many Records and other graphs and it is running very slow to update. Can you please explain in brief how the
1) Dimensions and Expressions work together e.g: the Pick and Dim?
2) If(GetSelectedCount(Rep) = 0, Sum(Sales)/Sum(TOTAL <Rep> Sales)/2, : your /2 at the end of this line in expression is this to get average of Rep count?
I might see if I can speed the query up on my Main , I may have missed something. maybe I need to group data in aggregated table just for this chart to be displayed?
regards Peter
Hi Again Sunny ,
I have marked your answer correct, after doing a search I found another Discussion of yours ... link for an Explanation on your Pick, Dim structure here
and after looking at my Data Model again and a restructure it runs as expected exactly what I wanted great work Sunny
and Thanks
regards Peter