-
Is anyone else having a problem with cards breaking with Refresh Card Message?
Cards breaking for no apparent reason and not able to fix them. We have a ticket in, but wondered if anyone else was experiencing this?
-
How to select most recent data for bar chart
Greetings - I recently posted asking about defaulting to the most recent data for a single value chart and got a great solution; now, I'm struggling with the same issue with a stacked bar chart where I don't have the option to use the value from the last row of data. My data is usually updated around noon; until then, I'd…
-
Single value Card - most recent data
I have a single value card that produces the number of hospitalizations today. My dataset is updated everyday at around 3 p.m. I have the date range set to today. I know there must be a way, beast mode or transform, to specify the value from yesterday if today's data is showing zero. FYI, the actual value will only be zero…
-
Uncollapse Columns or Dynamic Pivot or ??
Greetings - I'm working on a Finance Dashboard and I've been given a data set in Excel that pulls metrics from various source files via a VLOOKUP; this is updated monthly with current month and year to date values. I can create most of the cards I need from this data, however, I need to calculate a new metric. The problem…
-
Compare two different metrics year over year
Hi - I'm wanting to create a card that compares two different metrics year over year. Specifically, I want to compare projected profit contribution for the current fiscal year to date to actual profit contribution from the same period last year. I currently have a simple p-o-p card to which I'd like to add a second bar…
-
Date format on YoY chart
Hi - I have a Year over Year by quarter card, and I'd like to have the date format on the x-axis be the quarter number only, i.e. Q1, Q2, etc.. Instead, it defaults to the most recent year. From the knowledge base, it appears that there used to be a macro, %Q, but that was discontinued in the latest release. Can anyone…