-
Upload Spreadsheet Large Files Connector - Not uploading all data
Hi All, I have a dataset that I need to update using the Upload Spreadsheet Large Files connector, however when I drop in the new dataset it only seems to import 31,074 rows of data when it should be a couple of hundred thousand. For reference I've tried uploading as a CSV & an excel workbook - does anyone know why this is…
-
How to show the series list in order (largest to smallest on a symbol line graph?
Hi all, Just a quick question on using a symbol line graph, is there any way to have the key shown in the same order as the data is presented on the chart? I.e. in the example below I'd like the triangle to be at the top of my list, then the square etc. Thanks in advance!
-
How to show values on the pie chart instead of beneath?
Hi All, One of my cards on a dashboard is a pie chart, is anyone aware of how to show the totals on the pie chart instead of beneath? Is there also a way to show the numbers with consistent abbreviation? For example I'd like ot show it all in billions whereas at the minute it shows one number as billions, one as millions…
-
Can you fix the headers in a pivot table
Hi All, I have a pivot table in my dashboard showing a last 12 month trend in the columns and a list on people in the y column - the issue I'm having is if I filter for a specific person then the columns with no data disappear i.e. if there is only quarterly data my picot will only show 4 columns. Ideally I want to fix the…
-
How to show a month position as at 12 months ago
Hi all, I'm working on a set of data and for one of my cards I would like to show a pie chart of the total position for the current month and a separate pie chart for the position as at 12 months ago. I'm not sure how best to show this as the date options only seem to allow for the cumulative last 12 months - I could…
-
Converting to Integer
Hi All, In my ETL I am loading 2 columns for Credit & Debit, as part of my ETL I want to do Credit-Debit to get a column for amount however the data being loaded is recognising the Credit & Debit as text. I've tried to use the alter columns tile in my ETL to convert to an integer however it doesn't appear to be working.…
-
Period over period cards interactions with filters
Hi All, In one of my reports we're using a dataset that refreshes daily but at the end of the month we have to wait a few days for pricing on accounts to settle so the report will re-run the prior month position until rolled forward. The issue I'm having is when it comes to the end of the month all of my cards that are…
-
How to show a unique count for a different period than the selected date range?
Hi All, I have a card where I am showing a year to date breakdown of assets, in order to show this I have 'This Year' selected for my date range. However ideally I want to show a count of unique accounts as at the end of the prior year, a count of unique accounts as at the end of the current month and the difference…
-
Is there any way to hide cards on a scheduled report?
Hi All, I want to publish one of my dashboards as scheduled report however I have a few cards at the bottom of the report for validation - is there any way to keep these on my dashboard but to hide them in the scheduled report? Any help would be greatly appreciated!
-
How to change smart text in the card title to show current date/ last updated date?
Hi All, In one of my dashboards I have various cards that update daily, ideally I would like the last updated date to update in the title when refreshed so it would read "PM AuM & Flows (Mth) by Service Type (£000's) as at 23rd February 2024". I've tried using smart text in the title to use the last updated date but this…
-
Pivot table conditional formatting for text and column totals to the left
Hi, I have a card where I need to show a % total of an opening number and would like the text to be green if 100% or greater and red if less than 100% - in the chart properties I can set colour rules but this only seems to apply to the fill colour, is there any way to have the fill colour remain the same but have the text…
