Can you attach .twbx dummy file so that our community members can look into the issue......
In case when I am using the parameter 'Numbers' I am getting the result whereas in case of 'Growth' how can i go about? Can you Elaborate more i personally didn't understand...
I had mentioned that i am able to get the numbers using the parameter.Whereas i am facing challenges if i want the same line chart to show me the growth numbers.
Hope it is clear now!
I dont know whether i have understood ur requirement correctly or not...
PFA see Sheet 20 and Sheet 22(In Tooltip)
Dis is what ur expecting if not please post a .twbx(dummy) with ur requirement correctly, Hope I or our Community members may solve ur issue...
book 1.twbx 422.8 KB
Thanks Sravan for your quick help!
My requirement is if we can have a parameter as growth or Sales in sheet-22.
In other way round we can display Metrics cal or Growth Metrics in the Sheet-20.
My working issue are below:
- When I am trying to include the growth to my Display_Metric Data it is showing some errors as shown in below picture.
- The growth Calculated filed used by me is WINDOW_SUM(SUM([Data(Abs)]),0,0)/ WINDOW_SUM(SUM([Data(Abs)]),-12,-12) -1
Hi any solution.
Growth vs PY is already aggregated - remove the AVG and if you need it add it in the logic of the formula.
Also both need to be either aggregated or non-aggregate . So do a e.g. SUM(Data Abs) ...
Done still error
What error? Can you show your calculated field? Can you share your workbook? We need some details if you want us to help