Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a chart that has a expression 'count(DISTINCT( if(FlowStatusID='19',MessageID)))'
I want to have 2 input box that define min and max .when type min 0 and max 2 show the expression between 0 and 2. I defind variable but it does not work ok.
this is my chart.
code | count |
0000000000 | 1 |
0010090576 | 1 |
0010230823 | 1 |
0010272313 | 5 |
0010292187 | 3 |
0010330720 | 0 |
0010497684 | 4 |
0010577841 | 1 |
0010622799 | 1 |
0010647783 | 4 |
0010650474 | 3 |
0010704991 | 3 |
0010708340 | 0 |
0010729003 | 1 |
0010747214 | 0 |
0010756019 | 1 |
No I cant upload my real sample. but I want to make a chart with for example 3 dimensions like below table and the expression is this condition in the "count(distinct (if (FlowStatusID=19,MessageID)))" range of input box