User Profile

lring

Cloud Apps

Joined 2 years ago

10 Posts4 Likes1 Solution

View All Badges

User Widgets

Contributions

Re: How can I get the newer style of filters to behave like legacy filters?
🤦‍♀️I can't believe that's all it was, thanks for your help!
07-14-2025 Place Help and How-To
17Views
1like
0Comments
How can I get the newer style of filters to behave like legacy filters?
Hi! A lot of my dashboards were designed so that the end user can select different Facilities in a dashboard filter and export the dashboard as a pdf to then send to the specified facility's staff. We recently upgraded our Sisense version and I discovered that the filters I was using are considered legacy filters, and the new filters don't seem to work the same way. Now when the end user tries to change the Facility selection, the charts still display all of the facilities that have data instead of showing just the bars for the selected facility, and the non-selected bars on the chart just become very translucent. Is there a way to get the new filters to behave the way that the legacy filters do, where the other Facilities will disappear from the chart entirely when not selected? We don't want to send every Facility's data to everyone, we only want each Facility to be seeing their own data, and I don't want to have to create an individual dashboard for every Program/Facility when it should be just a matter of checking different boxes in the filter on a single dashboard. Legacy filter with all Facilities: Legacy filter with one Facility: New filter with one Facility: Thanks!
Solved
07-10-2025 Place Help and How-To
dashboards & reporting
83Views
1like
3Comments
Re: Break by month not in chronological order (displaying 01/2025 before 12/2024)
Hi DRay , I'm not sure if that's what I'm looking for because that example has the date as the X-axis category, and I'm only using the date as the Break By field:
02-06-2025 Place Help and How-To
961Views
0likes
0Comments
Break by month not in chronological order (displaying 01/2025 before 12/2024)
Hi, I have some charts where the Break By is a date field which is displayed as MM/YYYY, and I have the charts filtered to show the Last 2 Months. Now that we're into a new year I've realized that the charts are displaying by numeric month order and ignoring the year, so 01/2025 is before 12/2024. How do I re-order the break by date to show 12/2024 before 01/2025? Thanks!
02-04-2025 Place Help and How-To
dashboards & reporting
1KViews
0likes
4Comments
Re: How to make a column chart value label display N/A for empty columns?
DRay hi again, quick question; in the code you used here, does it still display that way when you save the dashboard as a PDF? My code works great on my dashboard and in the PDF Report Settings preview screen, but after downloading the PDF it loses the N/As from the widget script. Is there something else that I can add to the script to make sure they show up in the PDF export? Thanks!
12-09-2024 Place Help and How-To
1.8KViews
0likes
3Comments
Re: How to make a column chart value label display N/A for empty columns?
I don't speak javascript but I asked ChatGPT to rewrite it based on my goal and the current issue, and it actually worked: widget.on('beforeviewloaded', (scope, args) => { Object.keys(args.options.plotOptions).forEach((chartType) => { const origFn = args.options.plotOptions[chartType].dataLabels.formatter; args.options.plotOptions[chartType].dataLabels.formatter = function (point) { const self = this; return function (point) { const formattedValue = origFn.apply(this, [point]); // Apply the original formatter // Convert the formatted value to a number const numericValue = parseFloat(formattedValue); // If the value is negative, display 'N/A'; otherwise, show the formatted value const value = (numericValue < 0 || isNaN(numericValue)) ? 'N/A' : formattedValue; return value; }; }.call({ original: true }); }); }); So thank you for getting me 99% of the way there, and thank the robots for figuring out the last piece!
12-06-2024 Place Help and How-To
1.9KViews
2likes
0Comments
Re: How to make a column chart value label display N/A for empty columns?
Interesting! That turned all of the labels to N\A, even the ones with actual values
12-06-2024 Place Help and How-To
1.9KViews
0likes
0Comments
Re: How to make a column chart value label display N/A for empty columns?
What would that entail? I guess a more basic question to solve my problem would be: is there a way to have the chart value labels display a string rather than a number, and/or is there a way to use logic to change the value label based on the actual value? The formula that my chart uses as the value is SUM(Total approved_on_time)/(COUNT(event_id) - 1), but by changing it to CASE WHEN ISNULL(SUM([Total apr_on_time])/(COUNT([event_id]) - 1)) THEN -9.99 ELSE SUM([Total apr_on_time])/(COUNT([event_id]) - 1) END, I can have the blank columns display as -999% (or any other random percent I want), so if there was a way to edit the widget script to change any -999% value labels to N/A then that would solve the problem. Or if there was a way to write the value formula to output N/A instead of -9.99, but it gives me an error when I try that (presumably because it's a non-numerical value). Like if I use this as the formula it says Unrecognized Metadata Identifier N: CASE WHEN ISNULL(SUM([Total apr_on_time])/(COUNT([event_id]) - 1)) THEN 'N/A' ELSE SUM([Total apr_on_time])/(COUNT([event_id]) - 1) END.
12-06-2024 Place Help and How-To
1.9KViews
0likes
0Comments
Re: How to make a column chart value label display N/A for empty columns?
Hi David, thanks for replying! That is not correct, what I'm looking for is a way to put N/A on those two blank areas where the red arrows are, because those are technically the "bars" for 8/24 and 9/24 for the Congress St office. The 0% means that there were some number of documents due 10/24 but none of them were approved on time, vs. the blank "bars" which means that there were no documents due for 8/24 or 9/24 for that office, so it's important that there's a distinction between them. Do you know of a good way to achieve this? Thanks!
12-02-2024 Place Help and How-To
2KViews
0likes
1Comment
How to make a column chart value label display N/A for empty columns?
Hi, I have a column chart which displays the % of documents approved on time each month for the past 3 months by location. The value is the total that were approved on time out of the total documents, so a 0% represents that none of the documents were approved on time that month, whereas a blank bar represents that there were no documents for that month/office. For the blank bars I want the value labels to say N/A because without any bars it's really difficult to tell which month is which, but I'm not sure how to achieve this. Thoughts? I did add some dummy data into the dataset so that even in months when an office doesn't have any documents, a row still exists for that office/month, with nulls for all of the document data including the approved_on_time field. In the document rows, approved_on_time is 1 if it was approved on time and 0 if it wasn't. I added the dummy data so that even when there are no documents for a particular office/month, the chart will still display all 3 months with no bars (rather than showing a No Results chart).
Solved
11-27-2024 Place Help and How-To
dashboards & reporting
2.2KViews
0likes
12Comments