cancel
Showing results for 
Search instead for 
Did you mean: 

Relative Position,Width&height options for Xcelsius Components(Like WebIn)?

Former Member
0 Kudos

Hi,

I created a dashboard using Tabset Component. There are 5 tabs. Each Tab contain a column Chart and Pie chart in the top row and two guages in the bottom. When I change different tabs, as width of these charts and guages vary, it does not look good. So I want to keep same size for all components (meaning same width and height for all Column Charts/Pie Charts/Guages in various tabs) .I do not see any option to check width and height for a component to gave same in other tab like in Web Intelligence. Could you provide me a work around?

BR, Nanda Kishore

Former Member
0 Kudos

Hi,

I shall try this. IS no option avaialble?

BR, Nanda Kishore

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Kishore,

I have few techniques thru which we can maintain uniformity and consistency in size.

1) Copy deisred component from Tab 1 to Tab 2 and make the component size as same (i.e, Copy a Guage from Tab1 and paste it in Tab2 and make size same for both).

It will be a bit time consuming when you have more components in your tab.

2) If your components in all Tabs are same then you can do one thing. Place all the Components in panel under tab 1 then

copy the panel and paste in Tab 2 change the excel mappings and do it for rest.

As many suggested you to use label based menu, that is also a good suggestion but requires lot of effort on Xcelsius design and excel logic.

I hope 1) will be more suitable for you, coz no excel logic.

Hope this might help you.

Regards,

Anjanikumar C.A.

Former Member
0 Kudos

Hi,

Thanks. I shall try and update you.

There is a small change request in my dashboard

The following is the current setup:

1. I have bar chart that shows headcount in absolute numbers 2. Pie chart shows headcount in % 3. Guage one is mapped to Joiners of this month 4. Guage 2 is mapped to Leavers

I created a web Intelligence report country wise and table structue is as follows (this si source for xcelsius)

Country-Headcount-Headcount in %--JoinersLeavers

When ever User click on a country tab either in Column chart (in Xcelsius)or pie chart the two guages change to show relevant country joiners/Leavers. For this I mapped Column chart to entire Joiners (in drill down section of Coulmn) and Leavers data (for source data) and 2 cells as destination cells for the relevant country information.Guage 1 is mapped to just one of destination cell (for joiners) and guage 2 is mapped to 2nd cell (for leavers) so it is working fine. I have used tab set as I need to deatils by City,Department, Gender and Employment Type etc

Now the change request is to show total leavers for month (sum for all counties) default in one guage (Total Leavers in other guage by default ) and relevant country data on a country selection. how to show this default value. Please help.

BR, Nanda.

Former Member
0 Kudos

Hi Kishore,

Now the change request is to show total leavers for month (sum for all counties) default in one guage (Total Leavers in other guage by default ) and relevant country data on a country selection. how to show this default value

In which scenario u need suggestion in Webi or Xcelsius ?

Xcelsius:

1) On the Top of LO objects (Joiners--Leavers) use the sum fucntion.

You can add one more Guage pointer in the existing one. Color them differently and provide legends (make them with rectangles and labels or with a Pie chart).

Webi Level: Simply create on more LO objects use Match pattern in that report.

I got your point but i m confused where actually you need help.

Let me know what you are expecting.

Regards,

AnjaniKumar C.A.

Former Member
0 Kudos

Hi,

Thanks a ton, I need both in Excel and Xcelsisu, as I am not sure how I can build logic in Excel and Xcelsius.

So you are suggesting to add one row that hold total data in excel. But guage can map to one cell. I am not aware that I can add one more pointer, Sorry to ask but where is that option. How this pointer gets hidden when a country is selected. only one pointer need to be shown in the Guage at a time.

BR, Nanda Kishore

Former Member
0 Kudos

Hi Kishore,

I was thinking you need Two guages.

But now i think on right path.

You can add one more row called total that will be leading the rest. you can do this in your Webi report or in excel.

I suggest you to maintain a separate Button which show All Region.

for source take Total value (cells where you have calcualated total)

and assign destination where Guages are mapped.

If this is what you arelloking for let me know we can discuss a lot and i have more idea on it.

Regards,

Anjanikumar C.A.

Former Member
0 Kudos

Thanks

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Is there any workaround? Please help.

BR, Nanda Kishore B