Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
There is an option in Chart Property in Dimension Limit tab.
Chart Property->Dimension Limit tab->
Option Group Box
Check The Show Total Checkbox and label it
Thanks Nishit but, the new bar added is not segmented.
I think you need to add these TOTAL as an additionally dimension-value and respect this within your expression. This could be done with a calculated dimension like:
=valuelist($(=concat(distinct Month, ',')), 'Total')
and as expression someting like:
pick(match(valuelist($(=concat(distinct Month, ',')), 'Gesamt'), 1,2,3,4,5,6,7,8,9,10,11,12,'Gesamt'),
sum({< Monat = {1}>} [YourKPI]),
sum({< Month = {2}>} [YourKPI]),
sum({< Month = {3}>} [YourKPI]),
sum({< Month = {4}>} [YourKPI]),
sum({< Month = {5}>} [YourKPI]),
sum({< Month = {6}>} [YourKPI]),
sum({< Month = {7}>} [YourKPI]),
sum({< Month = {8}>} [YourKPI]),
sum({< Month = {9}>} [YourKPI]),
sum({< Month = {10}>} [YourKPI]),
sum({< Month = {11}>} [YourKPI]),
sum({< Month = {12}>} [YourKPI]),
sum({< Month = p(Month)>} [YourKPI]))
You might need some small adjustments to respect the year and/or a switch over a year or similar. But if add (per concatenate) these TOTAL within the script, maybe in an parallel field only for these purpose it would be easier to handle within the gui because you need only to query if your dimension-value is TOTAL or not.
- Marcus
thanks for the tips, but I'm using an cyclic group type of date. To drill down different dates.
how can I apply it to a cyclic type date
Thanks
Don
You could use the same approach like above with several calculated dimensions in a dimension group, like:
=valuelist($(=concat(distinct Date, ',')), 'Total') //Date
=valuelist($(=concat(distinct Week, ',')), 'Total') //Week
=valuelist($(=concat(distinct Month, ',')), 'Total') //Month
=valuelist($(=concat(distinct Year, ',')), 'Total') //Year
and the expression will be a bit longer and queried which dimension from the group is active:
pick(match(subfield(getcurrentfield(YourDimensionGroupName), '//', 2), 'Date', 'Week', 'Month', 'Year'),
..., // pick(match() expression like above only per Date or maybe on DAY
pick(match(valuelist($(=concat(distinct Month, ',')), 'Gesamt'), 1,2,3,4,5,6,7,8,9,10,11,12,'Gesamt'),
sum({< Monat = {1}>} [YourKPI]),
sum({< Month = {2}>} [YourKPI]),
sum({< Month = {3}>} [YourKPI]),
sum({< Month = {4}>} [YourKPI]),
sum({< Month = {5}>} [YourKPI]),
sum({< Month = {6}>} [YourKPI]),
sum({< Month = {7}>} [YourKPI]),
sum({< Month = {8}>} [YourKPI]),
sum({< Month = {9}>} [YourKPI]),
sum({< Month = {10}>} [YourKPI]),
sum({< Month = {11}>} [YourKPI]),
sum({< Month = {12}>} [YourKPI]),
sum({< Month = p(Month)>} [YourKPI])),
..., // pick(match() expression like above only per Week
...) // pick(match() expression like above only per Year
Not extremly nice but it should work. You should also consider to use several charts each specialized to a certain dimension or other things to keep the things simpler - maybe within a container and/or nested containers.
- Marcus
Thanks Guys
I already got it
If your question is now answered, please flag the Correct Answer and possible helpful answers.
If not, please let us know with which part of this topic we can still help you .