Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have created a bar chart.
Dimensions used:
Month
CDE Name
Expression Used:
aggr(sum(Failing Records),CDE,Month)
This is working fine. When I select a Month, the report is displaying data for one particular month. I want to ignore selections based on Month.
Is this possible?
Thanks in advance!
Kind Regards,
Varun
Can you try this:
Sum({<Report Date]>} Aggr(Sum({<Report Date]>} [Ruleset Failing Records]), [CDE Name], [Report Date]))
or
Only({<Report Date]>} Aggr(Sum({<Report Date]>} [Ruleset Failing Records]), [CDE Name], [Report Date]))
Can you try this:
Sum({<Month>} [Failing Records])
or
Sum({<Month>} Aggr(Sum({<Month>} [Failing Records]), CDE, Month))
try
Only({<Month-={'Monthname'}>}Failing Records)
=Only(aggr(Total <Failing Records>),CDE,Month)
Hi Sunny,
This is not working
Hi Chanty,
I want to ignore any selection for Month
Would you be able to show a sample showing the issue? There is not other way I can think of ignoring selections.
May be:
aggr(sum({<Month=>}Failing Records),CDE,Month)
HC.
Hi Henry,
Already tried this. But it is not working