Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm in doubt if I'm doing something wrong.
I have a table with dimensions and measures. On the measure I have a Set Analysis that limits the date range to last three months. All is working fine, no problem, data is only shown for the last three months.
Then I add a cell color condition with a IF-statement and then all rows are shown. It's like the Set Analysis is overrulled by the IF statement.
What I'm I doing wrong?
Br Thomas
May be uncheck 'Include zero values' under Add-Ons -> Data handling
Hi Thomas,
If you are using the same expression in the color condition you must add the same set analysis in order to keep the same data shown.
Carlos M
Hi carlosamonroy,
Okay, but how would you construct a calculation that uses Set Analysis and chooses a color depending on comparison?
Br Thomas
Would you be able to share the expression you are using right now?
The same way you are doing it in the expression.
Measure:
sum({<Field1={'abc'},Field2={'def'}>}Value)
Color condition:
if(sum({<Field1={'abc'},Field2={'def'}>}Value) > 90,RGB(255,0,0),RGB(0,255,0))
Thanks carlosamonroy
carlosamonroy, I stand corrected, it doesn't work
Here's the code:
gvCurrentMonthM3FirstDate = 01-03-2017
gvLastMonthLastDate = 31-05-2017
Measure
=Sum({$<[Created date]={'>=$(gvCurrentMonthM3FirstDate) <=$(gvLastMonthLastDate)'}>}([Month lengh]-[Solution duration])/[Month lengh])
Text condition
If(Sum({$<[Created date]={'>=$(gvCurrentMonthM3FirstDate) <=$(gvLastMonthLastDate)'}>}([Month lengh]-[Solution duration])/[Month lengh])<Target, Red(),Green())
The last four lines should not be shown.
May be uncheck 'Include zero values' under Add-Ons -> Data handling
Can you try using the following expression:
=Sum({$<[Created date]={'>=$(gvCurrentMonthM3FirstDate) <=$(gvLastMonthLastDate)'}>}[Month lengh]-[Solution duration])
/
Sum({$<[Created date]={'>=$(gvCurrentMonthM3FirstDate) <=$(gvLastMonthLastDate)'}>}[Month lengh])
That's the one. Thx stalwar1