My dashboard shows below 3 fields Department_name, Permanent_Count, Temp_Count computers, 10,5 electricals, 20,7 mechanical, 15, 10 Now permanent_count and Temp_count are calculated fields which is sum of a field from my input lookup file depending on many criteria like region, band etc. So if i do a condition match with click.value2 and search for that value say 10 that wont exist in my look up file, since thats a calculated field not a direct one. Now my requirement is if i click on number 10 in the row computers i should see all the name of employees under computers department . ... View more

Hi, I have 3 options to choose from and 3 panels to show/hide depending on the option chosen. I should be able to choose 1 panel at a time or 2 panels or all the 3 panels If i use three dropdowns i am able to show or hide as per the above requirement since i have unique token names there its easy to reference in table depends = token. But how do i achieve this with single checkbox where i get all the 3 options to choose from or radio button or multiselect. As in these cases i have a single token name is there any option i can refer the value of the token something like table depends=token name=A Thanks ... View more

i have 11 rows as output of my search query.Which looks like below Example field1 field2 co 10 im 10 ae 10 be 10 iapp 10 idec 10 ienp 20 imain 30 inet 40 How can i alphabetically sort first 5 rows then get the total in lext row and then next 6 lines sort alphabetically and get sum in the last row . I want the output like below Example output field1 field2 iapp 10 idec 10 ienp 20 imain 30 inet 40 Total 110 co 10 im 10 ae 10 be 10 Total 150 ... View more

I have a requirement like this from file1.csv lookup file i am getting 2 fields field1 field2 "application support" 1 "technology maintenance" 3 "enterprise platform" 4 file2.csv file has many fields out of which one of the field name field3 has data like this filed3 "application file" "cto maintenance" "application file" "application file" "application file" "enterprise security" "enterprise security" Now if field1="application support" search for word "application" in file2.csv in field3 And since we got a pattern match for word application now i need the count saying how many "application file" values are there in field3 of file2.csv and get the resulting table as below. field1 field2 field3 "application support" 1 4 "technology maintenance" 3 1 "enterprise platform" 4 2 ... View more

I have two lookup csv files. file1.csv and file2.csv 1st query results me with field1 which has a pattern match in field2 of file2.csv not the exact match. how can i achieve this in query . Thanks ... View more

Hi, I have few fields in my csv file like below. Name of csv file example.csv A B C D 1 Harry 100 Tel Tom Harry 200 Ban 1 Harry 300 Oper Requirement : I want to search in inputlookup example.csv to get If column A=1 and Column B=Harry then give me sum(Column C) i.e. 400 and give it name as "Perm" also to the same query add one more criteria like If Column A=Tom and Column B=Harry then sum(Column C) shold be the output and named as "Cont" and group them by Column D at the end. ... View more

Hi, I want to create a dashboard where i can show like below : Logic is if 1 employee is there in bangalore it should show 1 if 2 employes are there in each Delhi, Mmbai and Bihar it should show 2 against each of the places and should be placed in 2nd row and so on. Bangalore (1) Delhi (2) Mumbai (2) Bihar(2) Jaipur(3) Gurgaon(3) Additionally i want to color code the cells/boxes as well . Thanks ... View more