Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have requirement to show Monthly salary and Yearly bonus in same chart.
In Y-axis expression is like sum({<AccountDescription={salaries}>}Amount) as Monthly salary,
and sum({<AccountDescription={'Salary & Other Comp'}>}Amount) as Yearly Bonus.
For better understanding Plz see below image .
I should get Blue dot for all month year but red colour dot(Bonus ) only at the end of each year.
Your data says otherwise. If the bonus amount were only available in the last month of the year you would see that reflected in the chart.
Combine the Year and Month dimensions into one dimension. The best option is to create this field in the script. If that's not an option you can use a calculated dimension: =MyYearField & '/' & MyMonthField
Thank you ,
Issue is ,Salary is month wise but Bonus is once in a year.
I should get Blue dot for all month year but red colour dot(Bonus ) only at the end of each year.
I should get Blue dot for all month year but red colour dot(Bonus ) only at the end of each year.
Your data says otherwise. If the bonus amount were only available in the last month of the year you would see that reflected in the chart.
Hi
May be try like this
You can create a flag for Last Month of every year and use in the "Yearly Bonus" expression.
Ex: = if(Month = 'Dec', 1, 0) as Flag
sum({<AccountDescription={'Salary & Other Comp'}, Flag = {1}>}Amount)
Thank you ,
You valuable answer made me think more about data, let me check once again.
Hi Mahantesh,
PFA.
Hope it works.
Regards
KC