Calculating Percentages in Lumira
I am trying to add percentage calculations to my visualisations in Lumira without having to manipulate data in excel before hand.
One example of what i am trying to achieve is a leaver analysis with number of leavers by month and this represented as a percentage of total headcount through using a combined column line chart with 2 Y-axis.
Therefore I need to be able to calculate the percentage of leavers on a seperate value. Is this possible? i.e. to create a measure which would be leavers/headcount which would then be attributed across each month.
Any help would be greatly appreciated!