Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
is it possible to add a total average bar on a bar chart?
please see an image example below,
this is the expression:
Count(distinct {$<[Date Diff]={"$(=$(vMaxDateDiff))"},[Year Diff]={'$(vMaxYearDiff)'}>}UserID)
/
Count(distinct {$<[Date Diff]={"$(=$(vMaxDateDiff))"},[Year Diff]={'$(vMaxYearDiff)'},[Job Family]=>}UserID)
the user selects one job family and the bars show the ratio of the job family for every country.
thanks,
Ido.
@idogridish2 try below
Create one inline table
load * inline [
Dim
1
2 ];
In your bar chart use below dimension
=Pick(Dim,Country,'Overall Average')
Use your original expression as it is
Hi,
that is what i did, and i colored the bars with red and green for values above and below that number,
the client is insisting for this presentation.
If you have access to the data table; you need to add 'Overall Average' as a Country
Concatenate (YourDataTable)
LOAD * INLINE [
Country,
Overall Average
];
and then in your Bar Chart, I think you can use the below as your measure.
if(Country='Overall Average',
(Count(TOTAL distinct {$<[Date Diff]={"$(=$(vMaxDateDiff))"},[Year Diff]={'$(vMaxYearDiff)'}>}UserID)
/
Count(TOTAL distinct {$<[Date Diff]={"$(=$(vMaxDateDiff))"},[Year Diff]={'$(vMaxYearDiff)'},[Job Family]=>}UserID)),
(Count(distinct {$<[Date Diff]={"$(=$(vMaxDateDiff))"},[Year Diff]={'$(vMaxYearDiff)'}>}UserID)
/
Count(distinct {$<[Date Diff]={"$(=$(vMaxDateDiff))"},[Year Diff]={'$(vMaxYearDiff)'},[Job Family]=>}UserID))
)
@idogridish2 try below
Create one inline table
load * inline [
Dim
1
2 ];
In your bar chart use below dimension
=Pick(Dim,Country,'Overall Average')
Use your original expression as it is
Thank you, great solution.