Designing Challenges

[#1]

Hi All,

Q1-

I am looking to display a text when cursor point to a value. I have created a Cyclic Group which consist of 4 fields Country-->State--> City-->Area

So when my Cyclic group is displaying Cities and when my mouse cursor points to a particular city like Richmond then It should display text message like Australia-->Vic-->Melbourne-->Richmond

OR

Q2-

When my Cyclic group is displaying areas and when Select a particular area like Richmond then Field Selection boxes should highlight the values  Australia, Vic, Melbourne in Green Color.

So basically I have 4 List boxes for County, State, City, Area so that I can select values from these to filter out data.

I have a graph which displays no employees working under these areas. I found that Richmond is a area where max no employees are working so when I click on Area Richmond then value Australia in List box Country, value Vic in List box State,  value Melbourne in List box City should be highlighted in any color like green.

How to achieve either of these or both of these?

[jagan]

Hi,

Attach some sample file and you will get the response quickly. 

Regards,

jagan.

[danieloberbilli]

Please find attached.

Q1: if you use a bar chart you could add an expression as text pop-up (and no bars) and insert something like

              only(Country) &' -->'& Only(City)  &' -->'&  Only(Region)

or you script a new field with additional/detailed info and just write      only(DetailText)

Q2: Green color in Listboxes indicates an explicit user selection. White color shows the possible values due to a selection status. I would not recommend to change this as this will rather confuse the user (at a later stage) when its not obvious for him/her what is selected and how the data interacts due to the model.

Instead of forcing green color in listboxes I woul rather show an additional textbox with the current possible values (in green)...see example in app

[danieloberbilli]

my example of Q1 would need some finetuning when using in a cyclic group to avoid empty strings

[#5]

Hi Daniel,

Thanks for your solution. It is working for 1-1 mapping between fields.

I used below expression and even this is giving same result.

=IF(GetCurrentField([Region Groups])='State',([Country]&'->'&[State]),

    IF(GetCurrentField([Region Groups])='City',([Country]&'->'&[State]&'->'&[City]),

       IF(GetCurrentField([Region Groups])='Region',([Country]&'->'&[State]&'->'&[City]&'->'&[Region]),

    '')))

But I add another column (Employee Name) to this group and add condition in expression then I am net getting desired result. For Example: One employee (Shivendoo) is working in 2 regions Richmond and Flinders.

When I point my cursor to employee Shivendoo, it should display Australia-->Vic-->Melbourne-->Richmond, Flinders-->Shivendoo

=IF(GetCurrentField([Region Groups])='State',([Country]&'->'&[State]),

    IF(GetCurrentField([Region Groups])='City',([Country]&'->'&[State]&'->'&[City]),

       IF(GetCurrentField([Region Groups])='Region',([Country]&'->'&[State]&'->'&[City]&'->'&[Region]),

          IF(GetCurrentField([Region Groups])='Employee Name',([Country]&'->'&[State]&'->'&[City]&'->'&[Region]&'->'&[Employee Name]),

    '')))

Need your suggestion on above expression to display value like Australia-->Vic-->Melbourne-->Richmond, Flinders-->Shivendoo

[danieloberbilli]

This should work with the 'concat' expression (lists all the possible values with a user defined seperator:

...IF(GetCurrentField([Region Groups])='Employee Name',([Country]&'->'&[State]&'->'&[City]&'->'& concat([Region],', ')&'->'&[Employee Name]) ...

[jagan]

Hi,

If you have duplicate values then you can use Concat() function

Concat(DISTINCT Region, ',')

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

If you have duplicate values then you can use Concat function

Concat(DISTINCT Region, ',')

Hope this helps you.

Regards,

Jagan.