Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Members,
This attached Straight Table is having Conditional Dimensions and Expressions. (NULLs and Zeros are suppressed/hidden)
Now, based on some calculated conditions , my chart looks like this in some scenario . It will populate data when the condition matches in other scenarios. (Both are working fine.)
However, is there any function to get the Row Count of the Chart ( 0 in above view). I want to put up a Error Message/ Pop Up for the Users , when the Row Count = 0.
Any help will be useful.
Regards!
You could try it with the following logic:
count({< AnyAppliedConditions >} distinct Dim1&Dim2&Dim3)
whereby the dims here are placeholder for the dimensions in your table and if any conditions are applied within the measures you will need to apply them here, too.
- Marcus
Hi @marcus_sommer ,
Thank you for response.
In my Chart, I have nearly 50 Dimensions and Expressions that are conditional too. That's why I am bit skeptical using them in the formula like this. 🙂
What Set Analysis is this - {< AnyAppliedConditions >} ? Any example please.
Hi @marcus_sommer ,
I tried keeping the all the Dimensions in a Field and using that in a Variable, like this -
vFieldList = Concat (DimensionField, '&')
Then using it is Count, like this -
Count (DISTINCT $(vFieldList )).
Still for the empty chart (what is posted in image), shows a 'value' and NOT ZERO. May be its assuming the Chart has data which are suppressed because of Null or Zero or any other conditions.
Any other magic on top of this?
Regards!
{< AnyAppliedConditions >} means that if a measure in your chart has a condition like: {< Flag = {1} >} you will need to include it within the dimension-value counting, too because otherwise they wouldn't do count on the same dataset.
In general if your chart contained multiple dimensions and (complex) measures with visibility-conditions you will need to fetch them all if you want to do an overall summarizing. This sounds quite complex and troublesome and maybe it is but if you creates such a sophisticated object ...
... maybe it isn't in reality so difficult. I assume that there fields with which the visibility of the dimensions/measures are controlled and this could be used for such a counting, too. Maybe in this way:
count(distinct $(= '[' & concat(DimensionsField, ']&[') & ']')
- Marcus
There might be some additionally logic in regard to your conditions needed.
Beside of this I think there are data available because an object without any data wouldn't be displayed and for such a case is an own message of the object - 'no data available' - therefore there must be something ...
- Marcus