-
Card Filter Issue
Hi All, This is regarding a Filter Chart. I just have two categories and I get a Warning message as 'Warning: Not all the data is show.' Limiting row helps but will that affect my data? How do I fix this? Can you help me, please? Thanks in Advance!
-
Smart Text / Summary Number
Hi Friends, Requesting for your help on this, please. Example I have three columns, 'Student IDs' and 'Course Category' (Science, Math, History) and another column which is 'Location' which I have it in filter Now I wanted to write in a text box. (Dynamic) Location has more number of Course Category students. Example : NY…
-
How to mix and match Data
Number City 1000 A 1100 B 1200 C 1300 D E 1400 1500 F 1300 Hi Folks, Need your help pls. 2 Questions - 1) In the table above, you could see that 1300 is mapped to city 'D' but in last row it is blank. How do I map it using beast mode or Magic ETL to fill by Lookup in the same column. Req: Lookup in 'Number' and fill Blanks…
-
Case Statement with YTD
Hi Folks, I'm trying to derive this through Beast mode calculation. Requirement: Case statement Score 1 - If my error % is 0 - 75% Score 2 - If my error % is 75.1% - 95% Score 3 - If my error % is 95.1% - 100% (Includes 100) Score 4 - If my error % is 100% (YTD) Finding difficulty in writing a case statement for 'Score 4'.…
