Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
Here i have few scenarios, can you please help me on this?
Ex: I have a bar chart for 10 years, if i select 2005, then data should be filter from 2005 to 2009.
2. I have two tables with below fields.
Table1 (Emp table) Table2(Emp address table)
EMPID EMPID
EMPNAME EMPADD1
DEPTCODE EMPADD2
EMPADD3
Each employee has multiple addresses (Many to Many relationship) and same address is available for different employees.
I want to get join these tables, how can we do it and how can i remove the redundancy.
3. What are the parametric variables and where do we use them?
4. I have use data in my Application with several charts, for last chart it is taking much time. How can i optimize it?
Can you please tell me the ways to do it?
Thanks for spending your valuable time on this.
Thanks alot.
Sridhar.
For #1 you can use a trigger that triggers a 'select in field action' to select the next 4 years as well.
Take a look below and test the attached if you need
Thanks Jonathan.
Friends, can anyone help on remaining questions?
Thanks a lot.
Sridhar.
1) use set analysis u can achieve this scenario
create a variable v1=max(year)
sum({<year={'=>(v1) <=(v1+4)'} Sales)
2) if Empadd1,empadd2,empadd3 all are same for each EmpId
then join two tables with EmpId and Remove other Add2 nd Add3
Table1 (Emp table) Table2(Emp address table)
EMPID EMPID
EMPNAME EMPADD1
DEPTCODE
4) if you have any heavy calculation in chart better to do it in script like string functions
Thanks for your reply Rakesh.
Hear each emp has multiple different addresses Rakesh. And also duplicate addresses are available for different emp.