Hello,
In Qlikview we have an option to show average trendline in bar chart for an expression without writing any separate expression for trendline, but in qliksense same option is not available to show trendline. and also in qlikview the average is calculating based on the values shown on X.
Qlikview:
Dim: Month Expr: Count (distinct User)
QlikSense: used same dim and expression, user below expression in reference line.
avg(aggr(Count(distinct User),Month))
Unable to get any line in chart.
Please help me with the expression to show the average value in bar chart. attached screenshot for reference.
