User Profile

Angelina_QBeeQ

ETL

Joined 4 years ago

55 Posts88 Likes17 Solutions

View All Badges

User Widgets

Contributions

Re: Adding static data to widgets
Hi BeckyCrittenden You can change the series type of the value: Kind Regards, Angelina
04-11-2025 Place Help and How-To
918Views
1like
0Comments
Re: Adding static data to widgets
Hey BeckyCrittenden Another option would be to keep it super simple, and just write up a static data formula, What I do in these scenarios; 1. Add a new measure in the chart you’re presenting the Revenue Values 2. Type in a static value for that month’s target; 300k, 350k.. 3. Add it as a line chart, and add value labels That’s it! KISS = Keep it simple and short 😉 You can then repeat that process for other static target values. If these target values are dynamic, and change in your data set for different months like you mention, you can maintain a target value XLS sheet and bring it into your data model as a target table. Then use the MAX/MIN values from there into this new target formula in your existing chart. That way the date filter will change the target value accordingly. Another cool thing you can do is then apply simple conditional formatting to the actual revenue value measures, so you see which months are above or below target. If you have any other questions or if you’d like any help whatsoever in implementing my suggestion above, don’t hesitate to reach out. P.S. we also have a freebie KPI card if you wanna go that way. We’re always here to help Angelina from QBeeQ QBeeQ - Gold Sisense Partner [email protected] Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ news!
04-10-2025 Place Help and How-To
907Views
1like
0Comments
Re: How to create an average line in a bar chart?
Hi lalasisi , You can add aggregation by teams like in the formula: AVG([Condition],sum([Quantity])) Just take you base formula (sum([Quantity]) - in my case) and put it inside AVG([Condition],formula). And replace [Condition] with the column with teams. More about aggregation you can find here: https://docs.sisense.com/main/SisenseLinux/build-formulas.htm Always here to help, Angelina from QBeeQ [email protected] QBeeQ - Gold Implementation and Development Partner
08-29-2024 Place Help and How-To
2.2KViews
4likes
1Comment
Re: Add indentation to pivot cell values
Hi gyanianand , Check the next script for your case: widget.transformPivot( {}, function (metadata, cell) { if (metadata.colIndex == 0 && metadata.rowIndex >= 1) { cell.content = '\u00A0'+cell.content } } ); The script will indent values from the first column in the table. Always here to help, Angelina from QBeeQ [email protected] QBeeQ - Gold Implementation and Development Partner
07-06-2023 Place Build Analytics
1.3KViews
1like
0Comments
Re: How to create a new column with percentiles?
Hi leo82 , You can create a conditional column with percentile function with group by field. In the formula, you need to compare the value with the percentile and write 1 or 0. If the value is greater than the percentile then 1, otherwise 0. And then filter this value by 1. Final table: Always here to help, Angelina from QBeeQ [email protected] QBeeQ - Gold Implementation and Development Partner
05-23-2023 Place Build Analytics
1.9KViews
1like
0Comments
Re: Rank based on each month
Hi Tulu, In some versions, the rank function does not work properly when you need to group by option. What you can try: - Write in rank "rank type" (1234,1224 etc) first and then asc/desc. I saw this issue in version L2023.2. -Try turning off the analytical engine and check the rank again.It may take some time for the changes to be applied. - Discuss the case with Sisense support. - Make a custom table for your needs in the EC. Kind Regards, Angelina
05-16-2023 Place Build Analytics
2.7KViews
1like
0Comments
Re: How do i disable toggle switch button in filterpane?
You can hide all toggles from the dashboard with this script: dashboard.on('refreshstart', (el, args) => { hideFilterToggle(el, args); }); dashboard.on('widgetready', (el, args) => { hideFilterToggle(el, args); }); var hideFilterToggle = (el, args) => { for (index = 0; index < args.dashboard.filters.$$items.length; index++) { $('label.custom-togglebtn__label').remove(); } }
05-16-2023 Place Build Analytics
3.7KViews
1like
0Comments
Re: Reorder columns in pivot table
Hi gyanianand , If you want to reorder rows/columns, use the script below: widget.on('buildquery', function (se, ev) { ev.query.metadata[3].jaql["sort"] = "desc"; // [3] add here the index of your query }); The sample with result and query index here: To hide the column header, you can change the cell value: widget.transformPivot( {}, function (metadata, cell) { if (metadata.colIndex == 0 && metadata.rowIndex == 0) { cell.content = ' ' } } ); Always here to help, Angelina from QBeeQ [email protected] QBeeQ - Gold Implementation and Development Partner
05-16-2023 Place Build Analytics
4.5KViews
2likes
1Comment
Re: How do i disable toggle switch button in filterpane?
Hi frankmol, You can try the next script to hide toggles: var filterText = ['Country','Segment']; // add here the names of the filters dashboard.on('refreshstart', (el, args) => { hideFilterToggle(el, args); }); dashboard.on('widgetready', (el, args) => { hideFilterToggle(el, args); }); var hideFilterToggle = (el, args) => { for (index = 0; index < filterText.length; index++) { var tag = $('span.ew-i-caption:contains(' + filterText[index] + ')', $('div.ew-panel')); $('label.custom-togglebtn__label', tag.parent().parent().parent().parent()).remove(); } } Hope this helps you. Always here to help, Angelina from QBeeQ [email protected] QBeeQ - Gold Implementation and Development Partner
05-16-2023 Place Build Analytics
3.7KViews
1like
2Comments
Re: Rank based on each month
Hi tsaho8 , Try adding asc/desc to your rank formula, like this: Always here to help, Angelina from QBeeQ [email protected] QBeeQ - Gold Implementation and Development Partner
05-16-2023 Place Build Analytics
2.7KViews
2likes
3Comments