Forum Discussion

cw900's avatar
cw900
Icon for Helper I rankHelper I
2 years ago
Solved

Line and Stacked Colum - How to Show Average on Line?

I want to show a student's login activity per day (Event_Type = "Login") as columns and I want to show the course average for the course that the student is on as the line on the same graph.   Here...
Need Help
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    In the Allexcepted put the column date that your are using in the charte.

    Allexcepted will remove all filter on that table except on the column you mention, so I think it Could solve your problem.

    Try...

Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
2 years ago

Hi cw900 

A simple avg formula is total sum / no of count.
Create same formula through measure.

Add your formula here in this property of bar chart

 

 

I hope I answered your question!

 

cw900's avatar
cw900
Icon for Helper I rankHelper I
2 years ago

How do I identify the course that the student is on? And how to I tell my measure for the average to ignore the student that I've selected and get me the average for the course they are on?