Jack94 Posted October 31, 2022 Report Share Posted October 31, 2022 Hi, I'm building a datapage and I'm trying to use this formula in pivot value. SELECT Count(columnname) FROM _v_viewname WHERE [@field:columnname]='value' It doesn't work. Any solution? Quote Link to comment Share on other sites More sharing options...
0 Kurumi Posted October 31, 2022 Report Share Posted October 31, 2022 Hi @Jack94 - what are you trying to achieve in this formula? What is your workflow? For reference, you may check this article: https://howto.caspio.com/function-reference/ Quote Link to comment Share on other sites More sharing options...
0 Jack94 Posted October 31, 2022 Author Report Share Posted October 31, 2022 Hi @Meekeee I need to count a set of records from one column view. But only 'value' matches in that column. Thanks for your assistance. Quote Link to comment Share on other sites More sharing options...
0 cheonsa Posted December 26, 2022 Report Share Posted December 26, 2022 Hello @Jack94, If your Data Source is also _v_viewname, you may try this instead of using a formula. Quote Link to comment Share on other sites More sharing options...
Question
Jack94
Hi,
I'm building a datapage and I'm trying to use this formula in pivot value.
SELECT Count(columnname) FROM _v_viewname WHERE [@field:columnname]='value'
It doesn't work.
Any solution?
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.