I'm facing a weird issue with Sisense Blox plugin and can't figure out the solution to fix the issue.
I set up the widget using Live Model in a Blox plugin like as the attached file below. In Values section, I have `TotalImps` that will get total of impressions on the data displayed in the widget (No dimension breakdown) with the formula in the screenshot.
The setup is working well for the most of data case, however, there is only one data case has a problem that always return 0 (zero) value on TotalImps (there is no null value in data).
I did check the query in Postgres log and figured out the query generated by Sisense has a wrong one, it always return 0 on the field
(0) AS "snsGud_0400"
Please see the whole query at https://drive.google.com/drive/folders/197bRY44Nu9D7sopi3yB20iFgg6runf-0?usp=sharing
I'm wondering if this is a bug of Sisense and wondering if we have any fix or workaround to bypass this issue?
Please sign in to leave a comment.