Drag into rows instead of columns and check if this works.
It will not work in my scenrio i want in columns only.
Have you tried combining both the calculated field in one field like this?
IF [Page1]>=0 THEN 'Page 1 Count'
ELSEIF [Page2]>=0 THEN 'Page 2 Count'
If above doesn't work then try to aggregate with SUM() like SUM([Page1]) ect else share some sample mock up data.
You remember what we did that yesterday , last 3 weeks same day avg and that subtraction for ( page 1 -page 1 login)
but now the client has done this subtraction on query only and now they'v not given me metrics dimension now they've given me direct PAGE 1 count , PAGE 2 count and PAGE 3 count and i have to create the same scenario like this
And I've attached the sample data.
Test1.xlsx 10.4 KB
I've edited and attached the sample data.