Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I am hoping some one can help me with a chart splitting issue I am having.
I have created a chart, based on time calculations, where I am simply taking the sum of the end date & time away from the sum of the start date and time.
I do this for 3 different tiers, so the chart splits and is stacked by the 3 tier calculations and then the dimension splits it by each country.
So my calculation for each Tier is as follows; (Substituting the Tier 1 for Tier 2 and Tier 3 etc.
sum({<AT_Tier={'Tier 1'}>}ActivityEndDate) - Sum({<AT_Tier={'Tier 1'}>}ActivityStartDate)
/
(sum({<AT_Tier={'Tier 1'}>}ActivityEndDate) + Sum({<AT_Tier={'Tier 2'}>}ActivityEndDate) + sum({<AT_Tier={'Tier 3'}>}ActivityEndDate) )
-
(Sum({<AT_Tier={'Tier 1'}>}ActivityStartDate) + Sum({<AT_Tier={'Tier 2'}>}ActivityStartDate) + Sum({<AT_Tier={'Tier 3'}>}ActivityStartDate))
So the logic is that I sum the amount of time spent in Tier 1 / the amount of time spent in all 3 Tiers. (The reason I need to define the 3 tiers in the 'All' calculation, is because we have some strange data in there outside of the 3 tiers that I don't want to include) Then I make this a % using the number settings in the chart. This then shows me the % of time spent by each country in each Tier as a stacked bar.
The Problem:
When I do this the chart levels all of the country's to the same value, and dose not give me the correct % breakdown by tier until you click into that individual country. Some of these countries don't even have data, but yet they all display as having the same % Value. See example chart below:
When you click on the country it then splits correctly. See example below:
Is there a way to make the correct values display from the beginning, so that I can show all of the countries (with data) splitting correctly side by side?
For example France should display as see above, and then UK&Ireland would have a different mix of % in Tiers, unlike in the first example chart where each country displays the exact same?
I would really appreciate any help anyone could give me with this as it is the last thing to fix before this app goes live and I have tried everything with no success.
Thanks