I Have the following measure that i'm trying to get to work.RPAVG( (((([# of unique EntityReference],[DangerousOccuranceType_id])) +( ([# of unique Level1]) - ([# of unique Level1]))) *200000) / ( ([Employee Hours]) + ([Agency Hours]) + ([Contractor ...
Hello, I am having an issue creating a report looking at the week as defined by my dashboard filter versus the previous week as well as the equivalent week in the year before.Basically, I get my 'original' week very easily. We use Last week in the da...
Hi, we are working on building a view similar to this in blox. Does anyone know how to create a view similar to this? White card with a different color back ground?
We have a dashboard that is set up to expect only 1 value in a specific filter. Is there a way we can force users to only select 1 value instead of being able to toggle on the "Allow multiselect for lists" button? Converting the filter to a BloX filt...
I didn't found dashboard usage elastic model in my sisense how should i get that
Hello, I have a dashboard that uses a tabber to shows different dashboards. I also have a different filter under each tabs in tabber. I was wondering if there was a way to clear the filter every time I switch tabs. At this moment, I get no data ( or ...
Hi Team,I have calculated the manufacture share on pivot table at two levels ( Retailer and Category) using the formula:dupcount([custom manufacturer_sort])/(dupcount([custom manufacturer_sort]),all([custom manufacturer_sort]))Now, the default grand ...
Hello,I would like to parameterize a plugin so that it runs every time a widget is refreshed or when a filter value is updated.I know how to achieve this using a widget script and the 'refreshed' event, like this:widget.on('refreshed', (args, el) => ...
Hi Team,I saw a couple of scripts/solutions to rename the Grand Total in the Pivot table however, nothing seems to work maybe due to Linux enironment.Can you help me rename the Grand Total.Also, is there a way, I can use this Grand Total for any othe...
I have created a dashboard, but when i try to edit the widget to add new rows into the dashboard, I don't see the + sign near rows button. Is there any settings which needs to be enabled to perform this action. Please share your thoughts.
Hi Team,I want to custom sort the Pivot Column.See the screenshot attached.In the screenshot, I want to show particular manufacturer as first entry in the column and likewise.Please share the inputs.Thanks
Hi,I would need you help regarding Blox. I am a beginner in Blox and would need you help creating some title banners for my dashboardI want to use Blox as i want to adjust the height of these banners. {"style": "","script": "","titleStyle": [{"displa...
I'm attempting to create an indicator widget that calculates the total number of overdue tickets. It would use two formulas to determine the difference between the total due date day allotment(Ticket must be completed in 30 days as an example) and th...
Hi We need to perform a filter based on dimension values, according to AND and OR logic like (field starts with 1 OR field starts with 2) AND field does not contain 4 Is there a way to perform it? We tried by JAQL but It does not work. Best
